Archive
Archive
2025
- January 21 - Why I wish I had a control plane for my renovation
- January 23 - The Three Levels of SQL Comprehension: What they are and why you need to know about them
- January 24 - The key technologies behind SQL Comprehension
- February 19 - Parser, Better, Faster, Stronger: A peek at the new dbt engine
- March 10 - Getting Started with git Branching Strategies and dbt
- April 17 - Establishing dbt Cloud: Securing your account through SSO & RBAC
- April 21 - Introducing the dbt MCP Server – Bringing Structured Data to AI Workflows and Agents
2024
- January 9 - More time coding, less time waiting: Mastering defer in dbt
- January 15 - Deprecation of dbt Server
- January 15 - Serverless, free-tier data stack with dlt + dbt core.
- February 13 - Column-Level Lineage, Model Performance, and Recommendations: ship trusted data products with dbt Explorer
- March 19 - LLM-powered Analytics Engineering: How we're using AI inside of our dbt project, today, with no new tools.
- April 22 - Maximum override: Configuring unique connections in dbt Cloud
- May 2 - How we're making sure you can confidently switch to the "Latest" release track in dbt Cloud
- May 2 - Conversational Analytics: A Natural Language Interface to your Snowflake Data
- May 7 - Unit testing in dbt for test-driven development
- May 17 - Up and Running with Azure Synapse on dbt Cloud
- June 14 - Putting Your DAG on the internet
- July 10 - How to build a Semantic Layer in pieces: step-by-step for busy analytics engineers
- September 30 - How Hybrid Mesh unlocks dbt collaboration at scale
- October 4 - Iceberg Is An Implementation Detail
- October 8 - Snowflake feature store and dbt: A bridge between data pipelines and ML
- November 11 - Test smarter not harder: add the right tests to your dbt project
- December 9 - Test smarter not harder: Where should tests go in your pipeline?
2023
- January 17 - Power up your data quality with grouped checks
- January 24 - How we cut our tests by 80% while increasing data quality: the power of aggregating test failures in dbt
- February 16 - Tips and advice to study for, and pass, the dbt Certification exam
- March 10 - BigQuery ingestion-time partitioning and partition copy with dbt
- March 24 - Audit_helper in dbt: Bringing data auditing to a higher level
- March 29 - The missing guide to debug() in dbt
- April 17 - dbt Squared: Leveraging dbt Core and dbt Cloud together at scale
- April 20 - Building a Kimball dimensional model with dbt
- April 25 - How we reduced a 6-hour runtime in Alteryx to 9 minutes with dbt and Snowflake
- April 26 - Why we're deprecating the dbt_metrics package
- May 1 - Data engineers + dbt v1.5: Evolving the craft for scale
- May 2 - Modeling ragged time-varying hierarchies
- May 17 - Accelerate your documentation workflow: Generate docs for whole folders at once
- June 13 - Building a historical user segmentation model with dbt
- July 3 - Data Vault 2.0 with dbt Cloud
- July 18 - Create dbt Documentation and Tests 10x faster with ChatGPT
- August 3 - Optimizing Materialized Views with dbt
- October 31 - To defer or to clone, that is the question
- November 14 - Why you should specify a production environment in dbt Cloud
- December 12 - How we built consistent product launch metrics with the dbt Semantic Layer
- December 20 - How to integrate with dbt
2022
- February 3 - How We Calculate Time on Task, the Business Hours Between Two Dates
- February 8 - The JaffleGaggle Story: Data Modeling for a Customer 360 View
- March 2 - Founding an Analytics Engineering Team
- March 10 - dbt + Machine Learning: What makes a great baton pass?
- April 5 - From the Slack Archives: When Backend Devs Spark Joy for Data Folks
- May 3 - Making dbt Cloud API calls using dbt-cloud-cli
- May 6 - Slim CI/CD with Bitbucket Pipelines for dbt Core
- May 8 - COALESCE SQL function: Why we love it
- May 11 - LOWER SQL function: Why we love it
- May 12 - How we remove partial duplicates: Complex deduplication to refine your models' grain
- May 15 - EXTRACT SQL function: Why we love it
- May 17 - Stakeholder-friendly model names: Model naming conventions that give context
- May 19 - Optimizing dbt Models with Redshift Configurations
- May 23 - A star (generator) is born
- May 26 - Tackling the complexity of joining snapshots
- July 13 - DATEDIFF SQL function: Why we love it
- July 13 - DATE_TRUNC SQL function: Why we love it
- July 14 - Strategies for change data capture in dbt
- July 20 - Migrating from Stored Procedures to dbt
- July 26 - Updating our permissioning guidelines: grants as configs in dbt Core v1.2
- August 3 - Enforcing rules at scale with pre-commit-dbt
- August 18 - How we shaved 90 minutes off our longest running model
- August 22 - Narrative modeling: How structure can tell a story
- August 24 - Surrogate keys in dbt: Integers or hashes?
- August 25 - An introduction to unit testing your dbt Packages
- August 31 - August 2022 dbt Update: v1.3 beta, Tech Partner Program, and Coalesce!
- September 7 - Leverage Accounting Principles when Modeling Financial Data
- September 8 - KonMari your data: Planning a query migration using the Marie Kondo method
- September 13 - The case against `git cherry pick`: Recommended branching strategy for multi-environment dbt projects
- September 29 - Analysts make the best analytics engineers
- October 18 - Stronger together: Python, dataframes, and SQL
- November 4 - Demystifying event streams: Transforming events into tables with dbt
- November 22 - A journey through the Foundry: Becoming an analytics engineer at dbt Labs
- November 23 - How to move data from spreadsheets into your data warehouse
- November 30 - Introducing the dbt_project_evaluator: Automatically evaluate your dbt project for alignment with best practices
- December 15 - Making the leap from accountant to analytics engineer
2021
- February 9 - How to Configure Your dbt Repository (One or Many)?
- September 15 - September 2021 dbt Update: DAG in the IDE + Metadata API in GA
- October 15 - October 2021 dbt Update: Metrics and Hat Tricks 🎩
- November 15 - November 2021 dbt Update: v1.0, Environment Variables, and a Question About the Size of Waves 🌊
- November 15 - Towards an Error-free UNION ALL
- November 15 - DATEADD SQL Function Across Data Warehouses
- November 29 - On the Importance of Naming: Model Naming Conventions (Part 1)
- November 29 - The (Missing) Role of Design in Analytics
- November 29 - How I Study Open Source Community Growth with dbt
- November 29 - The Spiritual Alignment of dbt + Airflow
- November 29 - Welcome to the dbt Developer Blog
- November 29 - So You Want to Build a dbt Package
- November 29 - How to Upgrade dbt Versions (Mostly) Without Fear
- November 29 - Generating Surrogate Keys Across Warehouses
- November 29 - What's a Primary Key and Why Do We Test Them?
- November 29 - The Exact dbt Commands We Run in Production
- November 29 - The Exact GitHub Pull Request Template We Use at dbt Labs
- December 6 - How to Build a Mature dbt Project from Scratch