Snowflake

• Beyond Tables and Views: Building a Custom dbt Materialization to Deploy Streamlit Apps on Snowflake · Aug 27, 2025

  What if dbt could deploy a dashboard instead of just another table? I was tired of switching between my dbt transformations and Streamlit visualization code, so I built a custom materialization that deploys Streamlit apps directly on Snowflake. This tutorial walks through the architecture: using dbt configs, uploading files to stages, and creating apps that know about your data models, lineage, and freshness.

  dbt snowflake streamlit data-engineering custom-materializations data-observability python

• 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