# \#devblog

**URL:** https://discourse.getdbt.com/tag/devblog/91.md

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

---

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

---

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

---

## [Make your AI better at data work with dbt's agent skills](https://discourse.getdbt.com/t/make-your-ai-better-at-data-work-with-dbts-agent-skills/20575)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 2\
**Last updated:** [March 5, 2026, 6:47pm UTC](https://discourse.getdbt.com/t/make-your-ai-better-at-data-work-with-dbts-agent-skills/20575 "2026-03-05T18:47:30Z")

</div>

This is a companion discussion topic for the original entry at Make your AI better at data work with dbt's agent skills | dbt Developer Blog

---

## [Modernizing the Semantic Layer Spec](https://discourse.getdbt.com/t/modernizing-the-semantic-layer-spec/20550)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [February 18, 2026, 7:38am UTC](https://discourse.getdbt.com/t/modernizing-the-semantic-layer-spec/20550 "2026-02-18T07:38:20Z")

</div>

This is a companion discussion topic for the original entry at Modernizing the Semantic Layer Spec | dbt Developer Blog

---

## [Problem with sequence keys with DBT core and SQL Server](https://discourse.getdbt.com/t/problem-with-sequence-keys-with-dbt-core-and-sql-server/20398)

<div class="topic-metadata">

**Author:** [@LtRogers5](https://discourse.getdbt.com/u/LtRogers5)\
**Replies:** 1\
**Last updated:** [November 5, 2025, 12:50pm UTC](https://discourse.getdbt.com/t/problem-with-sequence-keys-with-dbt-core-and-sql-server/20398 "2025-11-05T12:50:04Z")

</div>

The problem I’m having I want to update/insert data in a table where the PK key is an int and is autoupdated at the same time handle it with dbt. My initial idea was to use incremental table. I use SQL Server. Is there …

---

## [Surrogate keys in dbt: Integers or hashes?](https://discourse.getdbt.com/t/surrogate-keys-in-dbt-integers-or-hashes/6684)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 8\
**Last updated:** [November 5, 2025, 9:33am UTC](https://discourse.getdbt.com/t/surrogate-keys-in-dbt-integers-or-hashes/6684 "2025-11-05T09:33:40Z")

</div>

This is a companion discussion topic for the original entry at Surrogate keys in dbt: Integers or hashes? | dbt Developer Blog

---

## [dbt Fusion and Deferred Schema Cache](https://discourse.getdbt.com/t/dbt-fusion-and-deferred-schema-cache/20254)

<div class="topic-metadata">

**Author:** [@pempey](https://discourse.getdbt.com/u/pempey)\
**Replies:** 0\
**Last updated:** [September 24, 2025, 6:42pm UTC](https://discourse.getdbt.com/t/dbt-fusion-and-deferred-schema-cache/20254 "2025-09-24T18:42:22Z")

</div>

Intro I have recently been able to produce the full defer schema cash that dbt Fusion uses for various analysis from the existing catalog.json dbt artifact produced from the docs generate command in dbt Core. I did this…

---

## [DBT Orchestration: DBT Core with Airflow](https://discourse.getdbt.com/t/dbt-orchestration-dbt-core-with-airflow/19824)

<div class="topic-metadata">

**Author:** [@sanjaykumara1994](https://discourse.getdbt.com/u/sanjaykumara1994)\
**Replies:** 0\
**Last updated:** [July 10, 2025, 1:16pm UTC](https://discourse.getdbt.com/t/dbt-orchestration-dbt-core-with-airflow/19824 "2025-07-10T13:16:46Z")

</div>

Hello! I just wanted to share a tutorial on orchestrating dbt Core with Airflow. We are using Airflow 3.0 and dbt Core 1.9.0 for this tutorial. Article comparing the different setup options and Code repo …

---

## [Fusion: own your \`$PATH\`, choose your destiny](https://discourse.getdbt.com/t/fusion-own-your-path-choose-your-destiny/19719)

<div class="topic-metadata">

**Author:** [@data\_ders](https://discourse.getdbt.com/u/data_ders)\
**Replies:** 0\
**Last updated:** [June 25, 2025, 5:03pm UTC](https://discourse.getdbt.com/t/fusion-own-your-path-choose-your-destiny/19719 "2025-06-25T17:03:53Z")

</div>

when you type dbt run in the terminal and hit ENTER, the first thing the terminal does is ask itself: what is this dbt command? where might I find the code that corresponds to it? the $PATH most-traveled enter the $P…

---

## [What’s the difference between DBTcloudoperator and DBT API to trigger DBT jobs via airflow and which one is recommended to use ?](https://discourse.getdbt.com/t/what-s-the-difference-between-dbtcloudoperator-and-dbt-api-to-trigger-dbt-jobs-via-airflow-and-which-one-is-recommended-to-use/19260)

<div class="topic-metadata">

**Author:** [@Rishu1996](https://discourse.getdbt.com/u/Rishu1996)\
**Replies:** 0\
**Last updated:** [May 5, 2025, 12:39am UTC](https://discourse.getdbt.com/t/what-s-the-difference-between-dbtcloudoperator-and-dbt-api-to-trigger-dbt-jobs-via-airflow-and-which-one-is-recommended-to-use/19260 "2025-05-05T00:39:43Z")

</div>

What’s the difference between DBTcloudoperator and dbt API to trigger dbt jobs via airflow and which one is recommended to use ? Please explain in detail with examples. My organization is expanding in dbt and hence needs…

---

## [Getting Started with git Branching Strategies and dbt](https://discourse.getdbt.com/t/getting-started-with-git-branching-strategies-and-dbt/18561)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 5\
**Last updated:** [April 17, 2025, 9:29am UTC](https://discourse.getdbt.com/t/getting-started-with-git-branching-strategies-and-dbt/18561 "2025-04-17T09:29:12Z")

</div>

This is a companion discussion topic for the original entry at Getting Started with git Branching Strategies and dbt | dbt Developer Blog

---

## [The Three Levels of SQL Comprehension: What they are and why you need to know about them](https://discourse.getdbt.com/t/the-three-levels-of-sql-comprehension-what-they-are-and-why-you-need-to-know-about-them/17846)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 2\
**Last updated:** [January 28, 2025, 2:39am UTC](https://discourse.getdbt.com/t/the-three-levels-of-sql-comprehension-what-they-are-and-why-you-need-to-know-about-them/17846 "2025-01-28T02:39:45Z")

</div>

This is a companion discussion topic for the original entry at The Three Levels of SQL Comprehension: What they are and why you need to know about them | dbt Developer Blog

---

## [dbt run stuck at deleting tmp index](https://discourse.getdbt.com/t/dbt-run-stuck-at-deleting-tmp-index/17070)

<div class="topic-metadata">

**Author:** [@flow](https://discourse.getdbt.com/u/flow)\
**Replies:** 1\
**Last updated:** [November 27, 2024, 3:21pm UTC](https://discourse.getdbt.com/t/dbt-run-stuck-at-deleting-tmp-index/17070 "2024-11-27T15:21:40Z")

</div>

HI for starter i’m on MacOs, using a sql\_server on docker. Ive a project with multiples models. I’ve an issue. Everything was working fine with the first model ive created. And recently it began to get stuck when i try…

---

## [Towards an Error-free UNION ALL](https://discourse.getdbt.com/t/towards-an-error-free-union-all/6694)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 5\
**Last updated:** [September 25, 2024, 3:53am UTC](https://discourse.getdbt.com/t/towards-an-error-free-union-all/6694 "2024-09-25T03:53:13Z")

</div>

This is a companion discussion topic for the original entry at Towards an Error-free UNION ALL | dbt Developer Blog

---

## [BigQuery ingestion-time partitioning and partition copy with dbt](https://discourse.getdbt.com/t/bigquery-ingestion-time-partitioning-and-partition-copy-with-dbt/7237)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 5\
**Last updated:** [September 21, 2024, 11:48am UTC](https://discourse.getdbt.com/t/bigquery-ingestion-time-partitioning-and-partition-copy-with-dbt/7237 "2024-09-21T11:48:05Z")

</div>

This is a companion discussion topic for the original entry at BigQuery ingestion-time partitioning and partition copy with dbt | dbt Developer Blog

---

## [Latest dbt: a stable foundation for improvement](https://discourse.getdbt.com/t/latest-dbt-a-stable-foundation-for-improvement/13170)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 2\
**Last updated:** [August 9, 2024, 4:16am UTC](https://discourse.getdbt.com/t/latest-dbt-a-stable-foundation-for-improvement/13170 "2024-08-09T04:16:39Z")

</div>

This is a companion discussion topic for the original entry at Latest dbt: a stable foundation for improvement & innovation | dbt Developer Blog

---

## [What's a Primary Key and Why Do We Test Them?](https://discourse.getdbt.com/t/whats-a-primary-key-and-why-do-we-test-them/6720)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 4\
**Last updated:** [July 15, 2024, 5:33pm UTC](https://discourse.getdbt.com/t/whats-a-primary-key-and-why-do-we-test-them/6720 "2024-07-15T17:33:44Z")

</div>

This is a companion discussion topic for the original entry at What's a Primary Key and Why Do We Test Them? | dbt Developer Blog

---

## [More time coding, less time waiting: Mastering defer in dbt](https://discourse.getdbt.com/t/more-time-coding-less-time-waiting-mastering-defer-in-dbt/11474)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 2\
**Last updated:** [June 10, 2024, 11:50pm UTC](https://discourse.getdbt.com/t/more-time-coding-less-time-waiting-mastering-defer-in-dbt/11474 "2024-06-10T23:50:01Z")

</div>

This is a companion discussion topic for the original entry at More time coding, less time waiting: Mastering defer in dbt | dbt Developer Blog

---

## [Accelerate your documentation workflow: Generate docs for whole folders at once](https://discourse.getdbt.com/t/accelerate-your-documentation-workflow-generate-docs-for-whole-folders-at-once/8327)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 2\
**Last updated:** [May 31, 2024, 5:10pm UTC](https://discourse.getdbt.com/t/accelerate-your-documentation-workflow-generate-docs-for-whole-folders-at-once/8327 "2024-05-31T17:10:57Z")

</div>

This is a companion discussion topic for the original entry at Accelerate your documentation workflow: Generate docs for whole folders at once | dbt Developer Blog

---

## [DBT pyspark gcp Pyspark process datafram but can't write to table on bigquery at the end](https://discourse.getdbt.com/t/dbt-pyspark-gcp-pyspark-process-datafram-but-cant-write-to-table-on-bigquery-at-the-end/10721)

<div class="topic-metadata">

**Author:** [@ricardobarata](https://discourse.getdbt.com/u/ricardobarata)\
**Replies:** 2\
**Last updated:** [May 10, 2024, 3:06pm UTC](https://discourse.getdbt.com/t/dbt-pyspark-gcp-pyspark-process-datafram-but-cant-write-to-table-on-bigquery-at-the-end/10721 "2024-05-10T15:06:27Z")

</div>

HI I am using pyspark as a means to run custom code on dbt models. My tables are on bigquery and the spark cluster on gcp (dataproc). When running the model it fails. Looking at the spark logs, the spark processing wor…

---

## [Tackling the complexity of joining snapshots](https://discourse.getdbt.com/t/tackling-the-complexity-of-joining-snapshots/6705)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [February 20, 2024, 7:22pm UTC](https://discourse.getdbt.com/t/tackling-the-complexity-of-joining-snapshots/6705 "2024-02-20T19:22:50Z")

</div>

This is a companion discussion topic for the original entry at Tackling the complexity of joining snapshots | dbt Developer Blog

---

## [Amount of models in one project for one team](https://discourse.getdbt.com/t/amount-of-models-in-one-project-for-one-team/12090)

<div class="topic-metadata">

**Author:** [@Alexandru](https://discourse.getdbt.com/u/Alexandru)\
**Replies:** 0\
**Last updated:** [February 16, 2024, 2:39pm UTC](https://discourse.getdbt.com/t/amount-of-models-in-one-project-for-one-team/12090 "2024-02-16T14:39:49Z")

</div>

Hi, I know this is a long discussed topic, but my team is currently debating between a big mono project or a multi project architecture. We are currently responsible for around 500 models, in 5 different dbt projects, i…

---

## [How to Upgrade dbt Versions (Mostly) Without Fear](https://discourse.getdbt.com/t/how-to-upgrade-dbt-versions-mostly-without-fear/6681)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [February 15, 2024, 1:23am UTC](https://discourse.getdbt.com/t/how-to-upgrade-dbt-versions-mostly-without-fear/6681 "2024-02-15T01:23:07Z")

</div>

This is a companion discussion topic for the original entry at How to Upgrade dbt Versions (Mostly) Without Fear | dbt Developer Blog

---

## [A star (generator) is born](https://discourse.getdbt.com/t/a-star-generator-is-born/6704)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 2\
**Last updated:** [February 15, 2024, 12:20am UTC](https://discourse.getdbt.com/t/a-star-generator-is-born/6704 "2024-02-15T00:20:18Z")

</div>

This is a companion discussion topic for the original entry at A star (generator) is born | dbt Developer Blog

---

## [The Exact dbt Commands We Run in Production](https://discourse.getdbt.com/t/the-exact-dbt-commands-we-run-in-production/6692)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 3\
**Last updated:** [October 19, 2023, 5:31pm UTC](https://discourse.getdbt.com/t/the-exact-dbt-commands-we-run-in-production/6692 "2023-10-19T17:31:03Z")

</div>

This is a companion discussion topic for the original entry at The Exact dbt Commands We Run in Production | dbt Developer Blog

---

## [Building a Kimball dimensional model with dbt](https://discourse.getdbt.com/t/building-a-kimball-dimensional-model-with-dbt/7940)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 8\
**Last updated:** [October 16, 2023, 11:06am UTC](https://discourse.getdbt.com/t/building-a-kimball-dimensional-model-with-dbt/7940 "2023-10-16T11:06:44Z")

</div>

This is a companion discussion topic for the original entry at Building a Kimball dimensional model with dbt | dbt Developer Blog

---

## [Generating Surrogate Keys Across Warehouses](https://discourse.getdbt.com/t/generating-surrogate-keys-across-warehouses/6679)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [October 10, 2023, 8:57pm UTC](https://discourse.getdbt.com/t/generating-surrogate-keys-across-warehouses/6679 "2023-10-10T20:57:50Z")

</div>

This is a companion discussion topic for the original entry at Generating Surrogate Keys Across Warehouses | dbt Developer Blog

---

## [Strategies for change data capture in dbt](https://discourse.getdbt.com/t/strategies-for-change-data-capture-in-dbt/6682)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [October 5, 2023, 5:51am UTC](https://discourse.getdbt.com/t/strategies-for-change-data-capture-in-dbt/6682 "2023-10-05T05:51:56Z")

</div>

This is a companion discussion topic for the original entry at Strategies for change data capture in dbt | dbt Developer Blog

---

## [dbt Squared: Leveraging dbt Core and dbt Cloud together at scale](https://discourse.getdbt.com/t/dbt-squared-leveraging-dbt-core-and-dbt-cloud-together-at-scale/7884)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [October 4, 2023, 11:44am UTC](https://discourse.getdbt.com/t/dbt-squared-leveraging-dbt-core-and-dbt-cloud-together-at-scale/7884 "2023-10-04T11:44:36Z")

</div>

This is a companion discussion topic for the original entry at dbt Squared: Leveraging dbt Core and dbt Cloud together at scale | dbt Developer Blog

---

## [Optimizing Materialized Views with dbt](https://discourse.getdbt.com/t/optimizing-materialized-views-with-dbt/9401)

<div class="topic-metadata">

**Author:** [@system](https://discourse.getdbt.com/u/system)\
**Replies:** 1\
**Last updated:** [September 25, 2023, 1:59am UTC](https://discourse.getdbt.com/t/optimizing-materialized-views-with-dbt/9401 "2023-09-25T01:59:40Z")

</div>

This is a companion discussion topic for the original entry at Optimizing Materialized Views with dbt | dbt Developer Blog

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