Monday, 5 September 2022

Postgresql - Identify duplicate rows

SELECT (mytablename.*)::text, count(*)

FROM mytablename

GROUP BY mytablename.*

HAVING count(*) > 1

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