Monday, 5 September 2022

Postgresql - Add/Remove primary key

 ALTER TABLE MY_TABLE_NAME ADD PRIMARY KEY (COLUMN_1, COLUMN_2);

ALTER TABLE MY_TABLE_NAME DROP CONSTRAINT TEST1_PKEY;

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 ...