Skip to main content
Jason Ganz

Jason Ganz

Developer Experience @ dbt Labs

Author Posts

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.

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?