Login to the AWS Management Console and navigate to SQS service. If you are using SQS for the first time,
Continue readingCategory: How-To Guides
How to delete an SQS queue from AWS Management console
Login to the AWS Management Console and navigate to the SQS service dashboard. You will see the list of queues
Continue readingHow to delete an SQS queue from AWS CLI
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