📦
Object types
Object types are sorted in execution order. See explanation after the table.
Object type | CREATE | COMPARE | DROP | Notes |
|---|---|---|---|---|
ACCOUNT_PARAMETER | N/A | UNSAFE + | N/A | ACCOUNTADMIN, skip on empty config |
NETWORK_POLICY | UNSAFE | UNSAFE | UNSAFE | SECURITYADMIN |
RESOURCE_MONITOR | UNSAFE | UNSAFE | UNSAFE | ACCOUNTADMIN |
WAREHOUSE | SAFE | SAFE | SAFE | ACCOUNTADMIN to assign RESOURCE_MONITOR |
WAREHOUSE_ROLE | SAFE | SAFE | SAFE | |
DATABASE | SAFE | UNSAFE | UNSAFE | |
SCHEMA | SAFE | UNSAFE | UNSAFE | |
SCHEMA_ROLE | SAFE | SAFE | SAFE | |
FILE_FORMAT | SAFE | SAFE | SAFE | Short hash |
STAGE | SAFE | SAFE and UNSAFE | UNSAFE | |
SEQUENCE | SAFE | SAFE | UNSAFE | |
FUNCTION | SAFE | SAFE | SAFE | Short hash |
EXTERNAL_FUNCTION | SAFE | SAFE | SAFE | Short hash |
PROCEDURE | SAFE | SAFE | SAFE | Short hash |
TABLE | SAFE | SAFE and UNSAFE + | UNSAFE | |
EVENT_TABLE | SAFE | SAFE and UNSAFE | UNSAFE | |
DYNAMIC_TABLE | SAFE | SAFE and UNSAFE | UNSAFE | |
EXTERNAL_TABLE | SAFE | SAFE | SAFE | Short hash |
PRIMARY_KEY | SAFE | SAFE | SAFE | |
UNIQUE_KEY | SAFE | SAFE | SAFE | |
FOREIGN_KEY | SAFE | SAFE | SAFE | |
STREAM | SAFE | UNSAFE | UNSAFE | |
MATERIALIZED_VIEW | SAFE | UNSAFE | UNSAFE | |
VIEW | SAFE | SAFE | SAFE | |
PIPE | SAFE | UNSAFE | UNSAFE | Short hash |
TASK | SAFE | SAFE | SAFE | Short hash |
MASKING_POLICY | UNSAFE + | UNSAFE + | UNSAFE + | |
ROW_ACCESS_POLICY | UNSAFE + | UNSAFE + | UNSAFE + | |
SHARE (outbound) | UNSAFE + | UNSAFE + | UNSAFE + | |
TECH_ROLE | SAFE | SAFE | SAFE | |
BUSINESS_ROLE | SAFE | SAFE | SAFE | |
USER_ROLE | SAFE | SAFE | SAFE | |
USER | SAFE | UNSAFE | UNSAFE | |
ALERT | SAFE | SAFE | SAFE | |
ACCOUNTADMINnote means that only user with this role can apply this change. It should be applied by human administrator manually or by SnowDDL user having this role automatically.Short hashnote means that objects of this type will have a short hash added tocomment. It is explained in Short hash guide.- In some cases both "safe" and "unsafe" changes can be applied to the same object type and operation type. Please refer to specific object type documentation for more details.
Last modified 2mo ago