How to Create a Database in Redshift Cluster

Use below commands to create a new database in the Redshift Cluster.

CREATE DATABASE database_name;                                        
CREATE DATABASE database_name OWNER owner_name;                       
CREATE DATABASE database_name OWNER owner_name CONNECTION LIMIT value;

To change the owner of a database:

ALTER DATABASE database_name OWNER TO new_owner_name;  

To rename a database:

ALTER DATABASE database_name RENAME TO new_database_name;  
See also  How to access S3 from EC2 Instance using IAM role

Leave a Reply

Your email address will not be published. Required fields are marked *