Problemsby Glyphdbt users keep filing bugs
34 posts from 20 people18d activeFading, +0 this week
Posts per day
The posts behind it
[Exasol] ADBC driver does not report rows affected
Part of #16932. ### Problem Exasol reports no rows written to dbt v2: `execute()` in `exasol-labs/exarrow-rs` (`src/adbc_ffi.rs`) drops the server's `rowCount`. ### Fix needed - [ ] **`exasol-labs/exarrow-rs`:** report the server's `rowCount` as the rows-affected value of...
[Athena] ADBC driver does not report rows written
Part of #16932. ### Problem Athena reports no rows written to dbt v2: both execute paths in `dbt-labs/athena` return -1 (`go/statement.go`). ### Fix needed - [ ] **`dbt-labs/athena`:** read `GetQueryResultsOutput.UpdateCount` (rows written by a CTAS / INSERT) and report it as...
[v2 Bug] --skip-semantic-manifest-validation downloads a deferral manifest from the dbt platform; --no-manage-state does not stop it
### 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 (related: #14452, closed). ### Current Behavior With dbt 2.0.9, when...
[dagster-dbt] Selections over 200 resources copy the whole project directory into a temp dir that is never removed
### What's the issue? When an `@dbt_assets` definition has a `project` and a run selects more than `_SELECTION_ARGS_THRESHOLD` (200) resources, `dagster_dbt/asset_utils.py` copies the **entire project directory** with `shutil.copytree(project_dir, tempfile.mkdtemp())` to write...
Using AWS CDK instead of dbt to manage and deploy BI objects?
...fails, a DROP in the file would run on every deploy, and dropping without CASCADE is blocked by dependents. Recreating also means repopulating, which is slow for the wide MVs. So MV code is committed and reviewed in PRs, but only in the reference folder, and a data engineer then...
[dagster-dbt] 0.29.26 fails to import without dbt-core: missing python-dateutil dependency
### What's the issue? A clean install of `dagster-dbt==0.29.26` succeeds, but importing `DbtCliResource` fails with `ModuleNotFoundError: No module named 'dateutil'`. `dbt-core` is not installed. This is the supported base install now that `dbt-core` is an optional extra. The...
[v2 Bug] dbt lsp dbt.compileFile reports success for a failed compile and returns the previous output
...and could not find a duplicate ### Current Behavior When a model that compiled before fails to compile, `dbt.compileFile` still returns `error: null`, with `file_uri` pointing at the output of the last successful compile. A client can only tell the two apart by comparing file...
[v2 Bug] dbt lsp formats the file on disk instead of the open document
### 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 `textDocument/formatting` computes its edits from the file on...
Float64 to Decimal cast rounds the wrong way when x * 10^scale lands on a tie
### Checks - [x] I have checked that this issue has not already been reported. - [x] I have confirmed this bug exists on the latest version of Polars. ### Reproducible example Output (polars 2.0.0 from PyPI, also Polars main 4207839322): `pl.sql("SELECT CAST(x AS DECIMAL(18, 4))...
[v2 Bug] `dbt lsp` stays silent when it cannot load the project
### 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 In both cases below, `dbt lsp` answers `initialize` and logs...
[Feature] `dbt lsp`: serve several dbt projects from one language server
### Is this your first time submitting a feature request? - [x] I have read the expectations for open source contributors - [x] I have searched the existing issues, and I could not find an existing issue for this feature - [x] I am requesting a straightforward extension of...
[v2 Bug] Jinja `sum`, `min` and `max` reject the `attribute=` argument
...1, 2] | min` render the same on both versions, so `map(attribute=...)` before `sum` is a workaround; for `min` and `max` it returns the attribute value instead of the item. ### Relevant log output ### Environment ### Which database adapter are you using? duckdb ### Is this a...
dbt.data_tests.node_unique_id is null for generic source tests
## Describe the bug Generic data tests declared on a source receive valid test `unique_id` values and the graph contains edges from the tested source to those tests, but the corresponding rows in the v2 `dbt.data_tests` information-schema table have `node_unique_id = null`. This...
[v2 Bug] dbt1501 `bad string escape` in `dbt source freshness` when non-ASCII characters are present in loaded_at_field/loaded_at_query
### 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 When a source's `loaded_at_field` or `loaded_at_query`...
[Catalogsv2] Spark support for Iceberg Hadoop catalogs
## Goal Support Iceberg Hadoop catalogs from the dbt v2 Spark adapter. ## Required coverage - Represent a preconfigured `org.apache.iceberg.spark.SparkCatalog` with `type=hadoop`. - Route models/sources to its Spark catalog name and namespace. - Document warehouse URI and...
[Catalogsv2] Spark catalog routing foundation
## Problem dbt v2 has no shared, mergeable Spark foundation for selecting a preconfigured catalog from `catalogs.yml`. The prior all-in-one proof of concept, dbt-labs/fs#10485, mixed schema support, routing, metadata SQL, and five catalog types. ## Work - Add `spark` as a...
[Catalogsv2] Spark support for Hive-backed Iceberg catalogs
## Goal Support Hive-backed Iceberg catalogs and Iceberg's `SparkSessionCatalog` integration in the dbt v2 Spark adapter. ## Required coverage - Distinguish native Hive tables from Iceberg tables backed by a Hive metastore. - Support a preconfigured `SparkCatalog` with...
[dagster-dbt] Setting both meta.dagster.asset_key and either "key" or "key_prefix" in translation breaks dependencies
### What's the issue? Setting custom asset keys for dbt sources is required to configure upstream dependencies - [see docs](https://dagster.io/docs/integrations/libraries/dbt#step-7-connect-upstream-assets-to-dbt-sources). When a custom `key` or `key_prefix` is configured in the...
SQL: accept options in read_csv() (has_header, schema, truncate_ragged_lines, include_file_paths, ...)
### Description The SQL table function `read_csv` accepts a path and nothing else (polars 2.0.0): so a file that does not fit the defaults cannot be read from SQL at all. A headerless CSV whose rows have different widths is the common case: with the defaults the width comes from...
SQL: WITH inside a derived table is not resolved ("relation 'x' was not found"), though it works inside a CTE
### Checks - [x] I have checked that this issue has not already been reported. - [x] I have confirmed this bug exists on the [latest version](https://pypi.org/project/polars/) of Polars. ### Reproducible example ### Log output ### Issue description A `WITH` clause inside a...
How can I get up to speed with dbt quickly before joining a new project?
I have an upcoming project that uses Airflow, dbt, and Snowflake. I’m comfortable with Airflow and Snowflake, but I have no experience with dbt.. I’m looking for advice from people who have worked with this stack. Can you recommend any good courses or learning resources to get...
[v2 Bug] Bot Changelog fails to start on fork pull requests
### 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 Bot Changelog fails before starting any jobs on fork pull...
[dagster-snowflake] SnowflakeDbtProjectComponent drops materializations for non-error dbt node statuses
### What's the issue? `SnowflakeDbtProjectComponent` drops materializations for dbt nodes that finished on a terminal, non-error status. It compares the node status against `success` alone:...
[v2 Bug] dbt compile does not print compiled SQL when the selection includes the model's tests
...test` | 2 models | No | Output for the first command: Output for the third command: Workaround: add `--exclude-resource-type test`. ### Suggested fix If the selection resolves to exactly one model (or other non-test node) plus any number of tests, print the compiled SQL of that...
[1.x Bug] 'dbt debug` ignores `vars.yml` when rendering `dbt_project.yml`
### Is this a new bug in dbt-core? - [x] I believe this is a new bug in dbt-core - [x] I have searched the existing issues, and I could not find an existing issue for this bug ### Current Behavior When project vars are defined in `vars.yml` and referenced in `dbt_project.yml`,...
[v2 Bug] A null target_lag set below a project-level default is ignored at every level, making scheduler: DISABLE unusable
### 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 On Fusion 2.0.6, a null `target_lag` set below a project-level...
[v2 Bug] dbt clean can delete directories outside of the dbt project
### 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 dbt clean can delete files outside of the project directory....
[v2 Bug] dbt deps randomly fails with 500 Internal Server Error from codeload.github.com
...while downloading packages from codeload.github.com, locally and in GitHub Actions. The failing package changes between runs. ### Expected Behavior The packages are installed properly. ### Steps To Reproduce 1. `pip install dbt==2.0.6` in a fresh venv. 2. Use a project whose...
[v2 Bug] `dbt build --write-catalog` writes no catalog.json (run, compile and parse do)
### 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 `dbt build --write-catalog` completes successfully but writes...
[v2 Bug] A Jinja-rendered `*/` in `query-comment` breaks out of the comment and executes as SQL (guard only checks the pre-render template)
### 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 `query-comment` is validated for the literal substrings `/*`...
[dagster-dbt] select_unique_ids raises TypeError for YAML selectors with indirect_selection: cautious/buildable
### What's the issue? Not a duplicate of #33351 (run-time skip under non-eager indirect selection, fixed in 1.13.6). This is a **definition-time crash**: resolving a `selectors.yml` selector whose criteria set `indirect_selection: cautious` or `buildable` raises in...
Unable to Complete the dbt Deferral Micrcourse
DBT Development Standards
...properly from the off, rather than having to redesign, revise and refactor later.. Any tips very welcome 🙏 .
state: modified not working in dbt set up using python libraries
Companies and products named
About this problem
Evidence
34 posts from 20 people in 6 places, about 4 a week over 55 days. Mostly on dbt-labs/dbt, dagster-io/dagster, pola-rs/polars. Tools named alongside: DuckDB, Snowflake, Dagster, GitHub.
Frustration Frustration 0 of 3· Seen on GitHub issues, Reddit, Community forums
Summary, model-written
dbt users face package download failures from GitHub, SQL function limitations in Polars, and modified state settings failing in Python setups.
How it was grouped
Posts about dbt that state a pain but match no known issue yet. First post Sep 4, 2026, latest Oct 28, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other dbt problems
Hard to trace lineage and find trusted data in dbt
6 posts from 6 people on GitHub issues, Reddit.
dbt outages and slowdowns disrupt work
4 posts from 4 people on Glyph Ibis.
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.
dbt error messages are cryptic
4 posts from 4 people on GitHub issues.
Trouble with dbt semantic
Top post: "`NodeNotFoundOrDisabled` when a package's model and its semantic_model are both disabled at project level", one of 3 posts from 3 people on GitHub issues.
Trouble with dbt false
Top post: "SQL linting (dbt sqlfluff lint) does not respect enabled: false (dynamic +enabled)", one of 3 posts from 3 people on GitHub issues.
Trouble with dbt fail
Top post: "`TIMESTAMPTZ_NS` cannot be compared with `TIMESTAMPTZ` or take an `INTERVAL`, so 1.5 queries on nanosecond", one of 3 posts from 3 people on GitHub issues.
Trouble with dbt lint
Top post: "`dbt lint --fix` should expand `*` in `select *` into explicit columns", one of 2 posts from 2 people on GitHub issues. Unverified.
Migrating to or off dbt is slow and risky
2 posts from 2 people on GitHub issues, Reddit. Unverified.
dbt costs outgrow the value it gives
2 posts from 1 person on GitHub issues. Unverified.
History