Analytics-Engineering

• Optimizing Snowflake Costs with dbt Query Tags · Jul 19, 2025

  Snowflake costs can spiral out of control fast—especially when dbt runs alongside other queries and you can't tell which models are burning through credits. This guide shows you how to set up query tags that track every dbt model, then build dashboards to see usage over time, identify expensive models, and find your biggest cost drivers. Three ingredients: a custom macro, usage tables as sources, and some math.

  analytics-engineering cost dbt snowflake

• Test Driven Development (TDD) with dbt: Test First, SQL Later · Jun 27, 2025

  You know that feeling when your dbt model runs but the numbers look... off? Not broken, just weird enough to make you question your SQL. Most data quality surprises start with 'let me just quickly fix this.' What if you wrote the tests before the model instead? This guide applies Test-Driven Development to analytics engineering: unit tests, model contracts, and defining what 'good' looks like before you write a single SELECT.

  analytics-engineering testing dbt tdd