# Latest

**URL:** https://discourse.getdbt.com/latest.md?page=1

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

**Page:** 2

---

## [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

---

## [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:** 0\
**Last updated:** [July 7, 2026, 10:10pm UTC](https://discourse.getdbt.com/t/sql-server-in-dbt-core-v2-fusion/20860 "2026-07-07T22:10:12Z")

</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…

---

## [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…

---

## [Live error detection - dbt VS Code extension](https://discourse.getdbt.com/t/live-error-detection-dbt-vs-code-extension/20734)

<div class="topic-metadata">

**Author:** [@Carles](https://discourse.getdbt.com/u/Carles)\
**Replies:** 1\
**Last updated:** [July 2, 2026, 10:19pm UTC](https://discourse.getdbt.com/t/live-error-detection-dbt-vs-code-extension/20734 "2026-07-02T22:19:10Z")

</div>

Hi everyone :waving\_hand: I’m using the dbt VS Code extension connected to Snowflake, and the “Live error detection” feature works fine for syntax issues like missing commas or invalid ref. However, I have a question: …

---

## [Known-answer testing for dbt: synthetic seeds where you decide the metric/KPI before the model runs](https://discourse.getdbt.com/t/known-answer-testing-for-dbt-synthetic-seeds-where-you-decide-the-metric-kpi-before-the-model-runs/20850)

<div class="topic-metadata">

**Author:** [@muhammedrasin](https://discourse.getdbt.com/u/muhammedrasin)\
**Replies:** 0\
**Last updated:** [June 26, 2026, 6:40am UTC](https://discourse.getdbt.com/t/known-answer-testing-for-dbt-synthetic-seeds-where-you-decide-the-metric-kpi-before-the-model-runs/20850 "2026-06-26T06:40:06Z")

</div>

I want to share a testing pattern that has changed how I trust my dbt models, plus a small tool I built to make it practical. I am genuinely curious whether other people here already do a version of this, because I went …

---

## [Gandiva Exception in DBT Core with Dremio](https://discourse.getdbt.com/t/gandiva-exception-in-dbt-core-with-dremio/20849)

<div class="topic-metadata">

**Author:** [@RiyaGupta](https://discourse.getdbt.com/u/RiyaGupta)\
**Replies:** 0\
**Last updated:** [June 25, 2026, 1:13pm UTC](https://discourse.getdbt.com/t/gandiva-exception-in-dbt-core-with-dremio/20849 "2026-06-25T13:13:05Z")

</div>

Whenever we are loading the data via dbt model, and column data type for casting is defined as int but the value of data is in bigint then it throws Gandiva Expection and did not tell in which column issue persists. So …

---

## [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…

---

## [Integrating DBT -Purview](https://discourse.getdbt.com/t/integrating-dbt-purview/19205)

<div class="topic-metadata">

**Author:** [@joyia](https://discourse.getdbt.com/u/joyia)\
**Replies:** 1\
**Last updated:** [June 22, 2026, 6:42pm UTC](https://discourse.getdbt.com/t/integrating-dbt-purview/19205 "2026-06-22T18:42:08Z")

</div>

The problem I’m having I am following dbt-pv scripts for moving dbt lineage information into Purview. My goal is to achieve these following actions Prepare execution (check if everything is ready) Trigger dbt Entities…

---

## [DBT Analytics Engineer Certification](https://discourse.getdbt.com/t/dbt-analytics-engineer-certification/20841)

<div class="topic-metadata">

**Author:** [@manthanpatil912](https://discourse.getdbt.com/u/manthanpatil912)\
**Replies:** 0\
**Last updated:** [June 17, 2026, 5:02am UTC](https://discourse.getdbt.com/t/dbt-analytics-engineer-certification/20841 "2026-06-17T05:02:35Z")

</div>

Does someone have or know how to get dbt Analytics Engineer Certification exam free voucher? Any other platform providing dbt advanced certification would help as well.

---

## [dbt Wizard CLI setup: Snowflake API key entry fails silently](https://discourse.getdbt.com/t/dbt-wizard-cli-setup-snowflake-api-key-entry-fails-silently/20831)

<div class="topic-metadata">

**Author:** [@curmudgeon](https://discourse.getdbt.com/u/curmudgeon)\
**Replies:** 0\
**Last updated:** [June 12, 2026, 2:20pm UTC](https://discourse.getdbt.com/t/dbt-wizard-cli-setup-snowflake-api-key-entry-fails-silently/20831 "2026-06-12T14:20:49Z")

</div>

Hello, this is my first post. Please forgive if I didn’t tag this properly. I’m trying to submit a possible “bug report” for dbt Wizard CLI setup. The problem I’m having During intial setup with dbt Wizard CLI, I try to…

---

## [Offical Doc return Understanding](https://discourse.getdbt.com/t/offical-doc-return-understanding/20818)

<div class="topic-metadata">

**Author:** [@aditya](https://discourse.getdbt.com/u/aditya)\
**Replies:** 0\
**Last updated:** [June 5, 2026, 11:27am UTC](https://discourse.getdbt.com/t/offical-doc-return-understanding/20818 "2026-06-05T11:27:00Z")

</div>

so I am referring this link ( About return function | dbt Developer Hub ) to understand the diff between {{ return() }} and {% do return() %} I used like this ---- macro {% macro get\_cols() %} {{- return(\[‘user\_id’, …

---

## [Interpretation of the intermediate layer](https://discourse.getdbt.com/t/interpretation-of-the-intermediate-layer/20816)

<div class="topic-metadata">

**Author:** [@tea](https://discourse.getdbt.com/u/tea)\
**Replies:** 0\
**Last updated:** [June 3, 2026, 11:27am UTC](https://discourse.getdbt.com/t/interpretation-of-the-intermediate-layer/20816 "2026-06-03T11:27:30Z")

</div>

We are migrating from a SQL Server database project to dbt, and are in the process of establishing naming conventions and folder structure for our new dbt project. We have read the best practice guidelines for project s…

---

## [\[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 Fundamentals - Section 4 Quiz](https://discourse.getdbt.com/t/dbt-fundamentals-section-4-quiz/20808)

<div class="topic-metadata">

**Author:** [@maciejxy](https://discourse.getdbt.com/u/maciejxy)\
**Replies:** 0\
**Last updated:** [June 1, 2026, 11:23am UTC](https://discourse.getdbt.com/t/dbt-fundamentals-section-4-quiz/20808 "2026-06-01T11:23:49Z")

</div>

The problem I’m having I can’t get past question 3 in section 4 quiz. I’ve tried all available options. I think there is an error here. The context of why I’m trying to do this What I’ve already tried Some example cod…

---

## [Struct evolution handleing in dbt snapshot](https://discourse.getdbt.com/t/struct-evolution-handleing-in-dbt-snapshot/20805)

<div class="topic-metadata">

**Author:** [@aniketmane.85](https://discourse.getdbt.com/u/aniketmane.85)\
**Replies:** 0\
**Last updated:** [May 26, 2026, 8:46pm UTC](https://discourse.getdbt.com/t/struct-evolution-handleing-in-dbt-snapshot/20805 "2026-05-26T20:46:44Z")

</div>

So we are using dbt snapshot to get snapshot of source data and data has some column with struct data type. Now recently our snaoshot job failed as schema of this struct got changed.. basically added few more keys..causi…

---

## [Looker to DBT connections and drawbacks](https://discourse.getdbt.com/t/looker-to-dbt-connections-and-drawbacks/20804)

<div class="topic-metadata">

**Author:** [@akshat1](https://discourse.getdbt.com/u/akshat1)\
**Replies:** 0\
**Last updated:** [May 25, 2026, 8:09am UTC](https://discourse.getdbt.com/t/looker-to-dbt-connections-and-drawbacks/20804 "2026-05-25T08:09:16Z")

</div>

How do we connect dbt to looker what i mean to say is suppose if we are writing any liquid in look ML and we are pushing it to dbt how would it look like ? and also what are the limitations in this

---

## [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…

---

## [Snowflake configuration not working in dbt](https://discourse.getdbt.com/t/snowflake-configuration-not-working-in-dbt/20792)

<div class="topic-metadata">

**Author:** [@suha](https://discourse.getdbt.com/u/suha)\
**Replies:** 1\
**Last updated:** [May 23, 2026, 1:21pm UTC](https://discourse.getdbt.com/t/snowflake-configuration-not-working-in-dbt/20792 "2026-05-23T13:21:35Z")

</div>

---

## [ref autofilling stopped](https://discourse.getdbt.com/t/ref-autofilling-stopped/20799)

<div class="topic-metadata">

**Author:** [@dstutz7](https://discourse.getdbt.com/u/dstutz7)\
**Replies:** 0\
**Last updated:** [May 21, 2026, 4:06pm UTC](https://discourse.getdbt.com/t/ref-autofilling-stopped/20799 "2026-05-21T16:06:30Z")

</div>

Whenever I used to type \_\_ref it would pop up with the jinja {{ ref(‘model\_name’) }} and I could replace model\_name with whatever name I wanted and it would auto suggest model names I had with those letters. Now it doesn…

---

## [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…

---

## [Built ERD Studio — visual ERD designer that lives in your dbt repo (open source, AI-readable)](https://discourse.getdbt.com/t/built-erd-studio-visual-erd-designer-that-lives-in-your-dbt-repo-open-source-ai-readable/20787)

<div class="topic-metadata">

**Author:** [@liam.alex93](https://discourse.getdbt.com/u/liam.alex93)\
**Replies:** 0\
**Last updated:** [May 12, 2026, 1:34am UTC](https://discourse.getdbt.com/t/built-erd-studio-visual-erd-designer-that-lives-in-your-dbt-repo-open-source-ai-readable/20787 "2026-05-12T01:34:05Z")

</div>

Hey all :waving\_hand: Sharing something I’ve been working on — ERD Studio, an open-source VS Code extension that puts a visual ERD designer inside your dbt repo. The problem My design lived in SqlDBM/dbdiagram. My co…

---

## [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…

---

## [Change in Intermediate Table Type for Python Incremental Models (dbt-snowflake 1.9.2 → 1.10.0)](https://discourse.getdbt.com/t/change-in-intermediate-table-type-for-python-incremental-models-dbt-snowflake-1-9-2-1-10-0/20778)

<div class="topic-metadata">

**Author:** [@shijic](https://discourse.getdbt.com/u/shijic)\
**Replies:** 0\
**Last updated:** [May 8, 2026, 11:03am UTC](https://discourse.getdbt.com/t/change-in-intermediate-table-type-for-python-incremental-models-dbt-snowflake-1-9-2-1-10-0/20778 "2026-05-08T11:03:10Z")

</div>

The problem I’m having: I have a dbt Python model configured with strategy = 'incremental'. In dbt-snowflake v1.9.2, the intermediate table was being created as a temporary table. After upgrading to dbt-snowflake v…

---

## [Always get headache about schemas](https://discourse.getdbt.com/t/always-get-headache-about-schemas/20775)

<div class="topic-metadata">

**Author:** [@ljy565099099](https://discourse.getdbt.com/u/ljy565099099)\
**Replies:** 0\
**Last updated:** [May 5, 2026, 9:56am UTC](https://discourse.getdbt.com/t/always-get-headache-about-schemas/20775 "2026-05-05T09:56:29Z")

</div>

Black box is another nightmare of table schemas. People come and go, in result some services or code bases become THE BLACK BOX. It works without documentations and no one knows how it works. Then, few people knows the m…

---

## [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…

---

## [dbt-semguard tool](https://discourse.getdbt.com/t/dbt-semguard-tool/20762)

<div class="topic-metadata">

**Author:** [@yeaight](https://discourse.getdbt.com/u/yeaight)\
**Replies:** 0\
**Last updated:** [April 26, 2026, 1:53pm UTC](https://discourse.getdbt.com/t/dbt-semguard-tool/20762 "2026-04-26T13:53:52Z")

</div>

i made this tool in case anyone finds it useful :slight\_smile:

---

## [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 …

---

## [Newbie in dbt we discuss about data migration tool to complement dbt](https://discourse.getdbt.com/t/newbie-in-dbt-we-discuss-about-data-migration-tool-to-complement-dbt/20758)

<div class="topic-metadata">

**Author:** [@LtRogers5](https://discourse.getdbt.com/u/LtRogers5)\
**Replies:** 1\
**Last updated:** [April 24, 2026, 6:11am UTC](https://discourse.getdbt.com/t/newbie-in-dbt-we-discuss-about-data-migration-tool-to-complement-dbt/20758 "2026-04-24T06:11:05Z")

</div>

The first question is. Does dbt needs to be complemented with a tool like Python alchemy, DbUp, FLyway, Liquibase, … to handle db changes, like increase column length, add a new column or maybe do a drop create to add a …

---

## [dbt certification - registration failed](https://discourse.getdbt.com/t/dbt-certification-registration-failed/20738)

<div class="topic-metadata">

**Author:** [@kissievendor](https://discourse.getdbt.com/u/kissievendor)\
**Replies:** 1\
**Last updated:** [April 23, 2026, 6:52am UTC](https://discourse.getdbt.com/t/dbt-certification-registration-failed/20738 "2026-04-23T06:52:41Z")

</div>

The problem I’m having I am trying to register for the exam, but talview is giving a registration error The context of why I’m trying to do this What I’ve already tried I’ve have tried multiple browsers, turning of adbl…

---

## [Modeling Recoverable Hours and Overtime in dbt](https://discourse.getdbt.com/t/modeling-recoverable-hours-and-overtime-in-dbt/20462)

<div class="topic-metadata">

**Author:** [@laflet](https://discourse.getdbt.com/u/laflet)\
**Replies:** 1\
**Last updated:** [April 22, 2026, 11:47pm UTC](https://discourse.getdbt.com/t/modeling-recoverable-hours-and-overtime-in-dbt/20462 "2026-04-22T23:47:04Z")

</div>

Hi everyone, I’m working on a reporting model that tracks recoverable hours and overtime for staff under a specific contractual agreement. I’d appreciate any advice on how you would approach modeling and visualizing thi…

[Previous page](https://discourse.getdbt.com/latest.md)

[Next page](https://discourse.getdbt.com/latest.md?page=2)