BigQuery has quietly become the default warehouse for a huge chunk of the analytics world. And the moment you cross a few hundred tables, nested STRUCTs, partitioned fact tables, and dbt models stacked ten layers deep, you need more than SQL files in a Git repo. You need real data modeling.
The problem is that "data modeling for BigQuery" means different things to different teams. Some people want visual ER diagrams and forward-engineered DDL. Others want SQL transformations, tests, and lineage. Others want a governed semantic layer so every dashboard uses the same definition of "active customer." Very few tools actually do all three.
I spent a few weeks digging into the main options for 2026: SqlDBM, dbt, Google Cloud Dataform, Looker, and erwin.…