If you delete an SQS queue, all the messages in the queue will be deleted as well. To delete an
Continue readingHow to send a message to an SQS queue using Lambda when a file is uploaded to an S3 bucket
In this post I’ll show you how to send a message to an SQS queue when a new file is
Continue readingHow to create an SQS queue from AWS CLI
Use the below command to create a new queue where queuename is the name of the queue being created. create-queue
Continue reading
How to cancel a running query in Redshift
Run the below query to identify the query that needs to be cancelled and copy the ‘pid’. select pid, user_name,
Continue readingHow to allow public access to a folder in S3 bucket
To make a prefix of an S3 bucket publicly readable, add the below policy to the bucket. { “Version”:”2012-10-17″, “Statement”:
Continue readingHow to make an entire S3 bucket public
Add the below bucket policy to make the entire bucket publicly accessible.
Continue reading
How to drop a materialized view in Redshift database
Use the below command to drop a materialized view where mv_name is the name of the materialized view. DROP MATERIALIZED
Continue reading
How to copy data from a file in S3 bucket to Redshift tables
Copy using iam role: copy schemaname.tablename from ‘s3://bucketname/filename’ iam_role ‘arn of iam role’ DELIMITER ‘|’ ESCAPE; Copy using credentials: copy
Continue reading
How to insert data into Redshift tables.
Below is the syntax to insert a row into redshift table using sql statement. The list of values should be
Continue reading
Delete an EBS Volume from AWS CLI
Use the below command to delete an EBS volume that is ‘available’ (i.e) not attached to any EC2 Instance. delete-volume
Continue reading