CREATE SCHEMA
Grammar Syntax
For more information please refer to Redshift CREATE SCHEMA
documentation.
Sample Source Patterns
Basic samples
Input Code:
IN -> Redshift_01.sql
Output Code:
OUT -> Redshift_01.sql
Authorization Clause
Input Code:
IN -> Redshift_02.sql
Output Code:
OUT -> Redshift_02.sql
Please be aware that for this case, the authorization clause is removed from the code since Snowflake schemas are owned by roles, not individual users. For more information please refer to Snowflake GRANT OWNERSHIP
documentation.
Quota Clause
Input Code:
IN -> Redshift_03.sql
Output Code:
OUT -> Redshift_03.sql
Create Schema Authorization
In Redshift when the schema name is not specified but the authorization clause is defined, a new schema is created with the owner's name. For this reason this behavior is replicated in Snowflake.
Input Code:
IN -> Redshift_04.sql
Output Code:
OUT -> Redshift_04.sql
Related EWIs
There are no known issues.
Last updated