Login to your AWS account from AWS Management Console and expand the dropdown menu next to your account name on
Continue readingCategory: How-To Guides
How to delete an S3 bucket
From AWS CLI Here is the command to delete an s3 bucket where bucketname is the name of the bucket
Continue readingHow to get the canonical id of your AWS account
From AWS Command Line Interface, run the below command to get the canonical id of your AWS account. aws s3api
Continue readingHow to get the account id of your AWS account
Logon from the AWS Management Console. Expand the dropdown next to your username on the right top corner. You will
Continue readingHow to Revoke super user privileges from a Redshift database user
You can revoke the super user privileges previously granted to a database user by running the below sql command where
Continue readingHow to grant super user privileges to a Redshift database user
To grant super user privileges to an existing database user, login as a super user (master user created during the
Continue readingHow to disable a Redshift database user
You might want to temporarily or permanently disable a Redshift database user account. You can achieve this by changing the
Continue readingHow to determine the number of objects in an s3 bucket
You can find the number of objects in an S3 bucket by running the below command from AWS CLI where
Continue readingHow to determine the creation time of a table in Redshift database
Use the below query to determine when a particular table was created in Redshift database. Replace <your schema name> with
Continue readingHow to List all user defined schemas of a Redshift database
Run the below query to list all the user defined schemas of a Redshift database: select distinct “database”, “schema” from
Continue reading