AWS bytes

How 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

You can revoke the super user privileges previously granted to a database user by running the below sql command where

To grant super user privileges to an existing database user, login as a super user (master user created during the

You might want to temporarily or permanently disable a Redshift database user account. You can achieve this by changing the

You can find the number of objects in an S3 bucket by running the below command from AWS CLI where

Use the below query to determine when a particular table was created in Redshift database. Replace <your schema name> with

Run the below query to list all the user defined schemas of a Redshift database: select distinct “database”, “schema” from

Below is the command to change the owner of a database. You need to login as superuser to run the

You cannot change the name of a database that you are currently connected to. To rename a database, login as

Use below commands to create a new database in the Redshift Cluster. CREATE DATABASE database_name; CREATE DATABASE database_name OWNER owner_name;