Monday, 5 September 2022

Postgresql - Delete N number of rows

DELETE FROM mytablename

WHERE id IN (SELECT id FROM mytablename ORDER BY 1 LIMIT 30000)

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