📦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
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
SECRET	SAFE	SAFE	SAFE
NETWORK_RULE	SAFE	SAFE and UNSAFE	UNSAFE	ALTER is safe, REPLACE is unsafe
EXTERNAL_ACCESS_INTEGRATION	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
HYBRID_TABLE	SAFE	UNSAFE	UNSAFE	Short hash
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
MATERIALIZED_VIEW	SAFE	UNSAFE	UNSAFE
VIEW	SAFE	SAFE	SAFE
PIPE	SAFE	UNSAFE	UNSAFE	Short hash
STREAM	SAFE	UNSAFE	UNSAFE
TASK	SAFE	SAFE	SAFE	Short hash
ALERT	SAFE	SAFE	SAFE
SHARE (outbound)	UNSAFE +	UNSAFE +	UNSAFE +
TECHNICAL_ROLE	SAFE	SAFE	SAFE
BUSINESS_ROLE	SAFE	SAFE	SAFE
USER_ROLE	SAFE	SAFE	SAFE
USER	SAFE	UNSAFE	UNSAFE
AGGREGATION_POLICY	UNSAFE +	UNSAFE +	UNSAFE +
AUTHENTICATION_POLICY	UNSAFE +	UNSAFE +	UNSAFE +
MASKING_POLICY	UNSAFE +	UNSAFE +	UNSAFE +
NETWORK_POLICY	UNSAFE	UNSAFE	UNSAFE
PROJECTION_POLICY	UNSAFE +	UNSAFE +	UNSAFE +
ROW_ACCESS_POLICY	UNSAFE +	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 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.