SnowDDL
Search
K
📦

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

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 might be 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.
  • 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.