Category: Redshift

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

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

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;

Connection limit is the maximum number of concurrent connections that a user is allowed to have against a particular redshift

Use the below command to rename a schema in Redshift where current_schema_name is the current name of the schema and

Check the current quota and disk usage of the schema by running the below query where schemaname is the name

You can view the current owner of a schema by running the below query where schema_name is the name of