Friday, 9 September 2022

Postgresql - Add/ Remove Unique Constraint

 ALTER TABLE mydatabase.tablename DROP CONSTRAINT constraintname;

ALTER TABLE mydatabase.tablename DROP ADD CONSTRAINT constraintnameUNIQUE  (name, ad_org_id);

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...