What is the best way to explode a comma separated column based on specific conditions? I have some data in the following format: ID col1 1 a100,a101,b100,c100 2 a105,b100 3 b101, c104 what I want to achieve is to: grab…
I'm working on a project I have inherited and need to connect to an AWS EC2 instance. But I can not seem to connect to it. If I go into the EC2 Console, select the instance then connect. I would…
So we have recently uploaded a new enviornment for our product We are using python 3.8 Elastic beanstalk is of application type This is my Auto Scaling group configuration These are myscaling triggers configuration I can see there are few…
Today i have an error when trying to deplyo my amplify app It says: ✖ There was an error initializing your environment. 2023-03-15T15:49:07.075Z [INFO]: 🛑 No package manager found. 2023-03-15T15:49:07.075Z [INFO]: Resolution: Install npm or yarn to compile overrides for…
I am trying to disable the cloudwatch alarm actions using lambda function as provided by following article "https://medium.com/geekculture/enable-or-disable-aws-alarms-at-given-intervals-d2f867aa9aa4". However i am facing timeouts during it's execution. The http request for generated does not return any error. The code is as…
I have set up an on-demand video service in AWS. After uploading a video to the S3 input bucket, a Lambda function is automatically triggered, which does HLS streaming with the object to a specific folder in the output bucket.…
https://www.jnto.go.jp/jpn/statistics/since2003_visitor_arrivals.xlsx I have the above public website. The website or file is updated once a month by the admin of that website. Can you please tell me how to trigger State machine when that above website is updated? I have…
I have downloaded the AWS glue script from my Dev environment by clicking "Download" as a JSON file which include Job parameter and other info as well other than the code. When i upload to my production environment by clicking…
In my main.tf file I have: terraform { required_providers { aws = { source = "hashicorp/aws" version = "~> 4.16" } } required_version = ">= 1.2.0" } provider "aws" { region = "us-west-2" } When I run terraform plan, I…
I am trying to delete an aws-s3-bucket. Before deletion of the s3 bucket, all objects inside the bucket must be deleted. AWS provides an api endpoint for this task: https://docs.aws.amazon.com/AmazonS3/latest/API/API_DeleteObjects.html It accepts keys of the object to be deleted. I…