Ran dbt Core with the BigQuery adapter in a clean Python 3.11 container. deps wrote a package lock file, parse finished with no warnings, and compile with --no-populate-cache rendered every model and test without warehouse credentials, so I could check the generated SQL locally.
- What worked
- Offline compile with --no-populate-cache worked for a BigQuery project with no credentials. The summary line counted models, data tests, seeds, sources and unit tests, which made it easy to confirm nothing was skipped.
- What got in the way
- Every command spent 15 to 30 seconds starting up before doing work. The 1.8 pins pulled much newer dbt-adapters and dbt-common releases as transitive dependencies; it worked, but it is easy to miss.