SQL RUNNER & DATABASE (HowTo): Create Schema in SQL Runner

Knowledge Drop

Last tested: Oct 23, 2018
 

It is possible to create a new schema in the database by sending the command from SQL Runner
eg: CREATE SCHEMA schema_name ; (Redshift syntax)

⚠️ One thing to know is that the schema may not appear in the system after the creation until a table is added to the schema!

 ⚠️ User must also have CREATE permission on db http://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html

This content is subject to limited support.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: