dbt
-
Mastering Time in dbt: Incremental Merging of Estimates and Actuals for large datasets
Managing incrementality (change over time) in a large database is hard. Dbt can help us alleviate some of the pain by making the selection of incremental strategies we have easier to choose from. Lets look at updating an example sales table with actuals and estimates over time.
Continue reading...
-
Dbt In a Box: Using Google Cloud Run and BigQuery to run your dbt SQL models from a Docker container
Dbt is a great tool for data transformation. Snowplow is great for collecting web analytics data. What if you could harvest the power of both for just a few cents a day by running dbt in a Docker container on Google Cloud Run Jobs?
Continue reading...