Data-Quality

• Unit Testing dbt Macros: A workaround for dbt's unit testing limitations · Mar 10, 2025

  Remember when dbt projects meant folders full of SQL files and crossing your fingers that your transformations were correct? dbt 1.8 finally brought unit testing, but macro testing is still limited. This post walks through unit testing your business logic—like standardizing campaign sources—and a workaround for testing macros so you can catch broken SQL before it wrecks your dashboards.

  dbt data-engineering data-quality sql testing

• Data Observability is not a tool: understanding data quality at the source, in transformations and in governance · Apr 8, 2024

  Data observability tools promise to fix your data quality, but buying a tool won't solve problems you don't understand. This post breaks down where data quality actually breaks: in source systems (completeness, consistency, reliability), during transformations (integrity, accuracy), and in governance (documentation, ownership). Understand the root causes before you reach for a solution.

  observability data-quality data-governance lineage ETL analytics