Create Schema on Amazon Redshift

Query to create SCHEMA on Amazon Redshift

July 28th, 2020,

The query below allows you to create a SCHEMA on your Amazon Redshift instance using the AWS query editor. In this example we will create a SCHEMA named "new_Schema" and gives ownership to the default user "dbuser"

create schema new_schema authorization dbuser;


schema name: The given name to the schema created. in this example: "new_schema".
Authorization: Allows to give ownership to a specific user. In this example: "dbuser".

How ERBuilder Helps

ERBuilder Data Modeler is a GUI data modeling tool that allows you to visualize, design and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases including Amazon Redshift. Generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare and schema synchronization. Try now ERBuilder for 15 days FREE


Subscribe To Our Newsletter

Subscribe to our email newsletter today to receive updates of the latest news, tutorials and special offers!