In Snowflake is not allowed to define a quota per scheme. Storage management is done at the account and warehouse level, and Snowflake handles it automatically. For this reason it is removed from the code.
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
CREATE SCHEMA AUTHORIZATION miller;
Output Code:
OUT -> Redshift_04.sql
CREATE SCHEMA IF NOT EXISTS miller
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "redshift", "convertedOn": "09/23/2024" }}'
;
Related EWIs
There are no known issues.
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 .