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;
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 email newsletter today to receive updates of the latest news, tutorials and special offers!