🪤SnowDDL vs. Declarative DCM

In June 2024 Snowflake released native "Declarative DCM" feature. You may read more about it here:

• Blog post with feature description and examples: https://melbdataguy.medium.com/ci-cd-and-devops-for-snowflake-a-comprehensive-guide-9df87a24797d

• CREATE OR ALTER TABLE usage notes: https://docs.snowflake.com/en/sql-reference/sql/create-table#create-or-alter-table-usage-notes

• CREATE OR ALTER TASK usage notes: https://docs.snowflake.com/en/sql-reference/sql/create-task#create-or-alter-task-usage-notes

This is how SnowDDL declarative approach compares with native "Declarative DCM".

Feature	SnowDDL	Declarative DCM
Object type support	Most object types are supported.	Only TABLE and TASK are supported.
Preview of specific changes before applying	Yes	No
Capable of CREATE OR REPLACE TABLE	Yes	No
Supports creation of TASKS in specific order	Yes	No

As of June 2024, "Declarative DCM" feature seems to be incomplete. We do not recommend using it in its current form. SnowDDL does not rely on it internally.