Tracking user activity with dbt

Generating historical activity table (time-partioned) in Bigquery with dbt incremental models

In this post, I will show how to create a historical table and track user activity using incremental models and dbt in BigQuery. If dbt does not ring a bell, then check this article. You can also get started with incremental models following this.

Ok, back to our example! Let me make it simple: we have the last activity timestamp of each user and now we …

bigquery data-build-tool data engineering data warehouse dbt tracking