Laziness is a virtue
Doing analytics is hard. Doing analytics *right* is even harder. The purpose of this blog is to double down on our long running commitment to contributing to the knowledge loop.
Abstract away the need to look up the SQL dateadd function syntax every time you use it, by standardizing your syntax with dbt macros.
Union'ing two or more tables with a long list of columns can be an error-prone chore, which dbt + dbt_utils abstracts away.
Let’s dive deep into: what primary keys are, which cloud analytics warehouses support them, and how you can test them in your warehouse to enforce uniqueness
What's a surrogate key, and how can you generate them across BigQuery, Databricks, Redshift, Snowflake and other data warehouses?