To delete all the messages in an SQS queue without deleting the queue itself, use the purge option as below:
Continue readingHow to purge messages from an SQS queue from AWS Management Console
Login to the AWS Management Console and navigate to ‘Simple Queue Service’ SQS. on the SQS dashboard, select the queue
Continue readingHow to delete unused EBS volumes from AWS CLI to save on cost
Use the below command to generate a list of volume id’s of all detached EBS volumes. aws ec2 describe-volumes –filter
Continue reading
How to configure a dead-letter queue for an existing SQS queue
Create a new queue to receive the undeliverable messages using the steps outlined here from the console or here using
Continue reading
How to find the size of a Redshift database
To determine the size of a database in Redshift cluster, use the below query. SELECT database, SUM(size) as “size in
Continue reading
How to find the size of a schema in Redshift
Use the below query to determine the size of all schemas in Redshift database. SELECT schema, SUM(size) as “size in
Continue reading
How to find the size of a table in Redshift
SVV_TABLE_INFO view shows information of all user-defined tables.Use the below query to determine the size of a table in Redshift
Continue readingHow to create an SQS queue from AWS Console
Login to the AWS Management Console and navigate to SQS service. If you are using SQS for the first time,
Continue readingHow 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 reading