SnowDDL
Search…
πŸ“¦
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
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
SAFE
Short hash
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
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
​

Notes

  • Safe & unsafe operations are explained in "Safe & unsafe DDL" guide.
  • Some role types are generated dynamically. You may read more in Role hierarchy guide.
  • + means that additional setting or CLI argument is required to apply this change.
  • ACCOUNTADMIN note 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 hash note means that objects of this type will have a short hash added to comment. It is explained in Short hash guide.
Copy link