Amazon web services – Best way to select random rows in redshift without order by
i have to select a set of rows (like 200 unique rows) from 200 million rows at once without order by and it must be efficient.
Amazon web services – Database access denied for AWS RDS proxy
I have setup a RDS proxy for Aurora DB. I am able to connect to the RDS proxy endpoint but not able to perform any operations. For e.g if I do show processlist; I get below error: ERROR 1045 (28000):…
Amazon web services – Execute shell script string array in a particular order
I have an array of AWS Cloudformation stacks names in stackList. Now this contains all the stacks in my AWS account, I want to delete them, but in a particular order. Lets say the stackList contains the following string array:…
Amazon web services – Load balancer not redirecting ports?
I have a node server running on an ec2 instance with AWS from port 3000 as the ec2-instance accessed through putty doesn't let me use port 80 which I assume is because it is already in use from something else.…
Amazon web services – Can you create AWS accounts from member accounts?
I am creating an AWS organization and some member accounts within their own OUs (organizational Unit). Is there a way to create new accounts in the OUs from the member accounts or is the only way to create new accounts…
Amazon web services – How to prevent AWS Glue crawler from reading wrong data types?
I am running AWS Glue crawler on a CSV file. This CSV file has a string column which has alpahanumeric values. The crawler is setting the data type for this columns as INT (instead of string). This is causing my…
Amazon web services – using a single Dynamodb resource in terraform and create 3 tables with different names
I have a used case where, I need to create 3 dynamodb tables but only the naming convention changes resource "aws_dynamodb_table" "GB_SKU_COLOR" { name = "GB_SKU_COLOR_${var.stage}" billing_mode = "PAY_PER_REQUEST" hash_key = "PRODUCT_ID" stream_enabled = true stream_view_type = "NEW_AND_OLD_IMAGES" attribute {…
Amazon web services – AWS – Autoscaling execute userdata when in Stopped state
I was wondering if 'UserData' can be executed even when the EC2 instances in the Auto-Scalin-Group Warm-Pool are initialized with 'Stopped' state, I know when they are initialized and are in 'Running' state, the userdata executes. Note: I am using…
AWS-CDK and Gitlab returns Error: spawnSync docker ENOENT
I am trying to run a Gitlab pipeline that builds an AWS-CDK project via the cdk-synth command. I have followed advice online in terms of what images I should be using in the Gitlab runner but I am running into…
Amazon web services – How to use AWS System Manger with Amplify
I have an AWS Amplify App and I am storing secrets in the AWS System Manager parameter store. According to the documentation, I followed this syntax /amplify/{your_app_id}/{your_backend_environment_name}/{your_parameter_name} and created this parameter /amplify/abcdefgh1234/dev/MY_PARAM. How do I use MY_PARAM in amplify.yaml? When…