ðŠĪ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 |
Preview of specific changes before applying | Yes | No |
Capable of CREATE OR REPLACE TABLE | Yes | No |
Supports creation of | 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.
Last updated