ðĶObject types
Object types are sorted in execution order. See explanation after the table.
Object type | CREATE | COMPARE | DROP | Notes |
---|---|---|---|---|
| N/A | UNSAFE + | N/A | ACCOUNTADMIN, skip on empty config |
| UNSAFE | UNSAFE | UNSAFE | ACCOUNTADMIN |
| SAFE | SAFE | SAFE | ACCOUNTADMIN to assign RESOURCE_MONITOR |
| SAFE | SAFE | SAFE | |
| SAFE | UNSAFE | UNSAFE | |
| SAFE | UNSAFE | UNSAFE | |
| SAFE | SAFE | SAFE | |
| SAFE | SAFE | SAFE | |
| SAFE | SAFE and UNSAFE | UNSAFE | ALTER is safe, REPLACE is unsafe |
| SAFE | SAFE | SAFE | |
| SAFE | SAFE | SAFE | Short hash |
| SAFE | SAFE and UNSAFE | UNSAFE | |
| SAFE | SAFE | UNSAFE | |
| SAFE | SAFE | SAFE | Short hash |
| SAFE | SAFE | SAFE | Short hash |
| SAFE | SAFE | SAFE | Short hash |
| SAFE | SAFE and UNSAFE + | UNSAFE | |
| SAFE | SAFE and UNSAFE | UNSAFE | |
| SAFE | UNSAFE | UNSAFE | Short hash |
| SAFE | SAFE and UNSAFE | UNSAFE | |
| SAFE | SAFE | SAFE | Short hash |
| SAFE | SAFE | SAFE | |
| SAFE | SAFE | SAFE | |
| SAFE | SAFE | SAFE | |
| SAFE | UNSAFE | UNSAFE | |
| SAFE | UNSAFE | UNSAFE | |
| SAFE | SAFE | SAFE | |
| SAFE | UNSAFE | UNSAFE | Short hash |
| SAFE | SAFE | SAFE | Short hash |
| SAFE | SAFE | SAFE | |
| UNSAFE + | UNSAFE + | UNSAFE + | |
| SAFE | SAFE | SAFE | |
| SAFE | SAFE | SAFE | |
| SAFE | SAFE | SAFE | |
| SAFE | UNSAFE | UNSAFE | |
| UNSAFE + | UNSAFE + | UNSAFE + | |
| UNSAFE + | UNSAFE + | UNSAFE + | |
| UNSAFE + | UNSAFE + | UNSAFE + | |
| UNSAFE | UNSAFE | UNSAFE | |
| UNSAFE + | UNSAFE + | UNSAFE + | |
| 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 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 updated