# Latest

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

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

**Page:** 3

---

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

---

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

---

## [Inquiry regarding Student Discount for dbt Analytics Engineering Certification](https://discourse.getdbt.com/t/inquiry-regarding-student-discount-for-dbt-analytics-engineering-certification/20744)

<div class="topic-metadata">

**Author:** [@Tsedensodnom](https://discourse.getdbt.com/u/Tsedensodnom)\
**Replies:** 0\
**Last updated:** [April 20, 2026, 4:17am UTC](https://discourse.getdbt.com/t/inquiry-regarding-student-discount-for-dbt-analytics-engineering-certification/20744 "2026-04-20T04:17:39Z")

</div>

Dear Team, I am writing to express my strong interest in taking the dbt Analytics Engineering Certification exam. As an aspiring data professional currently pursuing my studies at the Mongolian University of Science and…

---

## [model.path results in VS Code on Windows has back slashes and includes the 'models' node](https://discourse.getdbt.com/t/model-path-results-in-vs-code-on-windows-has-back-slashes-and-includes-the-models-node/20739)

<div class="topic-metadata">

**Author:** [@patercook](https://discourse.getdbt.com/u/patercook)\
**Replies:** 0\
**Last updated:** [April 16, 2026, 5:22pm UTC](https://discourse.getdbt.com/t/model-path-results-in-vs-code-on-windows-has-back-slashes-and-includes-the-models-node/20739 "2026-04-16T17:22:03Z")

</div>

So far, I have run into two issues when attempting to migrate to Windows VS Code/fusion from Studio. When utilizing model.path in a macro, the results in VS Code: Has back slashes instead of slashes Includes the ‘mode…

---

## [unable to trigger a dbt cloud CI job with github](https://discourse.getdbt.com/t/unable-to-trigger-a-dbt-cloud-ci-job-with-github/20735)

<div class="topic-metadata">

**Author:** [@bhagyashree.k.bhat](https://discourse.getdbt.com/u/bhagyashree.k.bhat)\
**Replies:** 0\
**Last updated:** [April 13, 2026, 10:29pm UTC](https://discourse.getdbt.com/t/unable-to-trigger-a-dbt-cloud-ci-job-with-github/20735 "2026-04-13T22:29:01Z")

</div>

The problem I’m having I am setting up the CI job in dbt cloud, which needs to be triggered upon PR submission. But its not triggering the CI job when I submit a PR. We are connecting to github via github app method, …

---

## [Semantic Layer vs. Text-to-SQL: 2026 Benchmark Update](https://discourse.getdbt.com/t/semantic-layer-vs-text-to-sql-2026-benchmark-update/20721)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [April 13, 2026, 4:41pm UTC](https://discourse.getdbt.com/t/semantic-layer-vs-text-to-sql-2026-benchmark-update/20721 "2026-04-13T16:41:16Z")

</div>

This is a companion discussion topic for the original entry at Semantic Layer vs. Text-to-SQL: 2026 Benchmark Update | dbt Developer Blog

---

## [Unable to register for dbt Exam - Connection Error](https://discourse.getdbt.com/t/unable-to-register-for-dbt-exam-connection-error/20691)

<div class="topic-metadata">

**Author:** [@rs.munozcarrasco](https://discourse.getdbt.com/u/rs.munozcarrasco)\
**Replies:** 1\
**Last updated:** [April 12, 2026, 5:40pm UTC](https://discourse.getdbt.com/t/unable-to-register-for-dbt-exam-connection-error/20691 "2026-04-12T17:40:36Z")

</div>

The problem I’m having Hello everyone ! I’m having an issue when trying to register to the dbt Analytics Engineering Certification Exam on : Candidate X What I’ve already tried I tried to connect directly with my Googl…

---

## [How to set up a Google Sheet as a reliable data source](https://discourse.getdbt.com/t/how-to-set-up-a-google-sheet-as-a-reliable-data-source/360)

<div class="topic-metadata">

**Author:** [@joshtemple](https://discourse.getdbt.com/u/joshtemple)\
**Replies:** 3\
**Last updated:** [April 12, 2026, 5:36pm UTC](https://discourse.getdbt.com/t/how-to-set-up-a-google-sheet-as-a-reliable-data-source/360 "2026-04-12T17:36:54Z")

</div>

This post is adapted from a more in-depth Medium article I wrote here. I occasionally need to grant a non-technical colleague the ability to input information into our data warehouse on an ad-hoc basis. For example, our…

---

## [Export doc blocks to BigQuery table?](https://discourse.getdbt.com/t/export-doc-blocks-to-bigquery-table/20732)

<div class="topic-metadata">

**Author:** [@oddgeir.hoie](https://discourse.getdbt.com/u/oddgeir.hoie)\
**Replies:** 0\
**Last updated:** [April 10, 2026, 9:25am UTC](https://discourse.getdbt.com/t/export-doc-blocks-to-bigquery-table/20732 "2026-04-10T09:25:57Z")

</div>

The problem I’m having Trying to export doc blocks to a materialized table in BigQuery The context of why I’m trying to do this I already have queries extracting column names from tables, and a macro exporting column na…

---

## [relationship test specifying only the table (assumed to be in same source)](https://discourse.getdbt.com/t/relationship-test-specifying-only-the-table-assumed-to-be-in-same-source/20731)

<div class="topic-metadata">

**Author:** [@azl](https://discourse.getdbt.com/u/azl)\
**Replies:** 0\
**Last updated:** [April 9, 2026, 11:51am UTC](https://discourse.getdbt.com/t/relationship-test-specifying-only-the-table-assumed-to-be-in-same-source/20731 "2026-04-09T11:51:18Z")

</div>

I have multiple sources with the same table structure, on which various datatests need to be done. I want to DRY up the definition of my source tests by using yaml anchors e.g. sources: - name: source1 schema: sc…

---

## [How do teams keep column documentation usable at scale?](https://discourse.getdbt.com/t/how-do-teams-keep-column-documentation-usable-at-scale/20626)

<div class="topic-metadata">

**Author:** [@sildatam](https://discourse.getdbt.com/u/sildatam)\
**Replies:** 2\
**Last updated:** [April 8, 2026, 3:52am UTC](https://discourse.getdbt.com/t/how-do-teams-keep-column-documentation-usable-at-scale/20626 "2026-04-08T03:52:08Z")

</div>

Curious how analytics teams actually manage column-level documentation in practice. Where do descriptions and business definitions usually live? dbt docs, a catalog, spreadsheets, somewhere else? And if someone had to…

---

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

---

## [Soumitra Dutta Oxford: How do I set up dbt in my development environment?](https://discourse.getdbt.com/t/soumitra-dutta-oxford-how-do-i-set-up-dbt-in-my-development-environment/20634)

<div class="topic-metadata">

**Author:** [@soumitradutta26](https://discourse.getdbt.com/u/soumitradutta26)\
**Replies:** 2\
**Last updated:** [March 26, 2026, 4:57pm UTC](https://discourse.getdbt.com/t/soumitra-dutta-oxford-how-do-i-set-up-dbt-in-my-development-environment/20634 "2026-03-26T16:57:17Z")

</div>

Hi, My name is Soumitra Dutta, an Oxford-based entrepreneur & photographer. I’m trying to set up dbt in my development environment but could use some guidance. What’s your recommended approach for getting started? Are t…

---

## [Built a SQL data debugging toolkit - looking for analysts to test it](https://discourse.getdbt.com/t/built-a-sql-data-debugging-toolkit-looking-for-analysts-to-test-it/20635)

<div class="topic-metadata">

**Author:** [@burzykowskianalytics](https://discourse.getdbt.com/u/burzykowskianalytics)\
**Replies:** 0\
**Last updated:** [March 18, 2026, 1:49pm UTC](https://discourse.getdbt.com/t/built-a-sql-data-debugging-toolkit-looking-for-analysts-to-test-it/20635 "2026-03-18T13:49:27Z")

</div>

I’ve been working on a structured SQL debugging workflow for analysts and BI developers. It consists of 30 SQL checks organized into a 7-step workflow (schema validation → nulls → duplicates → joins → distribution → fres…

---

## [Hey everyone, looking for some Azure SQL adapter wisdom.](https://discourse.getdbt.com/t/hey-everyone-looking-for-some-azure-sql-adapter-wisdom/20631)

<div class="topic-metadata">

**Author:** [@aisolutionarchitect](https://discourse.getdbt.com/u/aisolutionarchitect)\
**Replies:** 0\
**Last updated:** [March 16, 2026, 1:35am UTC](https://discourse.getdbt.com/t/hey-everyone-looking-for-some-azure-sql-adapter-wisdom/20631 "2026-03-16T01:35:36Z")

</div>

My team recently finished architecting an Agentic GenBI pipeline (we’re using dbt to build a governed semantic layer that feeds into a Python/LangChain reasoning loop). The AI side is working beautifully, but we hit a fr…

---

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

---

## [Why are CI jobs ("state" method) building more/less models/nodes than expected?](https://discourse.getdbt.com/t/why-are-ci-jobs-state-method-building-more-less-models-nodes-than-expected/7504)

<div class="topic-metadata">

**Author:** [@jeremyyeo](https://discourse.getdbt.com/u/jeremyyeo)\
**Replies:** 4\
**Last updated:** [March 13, 2026, 5:53pm UTC](https://discourse.getdbt.com/t/why-are-ci-jobs-state-method-building-more-less-models-nodes-than-expected/7504 "2026-03-13T17:53:18Z")

</div>

Note: Recent dbt versions have introduced a new behaviour change flag state\_modified\_compare\_more\_unrendered\_values Behavior changes | dbt Developer Hub which will avoid some of the false positives discussed in this ar…

---

## [Connecting to snowflake via SSO](https://discourse.getdbt.com/t/connecting-to-snowflake-via-sso/12228)

<div class="topic-metadata">

**Author:** [@denised](https://discourse.getdbt.com/u/denised)\
**Replies:** 6\
**Last updated:** [March 11, 2026, 3:11pm UTC](https://discourse.getdbt.com/t/connecting-to-snowflake-via-sso/12228 "2026-03-11T15:11:05Z")

</div>

We’re trying to convert all of our Snowflake accounts to use SSO, and so we’re figuring out how to set that up for dbt. I did the obvious thing of replacing the password configuration in profile.yml with ... auth…

---

## [Looking for Advice on Preparing for the dbt Certification Exam](https://discourse.getdbt.com/t/looking-for-advice-on-preparing-for-the-dbt-certification-exam/17348)

<div class="topic-metadata">

**Author:** [@laurapalmeras](https://discourse.getdbt.com/u/laurapalmeras)\
**Replies:** 3\
**Last updated:** [March 11, 2026, 1:43pm UTC](https://discourse.getdbt.com/t/looking-for-advice-on-preparing-for-the-dbt-certification-exam/17348 "2026-03-11T13:43:30Z")

</div>

Hi all! :wave: I’m new here and have been working with dbt since September. I’m still getting my footing and learning as I go, but I have a big goal: I want to take the dbt Certification Exam. That said, I know there’s…

---

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

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

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