Testing dbt pipelines and SQL is hard
2 posts from 2 people2d activeSteady, +1 this weekunverified
Posts per day
The posts behind it
[v2 Bug] `dbt build --empty` empties unit test `given` rows, so unit tests that expect rows always fail (1.x ignores `--empty` for unit tests since #10764)
### Is this a new bug in dbt v2.x compared to the latest version of dbt v1.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 With `--empty`, dbt v2.x also applies the empty-relation...
[v2 Bug] Unit-test macro override of current_timestamp is not applied to dbt.current_timestamp()
**Versions:** dbt 2.0.11 (BigQuery). dbt-core 1.11.2 behaves correctly (fixed there in #9624). **Repro** Compiled unit-test SQL: - 2.0.11: `current_timestamp() as now_ns`, `timestamp('2023-12-24 12:00:00') as now_bare` - 1.11.2: both columns get `timestamp('2023-12-24...
Companies and products named
About this problem
Evidence
2 posts from 2 people in 1 place, about 1 a week over 13 days. Mostly on dbt-labs/dbt. Tools named alongside: BigQuery, Snowflake.
Frustration Frustration 0 of 3· Seen on GitHub issues
How it was grouped
Posts that state a pain and match the "data-testing" rule about dbt. First post Nov 5, 2026, latest Nov 17, 2026. Unverified: fewer than 3 posts, or one person or place only. Method
The same problem elsewhere
Testing data pipelines and SQL is hard
3 posts from 3 people on Reddit, GitHub issues.
Testing DuckDB pipelines and SQL is hard
2 posts from 2 people on GitHub issues. Unverified.
Other dbt problems
dbt upgrades break working setups
8 posts from 7 people on GitHub issues.
dbt error messages are cryptic
6 posts from 5 people on GitHub issues.
dbt outages and slowdowns disrupt work
7 posts from 7 people on Glyph Ibis.
Hard to trace lineage and find trusted data in dbt
7 posts from 7 people on GitHub issues, Reddit.
Trouble with dbt false
Top post: "dbt lint in symbolic mode renders an if branch whose condition involves an introspective value, even when", one of 4 posts from 3 people on GitHub issues.
Modeling data in dbt is unclear and hard to change
4 posts from 4 people on Reddit.
Trouble with dbt fusion
Top post: "With dbt Fusion and no dbt-core, every definitions load runs `dbt list` and leaves a target directory behind", one of 4 posts from 4 people on GitHub issues.
Trouble with dbt columns
Top post: "`TIMESTAMPTZ_NS` cannot be compared with `TIMESTAMPTZ` or take an `INTERVAL`, so 1.5 queries on nanosecond", one of 4 posts from 4 people on GitHub issues.
Trouble with dbt state
Top post: "state: modified not working in dbt set up using python libraries", one of 3 posts from 3 people on GitHub issues, Community forums.
Trouble with dbt breaks
Top post: "v2-parser breaks generic tests", one of 3 posts from 3 people on GitHub issues.
Migrating to or off dbt is slow and risky
3 posts from 3 people on GitHub issues, Reddit.
dbt deprecations force unplanned migrations
2 posts from 2 people on GitHub issues. Unverified.
History