DATEADD SQL Function Across Data Warehouses
DATEADD Function syntax varies across data warehouses. Learn how to standardize your syntax no matter the container.
Towards an Error-free UNION ALL
Union'ing two or more tables with a long list of columns can be an error-prone chore, which dbt + dbt_utils abstracts away.
What's a Primary Key and Why Do We Test Them?
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
Generating Surrogate Keys Across Warehouses
What's a surrogate key, and how can you generate them across BigQuery, Databricks, Redshift, Snowflake and other data warehouses?
Welcome to the dbt Developer Blog
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.