[Analytics Engineering] DBT Contracts and model versioning
Ali, Saqib docbook.xml at gmail.com
Mon Apr 15 01:31:50 UTC 2024
One thing to note is that DBT Contracts can not enforce the unique key, primary key and foreign key Constraint on Snowflake, Redshift, Databricks, Spark or BigQuery.
On Sat, Mar 23, 2024 at 7:02 AM Ali, Saqib <docbook.xml at gmail.com> wrote:
Recently I started implementing DBT Contracts on models where the> integrity of the data is crucial. One thing to note is that before you> start enforcing DBT Contracts, ensure that you are ready for Model> Versioning in your environment. Any breaking changes e.g. removing a column> or removing the not_null constraint on a column or changing the data type> on a column will require a new version of the model to be created. The good> thing is that DBT supports Model Versioning, and specification can be> defined in the YML file.>
- Previous message (by thread): [Wranglers] DBT Contracts and model versioning
- Next message (by thread): [Wranglers] Calculating Geometric Mean using SQL