Hi,
I'm working with BigQuery and managing around 50 tables, along with multiple routines, scheduled jobs, and views. I'm looking for recommendations on schema modeling and SQL schema migration tools that you use.
I've explored DBT, but its behavior seems unclear to me. Specifically, it looks like adding a column triggers a full table recreation rather than an in-place migration. Is there a way to handle this better in DBT, or are there other tools you’d recommend for more controlled schema migrations?
LinkedIn
Twitter
