Friday, 17 February 2023

SQL - FIND DUPLICATE RECORDS

SELECT offset, COUNT(offset)  

FROM log 

GROUP BY offset  

HAVING COUNT(offset) > 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 ...