I have a table which looks like this: date user_id active_dt last_active_day 2020-01-01 1 null null 2020-01-02 1 null null 2020-01-03 1 null null 2020-01-04 1 2020-01-05 null 2020-01-05 1 2020-01-08 2020-01-05 (as of 2020-01-05, the last actve date was…
I have a dynamo db table where I was able to insert data using node js via lambda. I am able to query from the console and I am also able to query using the cli. When using query with…
I have some EC2 instances in a private subnet (as part of a larger EKS cluster) in Account A. There is a containerized application running on these EC2 instances that reaches out to S3 for some data to process. The…
I have successfully installed the AWS EBS CSI driver to my EKS cluster. This is meant to be using the "IAM Role for Service Account" technique. I am trying to utilise the checkout example app that AWS have given here…
I am trying to sum a timestamp with a time that I have to cast from varchar to time. This is my attempt: select my_timestamp + cast(my_str_time as time) as my_end_time from my_db.my_table; my_timestamp format (already a timestamp): 2022-07-16 02:51:11…
Is it possible to somehow grant permissions to ALL available databases in Lake Formation? Using the AWS UI I'm able to grant permission to individual databases. However I'm looking for a way to grant permissions to all available databases. Is…
I need to upload an image to S3 using signed URL. I have the image in a base64 string. The below code runs without throwing any error, but at the end I see a text file with base64 content in…
A service runs on ECS and writes the requested URL to a DynamoDB. Dynamic scaling was activated to keep the costs for DynamoDB from becoming too high. DynamoDB scales slower than requests are coming in at any given time, so…
I am not able to identify what is causing my ec2 disk space to reach 100% of capacity. I have a script which deletes files in tmp folder.But still randomly sometimes my disk capacity reaches 100%. I have attached the…
I'm trying to connect my friend's MySQL database remotely but I'm getting connection timeout error. I tried to ssh. But same result. Then I check that instance. It has public IP. Also allowed 3306 and 22 ports on the security…