# Show and Tell

**URL:** https://discourse.getdbt.com/c/show-and-tell/22.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

---

## [MXCP: Serve Secure, SQL-Based LLM Tools from Your dbt + DuckDB Stack](https://discourse.getdbt.com/t/mxcp-serve-secure-sql-based-llm-tools-from-your-dbt-duckdb-stack/19688)

<div class="topic-metadata">

**Author:** [@miguelbranco80](https://discourse.getdbt.com/u/miguelbranco80)\
**Replies:** 0\
**Last updated:** [June 20, 2025, 3:15pm UTC](https://discourse.getdbt.com/t/mxcp-serve-secure-sql-based-llm-tools-from-your-dbt-duckdb-stack/19688 "2025-06-20T15:15:13Z")

</div>

(First off, a big apology if this isn’t appropriate; I’m sharing/announcing below an open source tool we’ve built on top of dbt.) MXCP (Model eXecution Context Protocol) lets you expose governed, testable, MCP servers d…

---

## [How we sped up our CI runs by 10x using Slim CI](https://discourse.getdbt.com/t/how-we-sped-up-our-ci-runs-by-10x-using-slim-ci/2603)

<div class="topic-metadata">

**Author:** [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Replies:** 18\
**Last updated:** [June 18, 2025, 4:17am UTC](https://discourse.getdbt.com/t/how-we-sped-up-our-ci-runs-by-10x-using-slim-ci/2603 "2025-06-18T04:17:15Z")

</div>

Edit, October 2021: I wrote this before joining the dbt Labs team, while I was the Head of Data at Education Perfect. Please interpret “we” accordingly! The core of dbt’s value proposition is that analytics code is an a…

---

## [change schema in runtime](https://discourse.getdbt.com/t/change-schema-in-runtime/19612)

<div class="topic-metadata">

**Author:** [@bchaubey](https://discourse.getdbt.com/u/bchaubey)\
**Replies:** 0\
**Last updated:** [June 5, 2025, 6:41am UTC](https://discourse.getdbt.com/t/change-schema-in-runtime/19612 "2025-06-05T06:41:13Z")

</div>

Hi can change schema in runtime

---

## [Running project on selected environment using commands](https://discourse.getdbt.com/t/running-project-on-selected-environment-using-commands/19466)

<div class="topic-metadata">

**Author:** [@Kraysky](https://discourse.getdbt.com/u/Kraysky)\
**Replies:** 0\
**Last updated:** [May 21, 2025, 4:37pm UTC](https://discourse.getdbt.com/t/running-project-on-selected-environment-using-commands/19466 "2025-05-21T16:37:08Z")

</div>

Hi guys, I searched through the internet to find answer to my problem but could not find anything that would give me clear answer. I have a project on dbt cloud and four environments, including development env with sep…

---

## [Two Models with the same name in Different Schemas](https://discourse.getdbt.com/t/two-models-with-the-same-name-in-different-schemas/19406)

<div class="topic-metadata">

**Author:** [@rahulcloudeqs](https://discourse.getdbt.com/u/rahulcloudeqs)\
**Replies:** 0\
**Last updated:** [May 15, 2025, 5:22am UTC](https://discourse.getdbt.com/t/two-models-with-the-same-name-in-different-schemas/19406 "2025-05-15T05:22:58Z")

</div>

Hi all, While working on our dbt project, we encountered an issue related to model naming conflicts. We have two models named v\_booking\_line\_f, each located in a different schema (e.g., schema\_a.v\_booking\_line\_f and sc…

---

## [Birders community](https://discourse.getdbt.com/t/birders-community/19004)

<div class="topic-metadata">

**Author:** [@maud.tyboni](https://discourse.getdbt.com/u/maud.tyboni)\
**Replies:** 0\
**Last updated:** [April 11, 2025, 1:33pm UTC](https://discourse.getdbt.com/t/birders-community/19004 "2025-04-11T13:33:32Z")

</div>

Maud som fågelskådare

---

## [Can use dbt cloud github enterprise server?](https://discourse.getdbt.com/t/can-use-dbt-cloud-github-enterprise-server/18921)

<div class="topic-metadata">

**Author:** [@masashigemaedactc](https://discourse.getdbt.com/u/masashigemaedactc)\
**Replies:** 0\
**Last updated:** [April 4, 2025, 4:30am UTC](https://discourse.getdbt.com/t/can-use-dbt-cloud-github-enterprise-server/18921 "2025-04-04T04:30:45Z")

</div>

Can use dbt cloud github enterprise server?

---

## [Limiting dev runs with a dynamic date range](https://discourse.getdbt.com/t/limiting-dev-runs-with-a-dynamic-date-range/508)

<div class="topic-metadata">

**Author:** [@lewis](https://discourse.getdbt.com/u/lewis)\
**Replies:** 6\
**Last updated:** [March 8, 2025, 1:33pm UTC](https://discourse.getdbt.com/t/limiting-dev-runs-with-a-dynamic-date-range/508 "2025-03-08T13:33:01Z")

</div>

Hey folks, So far I’ve been limiting the date range on base model view files when doing dev runs as follows: {% if target.name == 'dev' %} where date(date) \>= date\_add(current\_date(), interval -3 day) {% endif %} Thi…

---

## [🚀 Introducing \`cte2dbt\`: effortlessly convert SQL CTE into dbt models](https://discourse.getdbt.com/t/introducing-cte2dbt-effortlessly-convert-sql-cte-into-dbt-models/18369)

<div class="topic-metadata">

**Author:** [@piotr-yuxuan](https://discourse.getdbt.com/u/piotr-yuxuan)\
**Replies:** 0\
**Last updated:** [February 22, 2025, 5:42pm UTC](https://discourse.getdbt.com/t/introducing-cte2dbt-effortlessly-convert-sql-cte-into-dbt-models/18369 "2025-02-22T17:42:37Z")

</div>

Hello everyone! :waving\_hand: I’m excited to share cte2dbt, a small yet powerful Python module designed to simplify the transition from large, monolithic SQL queries to modular, reusable dbt models. If you’ve ever str…

---

## [How to resolve "Subquery containing correlated aggregate function can only appear in having or select clause"](https://discourse.getdbt.com/t/how-to-resolve-subquery-containing-correlated-aggregate-function-can-only-appear-in-having-or-select-clause/5031)

<div class="topic-metadata">

**Author:** [@ron.chipman](https://discourse.getdbt.com/u/ron.chipman)\
**Replies:** 12\
**Last updated:** [February 21, 2025, 11:51pm UTC](https://discourse.getdbt.com/t/how-to-resolve-subquery-containing-correlated-aggregate-function-can-only-appear-in-having-or-select-clause/5031 "2025-02-21T23:51:37Z")

</div>

If you are just diving into doing incrementals using Snowflake as your DB of choice, here is a quick learning that I recently had (thank you @jerco for the assist). If you copy and paste the example code from the increm…

---

## [Using dbt to manage user defined functions](https://discourse.getdbt.com/t/using-dbt-to-manage-user-defined-functions/18)

<div class="topic-metadata">

**Author:** [@claire](https://discourse.getdbt.com/u/claire)\
**Replies:** 24\
**Last updated:** [February 9, 2025, 5:00pm UTC](https://discourse.getdbt.com/t/using-dbt-to-manage-user-defined-functions/18 "2025-02-09T17:00:31Z")

</div>

Note: This post uses Redshift SQL, however the same concept applies to most data warehouses. Check out the notes on BigQuery in the comments below. Our dbt project uses some user defined functions (UDFs). In the past, …

---

## [DBT model that contains both SQL and Python](https://discourse.getdbt.com/t/dbt-model-that-contains-both-sql-and-python/18028)

<div class="topic-metadata">

**Author:** [@karthikpotturi](https://discourse.getdbt.com/u/karthikpotturi)\
**Replies:** 0\
**Last updated:** [February 4, 2025, 7:29am UTC](https://discourse.getdbt.com/t/dbt-model-that-contains-both-sql-and-python/18028 "2025-02-04T07:29:09Z")

</div>

Hi, I am using dbt SQL models and deploy them to Snowflake as views. I am exploring the dbt Python models lately. Can we have a model where some of the parts or tables are taken using the with CTE(dbt SQL models style)…

---

## [Informatica mapping into dbt model creation](https://discourse.getdbt.com/t/informatica-mapping-into-dbt-model-creation/17970)

<div class="topic-metadata">

**Author:** [@rkancharla](https://discourse.getdbt.com/u/rkancharla)\
**Replies:** 0\
**Last updated:** [January 30, 2025, 12:04am UTC](https://discourse.getdbt.com/t/informatica-mapping-into-dbt-model-creation/17970 "2025-01-30T00:04:40Z")

</div>

How to convert Informatica power center mapping logic into dbt model. Looking for best practice technics in dbt.

---

## [Prevent user to run the whole project](https://discourse.getdbt.com/t/prevent-user-to-run-the-whole-project/9213)

<div class="topic-metadata">

**Author:** [@brunoszdl](https://discourse.getdbt.com/u/brunoszdl)\
**Replies:** 12\
**Last updated:** [December 13, 2024, 7:20pm UTC](https://discourse.getdbt.com/t/prevent-user-to-run-the-whole-project/9213 "2024-12-13T19:20:03Z")

</div>

Hi there! I was searching for a way to prevent the user to run the whole project accidentally. For example, for very large projects, if someone accidentally does a dbt run dbt can try to run thousands of models and it c…

---

## [Create empty table through dbt seed](https://discourse.getdbt.com/t/create-empty-table-through-dbt-seed/11667)

<div class="topic-metadata">

**Author:** [@ajsheth](https://discourse.getdbt.com/u/ajsheth)\
**Replies:** 7\
**Last updated:** [December 9, 2024, 11:29pm UTC](https://discourse.getdbt.com/t/create-empty-table-through-dbt-seed/11667 "2024-12-09T23:29:23Z")

</div>

I just found a trick in dbt to create empty tables and thought I would share with a wider audience and perhaps gather some feedback. I was working on a POC where I needed dbt to create an empty staging table just once. I…

---

## [Materialisation with multiple outputs](https://discourse.getdbt.com/t/materialisation-with-multiple-outputs/16764)

<div class="topic-metadata">

**Author:** [@clyde.watts267](https://discourse.getdbt.com/u/clyde.watts267)\
**Replies:** 0\
**Last updated:** [October 29, 2024, 5:35pm UTC](https://discourse.getdbt.com/t/materialisation-with-multiple-outputs/16764 "2024-10-29T17:35:48Z")

</div>

I have a “table” user defined function which generates a “primary” output table which is covered by the select projection columns , there are some additional tables generated . Is there a elegant way to do this.

---

## [Running dbt in Kubernetes](https://discourse.getdbt.com/t/running-dbt-in-kubernetes/92)

<div class="topic-metadata">

**Author:** [@davidgasquez](https://discourse.getdbt.com/u/davidgasquez)\
**Replies:** 1\
**Last updated:** [October 23, 2024, 2:37pm UTC](https://discourse.getdbt.com/t/running-dbt-in-kubernetes/92 "2024-10-23T14:37:08Z")

</div>

Hey there! We’ve been working with dbt and using Sinter for quite a while now. We felt that we needed a bit more control and decided to give a try to running and scheduling dbt in one of our Kubernetes clusters. In this …

---

## [Anyone modelled Dynamics365 Fianance and Operations data ?](https://discourse.getdbt.com/t/anyone-modelled-dynamics365-fianance-and-operations-data/16544)

<div class="topic-metadata">

**Author:** [@johny.prentice](https://discourse.getdbt.com/u/johny.prentice)\
**Replies:** 0\
**Last updated:** [October 10, 2024, 8:38pm UTC](https://discourse.getdbt.com/t/anyone-modelled-dynamics365-fianance-and-operations-data/16544 "2024-10-10T20:38:46Z")

</div>

Anyone modelled Dynamics365 Fianance and Operations data and have some models they are comfortable sharing?

---

## [Trigger a dbt Cloud job on merging to master branch](https://discourse.getdbt.com/t/trigger-a-dbt-cloud-job-on-merging-to-master-branch/1278)

<div class="topic-metadata">

**Author:** [@DAVOS](https://discourse.getdbt.com/u/DAVOS)\
**Replies:** 6\
**Last updated:** [October 7, 2024, 9:05pm UTC](https://discourse.getdbt.com/t/trigger-a-dbt-cloud-job-on-merging-to-master-branch/1278 "2024-10-07T21:05:42Z")

</div>

Background dbt Cloud is an excellent service and great value, providing an easy way to manage scheduled dbt jobs. As well as scheduling, it allows for Webhooks to be used so that a job can be triggered to run on a pull r…

---

## [Access \<model\_name\> from YAML file.](https://discourse.getdbt.com/t/access-model-name-from-yaml-file/16478)

<div class="topic-metadata">

**Author:** [@pranjalbhatt](https://discourse.getdbt.com/u/pranjalbhatt)\
**Replies:** 0\
**Last updated:** [October 7, 2024, 8:56pm UTC](https://discourse.getdbt.com/t/access-model-name-from-yaml-file/16478 "2024-10-07T20:56:16Z")

</div>

Hi, I am interested in getting {{ model.name }}. My yaml file looks like this - models: - name: dim\_service\_account columns: - name: ACCOUNT\_NUMBER - name: ACCOUNT\_NAME {{ model.name }} does not return d…

---

## [Suggestion for dbt glue - improvement](https://discourse.getdbt.com/t/suggestion-for-dbt-glue-improvement/15221)

<div class="topic-metadata">

**Author:** [@gabrielsantosvi97](https://discourse.getdbt.com/u/gabrielsantosvi97)\
**Replies:** 0\
**Last updated:** [August 30, 2024, 8:02pm UTC](https://discourse.getdbt.com/t/suggestion-for-dbt-glue-improvement/15221 "2024-08-30T20:02:14Z")

</div>

Hello, I’m developing in dbt using glue and iceberg. However, I’ve noticed that when there’s an error in some part of the code and it creates the table with the prefix tmp\_. The next time I run it, I always get an erro…

---

## [Running DBT in Github actions](https://discourse.getdbt.com/t/running-dbt-in-github-actions/13917)

<div class="topic-metadata">

**Author:** [@CedricLeong](https://discourse.getdbt.com/u/CedricLeong)\
**Replies:** 0\
**Last updated:** [June 21, 2024, 7:57pm UTC](https://discourse.getdbt.com/t/running-dbt-in-github-actions/13917 "2024-06-21T19:57:32Z")

</div>

What is dbt-action-nix? dbt-action-nix is a GitHub Action that simplifies the setup and execution of dbt in your CI/CD workflows. It leverages Nix, a powerful package manager and build system, to create reproducible and …

---

## [A partial workaround for dbt\_utils.star not working with CTEs](https://discourse.getdbt.com/t/a-partial-workaround-for-dbt-utils-star-not-working-with-ctes/1369)

<div class="topic-metadata">

**Author:** [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Replies:** 0\
**Last updated:** [July 6, 2020, 10:13pm UTC](https://discourse.getdbt.com/t/a-partial-workaround-for-dbt-utils-star-not-working-with-ctes/1369 "2020-07-06T22:13:44Z")

</div>

Since dbt\_utils.star doesn’t work on CTEs, I’ve made a wee macro which solves my most common need: pulling all but a couple of columns out of a CTE in the same model file. To use it, you need to set the columns in your s…

---

## [materialization error](https://discourse.getdbt.com/t/materialization-error/13138)

<div class="topic-metadata">

**Author:** [@dgupta](https://discourse.getdbt.com/u/dgupta)\
**Replies:** 2\
**Last updated:** [May 22, 2024, 1:28am UTC](https://discourse.getdbt.com/t/materialization-error/13138 "2024-05-22T01:28:07Z")

</div>

Hello, I am new to dbt. created 2 models. 1 .sql and 1 .py. use ref in .py model to reference .sql model. I get the below error when I execute. Please help resolve the issue: Runtime Error in model execute\_sql (mode…

---

## [Problem using python and sql (postgres) models ](https://discourse.getdbt.com/t/problem-using-python-and-sql-postgres-models/13233)

<div class="topic-metadata">

**Author:** [@Remi27](https://discourse.getdbt.com/u/Remi27)\
**Replies:** 1\
**Last updated:** [May 17, 2024, 5:04pm UTC](https://discourse.getdbt.com/t/problem-using-python-and-sql-postgres-models/13233 "2024-05-17T17:04:54Z")

</div>

Good morning, I use a postgres adapter in my dbt project, I also want to use python models but I have this error: 09:53:37 Completed with 1 error and 0 warnings: 09:53:37 09:53:37 Runtime Error in model test (mode…

---

## [Running dbt in Composer using a KubernetesPodOperator](https://discourse.getdbt.com/t/running-dbt-in-composer-using-a-kubernetespodoperator/2590)

<div class="topic-metadata">

**Author:** [@meurant.naude](https://discourse.getdbt.com/u/meurant.naude)\
**Replies:** 7\
**Last updated:** [April 30, 2024, 8:27pm UTC](https://discourse.getdbt.com/t/running-dbt-in-composer-using-a-kubernetespodoperator/2590 "2024-04-30T20:27:54Z")

</div>

Quick disclaimer: We use GCP and the solution is based on GCP only We’ve been using dbt for a while now and have had a few deployment choices. I’d like to explain how we went about getting the Airflow using a Kubernetes…

---

## [snowflake incremental models with virtual columns failures](https://discourse.getdbt.com/t/snowflake-incremental-models-with-virtual-columns-failures/11470)

<div class="topic-metadata">

**Author:** [@nadelman](https://discourse.getdbt.com/u/nadelman)\
**Replies:** 5\
**Last updated:** [April 28, 2024, 1:09pm UTC](https://discourse.getdbt.com/t/snowflake-incremental-models-with-virtual-columns-failures/11470 "2024-04-28T13:09:12Z")

</div>

I was recently working on converting a table managed outside of dbt to our dbt project. It is an incremental model, and the table in question contains a couple of virtual fields. While testing my dbt incremental model im…

---

## [Connect dbt core to databricks using backed scope or Azure keyvault](https://discourse.getdbt.com/t/connect-dbt-core-to-databricks-using-backed-scope-or-azure-keyvault/13043)

<div class="topic-metadata">

**Author:** [@adubey](https://discourse.getdbt.com/u/adubey)\
**Replies:** 0\
**Last updated:** [April 24, 2024, 11:02am UTC](https://discourse.getdbt.com/t/connect-dbt-core-to-databricks-using-backed-scope-or-azure-keyvault/13043 "2024-04-24T11:02:59Z")

</div>

I’m currently linking dbt core to Databricks by employing an access token in the profile.yml . Is there a method available to transmit Databricks-backed scope or key vault instead of an access token to establish a connec…

---

## [Casting column datatypes based on a seed](https://discourse.getdbt.com/t/casting-column-datatypes-based-on-a-seed/4877)

<div class="topic-metadata">

**Author:** [@leogodin](https://discourse.getdbt.com/u/leogodin)\
**Replies:** 1\
**Last updated:** [April 11, 2024, 7:01pm UTC](https://discourse.getdbt.com/t/casting-column-datatypes-based-on-a-seed/4877 "2024-04-11T19:01:58Z")

</div>

Old thread, I know, but I ran into this recently. We have a simple data dictionary that lists source column name, target column name and data type. At the same time, we are pivoting key/value pairs to a wide format. To …

---

## [Implement unit testing on my models](https://discourse.getdbt.com/t/implement-unit-testing-on-my-models/12828)

<div class="topic-metadata">

**Author:** [@yev.l217](https://discourse.getdbt.com/u/yev.l217)\
**Replies:** 0\
**Last updated:** [April 10, 2024, 11:01am UTC](https://discourse.getdbt.com/t/implement-unit-testing-on-my-models/12828 "2024-04-10T11:01:23Z")

</div>

Hi, I am trying to set up unit testing for my models, I have source data in PG, and my base model selects raw data by a certain date(configured in vars), then I have an intermediate and a final model on top of it. I wa…

[Previous page](https://discourse.getdbt.com/c/show-and-tell/22.md)

[Next page](https://discourse.getdbt.com/c/show-and-tell/22.md?page=2)