BigQuery error messages are cryptic

Dev tooling3 posts from 3 people3d active+00 posts in the last 7 days, 1 the 7 days before (fading)

Posts per day3 posts, Sep 16 to Oct 21

The posts behind it

3, newest first

GitHub issuesOct 8 [v2 Bug] --empty wraps ref() inside a foreign_key constraint's to: field, producing invalid BigQuery DDL### Is this a new bug in dbt v2.x compared to the latest version of dbt 1.x? - [x] I believe this is a new bug in dbt v2.x - [x] I have searched the existing issues and could not find a duplicate ### Current Behavior Running dbt build --empty on a model with a foreign_key...dbt-labs/dbt · baqmendezOpen ↗GitHub issuesOct 7 Unit test dict-fixture comparison only honors columns present on the expect block's first row...test correctly fails, which confirms first-row-only inference as the cause. This is the workaround. ### Environment - dbt: 2.0.6 - Adapters: BigQuery (original report), DuckDB (minimal repro)dbt-labs/dbt · dataders1 repliesOpen ↗GitHub issuesSep 16 [platform] Truncate refresh retry overwrites a complete final table using raw rows the failed attempt already marked loaded## What A truncate refresh whose first attempt fails *after* it has typed its records and swapped the final table gets retried. The retry rebuilds the final table from the raw table, but T+D reads only `WHERE _airbyte_loaded_at IS NULL`. The failed attempt already stamped those...airbytehq/airbyte · jtruty3 repliesOpen ↗

Companies and products named

Named3 posts

BigQuery Named2 posts

dbt Named1 post

Airbyte Named1 post

DuckDB

About this problem

Evidence

3 posts from 3 people in 2 places, about 1 a week over 23 days. Mostly on dbt-labs/dbt, airbytehq/airbyte. Tools named alongside: dbt, Airbyte, DuckDB.

Frustration Frustration 2 of 3· Seen on GitHub issues

How it was grouped

Posts that state a pain and match the "errors-unclear" rule about BigQuery. First post Sep 16, 2026, latest Oct 8, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

The same problem elsewhere