# \#dbt-core

**URL:** https://discourse.getdbt.com/tag/dbt-core/96.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [SQL Server in DBT Core v2 / Fusion](https://discourse.getdbt.com/t/sql-server-in-dbt-core-v2-fusion/20860)

<div class="topic-metadata">

**Author:** [@pbronez](https://discourse.getdbt.com/u/pbronez)\
**Replies:** 1\
**Last updated:** [October 23, 2026, 3:09am UTC](https://discourse.getdbt.com/t/sql-server-in-dbt-core-v2-fusion/20860 "2026-10-23T03:09:17Z")

</div>

I’m evaluating dbt for adoption at my enterprise. We currently use SQL Server but plan to migrate off of it. I want to introduce dbt before the backend transition to help with change management. Unfortunately I cannot fi…

---

## [Installation for DuckDB failed](https://discourse.getdbt.com/t/installation-for-duckdb-failed/21066)

<div class="topic-metadata">

**Author:** [@SeBaFlu](https://discourse.getdbt.com/u/SeBaFlu)\
**Replies:** 0\
**Last updated:** [October 22, 2026, 5:49pm UTC](https://discourse.getdbt.com/t/installation-for-duckdb-failed/21066 "2026-10-22T17:49:54Z")

</div>

The problem I have: installing of dbt-duckdb failed: (.venv) PS C:\\Workdir\\Repositories\\TestRepo\> python -m pip install dbt-duckdb error message see below The context of why I’m trying to do this: to make dbt run for …

---

## [BigQuery rate limits](https://discourse.getdbt.com/t/bigquery-rate-limits/20483)

<div class="topic-metadata">

**Author:** [@mattia.zaffalon1](https://discourse.getdbt.com/u/mattia.zaffalon1)\
**Replies:** 1\
**Last updated:** [October 21, 2026, 8:11am UTC](https://discourse.getdbt.com/t/bigquery-rate-limits/20483 "2026-10-21T08:11:10Z")

</div>

dbt pipelines are failing because of rate limits For a specific GCP project, I’m getting the error 429 Exceeded rate limits: too many table update operations for this table for some models. It seems like the dbt seed an…

---

## [Package crate/dbt-xdbc missing in toml of neewest version of dtb-core](https://discourse.getdbt.com/t/package-crate-dbt-xdbc-missing-in-toml-of-neewest-version-of-dtb-core/20995)

<div class="topic-metadata">

**Author:** [@Jullllius](https://discourse.getdbt.com/u/Jullllius)\
**Replies:** 1\
**Last updated:** [September 10, 2026, 6:50am UTC](https://discourse.getdbt.com/t/package-crate-dbt-xdbc-missing-in-toml-of-neewest-version-of-dtb-core/20995 "2026-09-10T06:50:54Z")

</div>

The problem I’m having: The Guide tells me to edit “crates/dbt-xdbc” at 5.2 but it is missing in the toml and therefore not in the Project. In the git history you can see that it was there in earlier commits. Is the gui…

---

## [Authenticating dbt Core to Amazon Redshift using Keycloak](https://discourse.getdbt.com/t/authenticating-dbt-core-to-amazon-redshift-using-keycloak/20976)

<div class="topic-metadata">

**Author:** [@Luca87](https://discourse.getdbt.com/u/Luca87)\
**Replies:** 0\
**Last updated:** [September 4, 2026, 3:05pm UTC](https://discourse.getdbt.com/t/authenticating-dbt-core-to-amazon-redshift-using-keycloak/20976 "2026-09-04T15:05:33Z")

</div>

Hi everyone, We want to use Keycloak as the only identity source for users running dbt Core against Amazon Redshift. Each user should: Authenticate through Keycloak. Connect to Redshift from dbt using temporary crede…

---

## [Session Expired](https://discourse.getdbt.com/t/session-expired/20958)

<div class="topic-metadata">

**Author:** [@HashiruNewland](https://discourse.getdbt.com/u/HashiruNewland)\
**Replies:** 0\
**Last updated:** [September 2, 2026, 10:47pm UTC](https://discourse.getdbt.com/t/session-expired/20958 "2026-09-02T22:47:51Z")

</div>

Session expired and VS Code is not allowing me to sign in with a new dbt account details when setting dbt VS Code. I am trying to create local development for learning and the project I am doing on dbt Learn “dbt Fundame…

---

## [Blocked: dbt Fundamentals (VS Code) — Inconsistent Snowflake profiles.yml between video and repo (stuck)](https://discourse.getdbt.com/t/blocked-dbt-fundamentals-vs-code-inconsistent-snowflake-profiles-yml-between-video-and-repo-stuck/20945)

<div class="topic-metadata">

**Author:** [@shiva15surya](https://discourse.getdbt.com/u/shiva15surya)\
**Replies:** 0\
**Last updated:** [August 27, 2026, 2:38pm UTC](https://discourse.getdbt.com/t/blocked-dbt-fundamentals-vs-code-inconsistent-snowflake-profiles-yml-between-video-and-repo-stuck/20945 "2026-08-27T14:38:48Z")

</div>

Hi All, I’ve recently started learning dbt and I’m following the dbt Fundamentals (VS Code) course. While going through the setup process, I noticed a continuity issue between “Install the dbt VS Code Extension + dbt F…

---

## [Open-source pre-PR validation for dbt Core + Snowflake](https://discourse.getdbt.com/t/open-source-pre-pr-validation-for-dbt-core-snowflake/20936)

<div class="topic-metadata">

**Author:** [@jacobk2112](https://discourse.getdbt.com/u/jacobk2112)\
**Replies:** 0\
**Last updated:** [August 25, 2026, 11:19pm UTC](https://discourse.getdbt.com/t/open-source-pre-pr-validation-for-dbt-core-snowflake/20936 "2026-08-25T23:19:41Z")

</div>

While testing agents on dbt projects, I wanted a better way to make sure their changes didn’t blow up the current model or something downstream. There are tools that do this in CI, but I wanted something I could run loc…

---

## [No active warehouse selected in the current session. User has write permissions on the schema and to use the warehouse](https://discourse.getdbt.com/t/no-active-warehouse-selected-in-the-current-session-user-has-write-permissions-on-the-schema-and-to-use-the-warehouse/11468)

<div class="topic-metadata">

**Author:** [@asghari.pz](https://discourse.getdbt.com/u/asghari.pz)\
**Replies:** 1\
**Last updated:** [August 25, 2026, 8:01am UTC](https://discourse.getdbt.com/t/no-active-warehouse-selected-in-the-current-session-user-has-write-permissions-on-the-schema-and-to-use-the-warehouse/11468 "2026-08-25T08:01:56Z")

</div>

I am running a workflow on Github actions with which runs the dbt build command on snowflake. The user in my profile.yaml file is the owner of the schema in the database which it interacts with and has ‘usage’ permissio…

---

## [🚨 BLOCKED: dbt Fundamentals (VS Code) – Inconsistent Snowflake Setup Between Videos & profiles.yml Configuration](https://discourse.getdbt.com/t/blocked-dbt-fundamentals-vs-code-inconsistent-snowflake-setup-between-videos-profiles-yml-configuration/20931)

<div class="topic-metadata">

**Author:** [@shiva15surya](https://discourse.getdbt.com/u/shiva15surya)\
**Replies:** 0\
**Last updated:** [August 21, 2026, 1:07am UTC](https://discourse.getdbt.com/t/blocked-dbt-fundamentals-vs-code-inconsistent-snowflake-setup-between-videos-profiles-yml-configuration/20931 "2026-08-21T01:07:34Z")

</div>

Hi All, I’ve recently started learning dbt and I’m following the dbt Fundamentals (VS Code) course. While going through the setup process, I noticed a continuity issue between “Install the dbt VS Code Extension + dbt F…

---

## [Prevent accidental replacement of production tables while allowing dbt-managed schema evolution](https://discourse.getdbt.com/t/prevent-accidental-replacement-of-production-tables-while-allowing-dbt-managed-schema-evolution/20903)

<div class="topic-metadata">

**Author:** [@MichalR](https://discourse.getdbt.com/u/MichalR)\
**Replies:** 0\
**Last updated:** [July 27, 2026, 3:00pm UTC](https://discourse.getdbt.com/t/prevent-accidental-replacement-of-production-tables-while-allowing-dbt-managed-schema-evolution/20903 "2026-07-27T15:00:59Z")

</div>

We had an incremental model using the delete+insert strategy. Instead of updating the existing production table, dbt treated it as missing, followed its initial-creation path, and replaced it with an empty table. Overri…

---

## [Migrating a ETL to DBT: Target table conflict](https://discourse.getdbt.com/t/migrating-a-etl-to-dbt-target-table-conflict/20270)

<div class="topic-metadata">

**Author:** [@martinr](https://discourse.getdbt.com/u/martinr)\
**Replies:** 17\
**Last updated:** [July 27, 2026, 2:59pm UTC](https://discourse.getdbt.com/t/migrating-a-etl-to-dbt-target-table-conflict/20270 "2026-07-27T14:59:44Z")

</div>

The problem I’m having I have 2 models that are inserting into the same table of my warehouse. (schema='my\_schema', alias='my\_table', materialized='incremental', incremental\_strategy='append') It raises me the error: …

---

## [dbt parse aborts with SIGABRT (stack overflow) in the load/parse phase on default thread stack](https://discourse.getdbt.com/t/dbt-parse-aborts-with-sigabrt-stack-overflow-in-the-load-parse-phase-on-default-thread-stack/20891)

<div class="topic-metadata">

**Author:** [@cafenoctua](https://discourse.getdbt.com/u/cafenoctua)\
**Replies:** 0\
**Last updated:** [July 24, 2026, 1:50pm UTC](https://discourse.getdbt.com/t/dbt-parse-aborts-with-sigabrt-stack-overflow-in-the-load-parse-phase-on-default-thread-stack/20891 "2026-07-24T13:50:48Z")

</div>

Summary Running dbt parse aborts with SIGABRT (Abort trap: 6) before producing any error message. The crash report shows a stack overflow, not a panic — the faulting thread bottoms out in the Rust stack-overflow signa…

---

## [DBT wizard custom endpoint and BYOK for anthropic](https://discourse.getdbt.com/t/dbt-wizard-custom-endpoint-and-byok-for-anthropic/20884)

<div class="topic-metadata">

**Author:** [@omkar.n](https://discourse.getdbt.com/u/omkar.n)\
**Replies:** 0\
**Last updated:** [July 23, 2026, 2:08pm UTC](https://discourse.getdbt.com/t/dbt-wizard-custom-endpoint-and-byok-for-anthropic/20884 "2026-07-23T14:08:58Z")

</div>

I am not sure how to override base url of anthropic provider in dbt wizard. I want to use local proxy llm setup with custom endpoint and key.

---

## [I want to Redact Names in my feedback column how can i achieve this in DBT Macro?](https://discourse.getdbt.com/t/i-want-to-redact-names-in-my-feedback-column-how-can-i-achieve-this-in-dbt-macro/20882)

<div class="topic-metadata">

**Author:** [@SAIKARTHIK](https://discourse.getdbt.com/u/SAIKARTHIK)\
**Replies:** 0\
**Last updated:** [July 23, 2026, 10:52am UTC](https://discourse.getdbt.com/t/i-want-to-redact-names-in-my-feedback-column-how-can-i-achieve-this-in-dbt-macro/20882 "2026-07-23T10:52:18Z")

</div>

The problem I’m having: I want to Redact Names in my feedback column how can i achieve this in dbt Macro? The context of why I’m trying to do this: to redact the PII data like user names What I’ve already tried: tried …

---

## [Issue on snapshot when upgrading from dbt core 1.12.0rc1 to rc2, rc3 or 1.12.0](https://discourse.getdbt.com/t/issue-on-snapshot-when-upgrading-from-dbt-core-1-12-0rc1-to-rc2-rc3-or-1-12-0/20877)

<div class="topic-metadata">

**Author:** [@Remy\_sdis35](https://discourse.getdbt.com/u/Remy_sdis35)\
**Replies:** 0\
**Last updated:** [July 22, 2026, 8:36am UTC](https://discourse.getdbt.com/t/issue-on-snapshot-when-upgrading-from-dbt-core-1-12-0rc1-to-rc2-rc3-or-1-12-0/20877 "2026-07-22T08:36:52Z")

</div>

For the moment, I’m using dbt-core 1.12.0b3 with dbt-postgres 1.11.0. I’ve a docker container with 1 snapshot (selector is running only this snapshot): container\_name: mycontainer command: \[ "snapshot", "--profile", "…

---

## [Staging Model as Table/Incrmental for AWSGLUE source](https://discourse.getdbt.com/t/staging-model-as-table-incrmental-for-awsglue-source/20862)

<div class="topic-metadata">

**Author:** [@sumida30](https://discourse.getdbt.com/u/sumida30)\
**Replies:** 0\
**Last updated:** [July 9, 2026, 1:34pm UTC](https://discourse.getdbt.com/t/staging-model-as-table-incrmental-for-awsglue-source/20862 "2026-07-09T13:34:09Z")

</div>

We are using AWS GLUE as our source(Logical silver layer) to build gold layer via dbt and Databricks.What would be best materialzation logic for Stging model source tabes .Its Table or view or incrmenetal

---

## [Managing sensitive data access in a shared dbt repository](https://discourse.getdbt.com/t/managing-sensitive-data-access-in-a-shared-dbt-repository/20855)

<div class="topic-metadata">

**Author:** [@evellyn.natalee](https://discourse.getdbt.com/u/evellyn.natalee)\
**Replies:** 0\
**Last updated:** [July 2, 2026, 10:43pm UTC](https://discourse.getdbt.com/t/managing-sensitive-data-access-in-a-shared-dbt-repository/20855 "2026-07-02T22:43:53Z")

</div>

Hi everyone, I’m looking for some insights on how to manage sensitive data access in a shared data warehouse project. The Problem We have a Kimball-style data warehouse repository managed with dbt. We are planning to a…

---

## [dbt wizard startup - litellm error](https://discourse.getdbt.com/t/dbt-wizard-startup-litellm-error/20848)

<div class="topic-metadata">

**Author:** [@spireite](https://discourse.getdbt.com/u/spireite)\
**Replies:** 0\
**Last updated:** [June 23, 2026, 2:24pm UTC](https://discourse.getdbt.com/t/dbt-wizard-startup-litellm-error/20848 "2026-06-23T14:24:53Z")

</div>

Truing out dbt wizard. I have a container, and am in the venv. dbt wizard installed, and setup with a snowflake PAT key. When starting ‘wizard’ the following comes up ■ local proxy unavailable: local LiteLLM proces…

---

## [\[Bug\] dbt-oracle v1.7.4: ORA-00905 missing keyword on COMMENT ON COLUMN despite "quote: true"](https://discourse.getdbt.com/t/bug-dbt-oracle-v1-7-4-ora-00905-missing-keyword-on-comment-on-column-despite-quote-true/20811)

<div class="topic-metadata">

**Author:** [@r3phouw](https://discourse.getdbt.com/u/r3phouw)\
**Replies:** 0\
**Last updated:** [June 2, 2026, 9:34pm UTC](https://discourse.getdbt.com/t/bug-dbt-oracle-v1-7-4-ora-00905-missing-keyword-on-comment-on-column-despite-quote-true/20811 "2026-06-02T21:34:01Z")

</div>

Hi everyone, I am encountering an issue with the dbt-oracle adapter (version 1.7.4) when trying to apply descriptions to columns that contain spaces and dashes in their names. Even though I explicitly set quote: true i…

---

## [dbt’s VS Code experience is becoming a real Analytics Engineering IDE](https://discourse.getdbt.com/t/dbt-s-vs-code-experience-is-becoming-a-real-analytics-engineering-ide/20803)

<div class="topic-metadata">

**Author:** [@isushilb](https://discourse.getdbt.com/u/isushilb)\
**Replies:** 0\
**Last updated:** [May 23, 2026, 1:34pm UTC](https://discourse.getdbt.com/t/dbt-s-vs-code-experience-is-becoming-a-real-analytics-engineering-ide/20803 "2026-05-23T13:34:26Z")

</div>

The new Catalog (Beta) view inside VS Code is a surprisingly big upgrade. Now you can see: :white\_check\_mark: column documentation :white\_check\_mark: tests :white\_check\_mark: model metadata :white\_check\_mark: govern…

---

## [Are full MD5 hashes a good default for surrogate keys?](https://discourse.getdbt.com/t/are-full-md5-hashes-a-good-default-for-surrogate-keys/20797)

<div class="topic-metadata">

**Author:** [@anderspoirel](https://discourse.getdbt.com/u/anderspoirel)\
**Replies:** 0\
**Last updated:** [May 17, 2026, 10:55pm UTC](https://discourse.getdbt.com/t/are-full-md5-hashes-a-good-default-for-surrogate-keys/20797 "2026-05-17T22:55:23Z")

</div>

dbt’s generate\_surrogate\_key macro takes a MD5 hash of the input columns and returns it as a string. I would expect string keys to perform worse than 64-bit integer keys in joins due to their larger size. In my benchmark…

---

## [Using databricks job compute with DBT](https://discourse.getdbt.com/t/using-databricks-job-compute-with-dbt/12121)

<div class="topic-metadata">

**Author:** [@fawad](https://discourse.getdbt.com/u/fawad)\
**Replies:** 3\
**Last updated:** [May 11, 2026, 5:32am UTC](https://discourse.getdbt.com/t/using-databricks-job-compute-with-dbt/12121 "2026-05-11T05:32:33Z")

</div>

Currently,i am running dbt jobs with all purpose cluster deployed through github and under service principle. I wants to switch to Job compute. The problem that i am facing is the http\_path. i am able to provide the htt…

---

## [Unit tests failing with: "cannot access local variable 'connection' where it is not associated with a value"](https://discourse.getdbt.com/t/unit-tests-failing-with-cannot-access-local-variable-connection-where-it-is-not-associated-with-a-value/20422)

<div class="topic-metadata">

**Author:** [@SFearnside\_RBA](https://discourse.getdbt.com/u/SFearnside_RBA)\
**Replies:** 2\
**Last updated:** [April 28, 2026, 2:10pm UTC](https://discourse.getdbt.com/t/unit-tests-failing-with-cannot-access-local-variable-connection-where-it-is-not-associated-with-a-value/20422 "2026-04-28T14:10:47Z")

</div>

I have some unit tests that I’ve written within a model’s configuration (i.e. YAML) file. Whenever I attempt to run them, they always fail with the following error: “cannot access local variable ‘connection’ where it is…

---

## [Stop jumping between Airflow, dbt Cloud, and Snowflake to debug a failed run. I built something to fix this.](https://discourse.getdbt.com/t/stop-jumping-between-airflow-dbt-cloud-and-snowflake-to-debug-a-failed-run-i-built-something-to-fix-this/20761)

<div class="topic-metadata">

**Author:** [@gharikrishnade](https://discourse.getdbt.com/u/gharikrishnade)\
**Replies:** 0\
**Last updated:** [April 26, 2026, 11:09am UTC](https://discourse.getdbt.com/t/stop-jumping-between-airflow-dbt-cloud-and-snowflake-to-debug-a-failed-run-i-built-something-to-fix-this/20761 "2026-04-26T11:09:36Z")

</div>

Stop jumping between Airflow, dbt Cloud, and Snowflake to debug a failed run. I built something to fix this. Every data engineer knows the drill. A DAG fails at 2 AM. You open Airflow — the logs say 404. You switch to …

---

## [dbt Zettelkasten — A Skill for OpenCode & Claude Agents to Build a "Second Brain" for Your Data Warehouse](https://discourse.getdbt.com/t/dbt-zettelkasten-a-skill-for-opencode-claude-agents-to-build-a-second-brain-for-your-data-warehouse/20733)

<div class="topic-metadata">

**Author:** [@munmridul](https://discourse.getdbt.com/u/munmridul)\
**Replies:** 1\
**Last updated:** [April 22, 2026, 2:32pm UTC](https://discourse.getdbt.com/t/dbt-zettelkasten-a-skill-for-opencode-claude-agents-to-build-a-second-brain-for-your-data-warehouse/20733 "2026-04-22T14:32:40Z")

</div>

Your schema.yml describes what your models do. But why you chose cash over accrual accounting, what that hardcoded filter is working around, why that staging model exists at all — that’s in Slack threads, someone’s head,…

---

## [OSS Unity Catalog](https://discourse.getdbt.com/t/oss-unity-catalog/20720)

<div class="topic-metadata">

**Author:** [@GCash](https://discourse.getdbt.com/u/GCash)\
**Replies:** 0\
**Last updated:** [April 7, 2026, 11:35am UTC](https://discourse.getdbt.com/t/oss-unity-catalog/20720 "2026-04-07T11:35:02Z")

</div>

Hello, does anyone know if it is possible to use OSS Unity Catalog with dbt-core and dbt-spark? I am using OSS Apache Spark 4.1.1 with OSS Unity Catalog 0.4.0 on my local Windows laptop in WSL. So far I have being tryi…

---

## [Integrating dbt Projects with Github in Snowflake Workspaces](https://discourse.getdbt.com/t/integrating-dbt-projects-with-github-in-snowflake-workspaces/20718)

<div class="topic-metadata">

**Author:** [@nagendrababu.l](https://discourse.getdbt.com/u/nagendrababu.l)\
**Replies:** 0\
**Last updated:** [April 7, 2026, 3:21am UTC](https://discourse.getdbt.com/t/integrating-dbt-projects-with-github-in-snowflake-workspaces/20718 "2026-04-07T03:21:41Z")

</div>

A Step-by-Step Guide: Integrating dbt (data build tool) directly into Snowflake Workspaces allows data engineers to build, version-control, and execute data models without ever leaving the Snowflake interface. By leve…

---

## [New created objects in dbt Fundamentals course without explanation](https://discourse.getdbt.com/t/new-created-objects-in-dbt-fundamentals-course-without-explanation/20630)

<div class="topic-metadata">

**Author:** [@kukuruzer](https://discourse.getdbt.com/u/kukuruzer)\
**Replies:** 0\
**Last updated:** [March 15, 2026, 6:03pm UTC](https://discourse.getdbt.com/t/new-created-objects-in-dbt-fundamentals-course-without-explanation/20630 "2026-03-15T18:03:46Z")

</div>

On stage “Benefits of the dbt Fusion Engine“ in dbt Fundamentals course I see two new folders: marts and stagging and also new sql object - dim\_customers.sql which didn’t exist at the end of previous step “dbt Fusion …

---

## [using doc macro in yml file is not executed on macro](https://discourse.getdbt.com/t/using-doc-macro-in-yml-file-is-not-executed-on-macro/20620)

<div class="topic-metadata">

**Author:** [@msaeli](https://discourse.getdbt.com/u/msaeli)\
**Replies:** 9\
**Last updated:** [March 11, 2026, 8:16am UTC](https://discourse.getdbt.com/t/using-doc-macro-in-yml-file-is-not-executed-on-macro/20620 "2026-03-11T08:16:06Z")

</div>

The problem I’m having I am using the doc macro in my YML file. I need to use the column definition (retrieve the doc() result) into a custom macro, but the doc is undefined. The context of why I’m trying to do this I …

[Next page](https://discourse.getdbt.com/tag/dbt-core/96.md?match_all_tags=true&page=1&tags%5B%5D=dbt-core)