# Object types Object types are sorted in execution order. See explanation after the table.
Object typeCREATECOMPAREDROPNotes
ACCOUNT_PARAMETERN/AUNSAFE +N/AACCOUNTADMIN, skip on empty config
RESOURCE_MONITORUNSAFEUNSAFEUNSAFEACCOUNTADMIN
WAREHOUSESAFESAFESAFEACCOUNTADMIN to assign RESOURCE_MONITOR
WAREHOUSE_ROLESAFESAFESAFE
DATABASESAFEUNSAFEUNSAFE
SCHEMASAFEUNSAFEUNSAFE
SCHEMA_ROLESAFESAFESAFE
SECRETSAFESAFESAFE
NETWORK_RULESAFESAFE and UNSAFEUNSAFEALTER is safe, REPLACE is unsafe
EXTERNAL_ACCESS_INTEGRATIONSAFESAFESAFE
FILE_FORMATSAFESAFESAFEShort hash
STAGESAFESAFE and UNSAFEUNSAFE
SEQUENCESAFESAFEUNSAFE
FUNCTIONSAFESAFESAFEShort hash
EXTERNAL_FUNCTIONSAFESAFESAFEShort hash
PROCEDURESAFESAFESAFEShort hash
TABLESAFESAFE and UNSAFE +UNSAFE
EVENT_TABLESAFESAFE and UNSAFEUNSAFE
HYBRID_TABLESAFEUNSAFEUNSAFEShort hash
DYNAMIC_TABLESAFESAFE and UNSAFEUNSAFE
EXTERNAL_TABLESAFESAFESAFEShort hash
PRIMARY_KEYSAFESAFESAFE
UNIQUE_KEYSAFESAFESAFE
FOREIGN_KEYSAFESAFESAFE
MATERIALIZED_VIEWSAFEUNSAFEUNSAFE
VIEWSAFESAFESAFE
SEMANTIC_VIEWSAFESAFESAFEShort hash
PIPESAFEUNSAFEUNSAFEShort hash
STREAMSAFEUNSAFEUNSAFE
TASKSAFESAFESAFEShort hash
ALERTSAFESAFESAFE
SHARE (outbound)UNSAFE +UNSAFE +UNSAFE +
TECHNICAL_ROLESAFESAFESAFE
BUSINESS_ROLESAFESAFESAFE
USER_ROLESAFESAFESAFE
USERSAFEUNSAFEUNSAFE
AGGREGATION_POLICYUNSAFE +UNSAFE +UNSAFE +
AUTHENTICATION_POLICYUNSAFE +UNSAFE +UNSAFE +Short hash
JOIN_POLICYUNSAFE +UNSAFE +UNSAFE +
MASKING_POLICYUNSAFE +UNSAFE +UNSAFE +
NETWORK_POLICYUNSAFEUNSAFEUNSAFE
PROJECTION_POLICYUNSAFE +UNSAFE +UNSAFE +
ROW_ACCESS_POLICYUNSAFE +UNSAFE +UNSAFE +
BACKUP_POLICYUNSAFEUNSAFEUNSAFE
BACKUP_SETUNSAFEUNSAFEUNSAFE
### Notes * Safe & unsafe operations are explained in ["Safe & unsafe DDL" guide](/guides/other-guides/safe-unsafe.md). * Some role types are generated dynamically. You may read more in [Role hierarchy guide](/guides/role-hierarchy.md). * `+` means that additional setting or [CLI argument](/basic/cli.md) 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](/guides/other-guides/short-hash.md). * 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. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.snowddl.com/guides/object-types.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.