# \#environments

**URL:** https://discourse.getdbt.com/tag/environments/29.md

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

---

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

---

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

---

## [DBT Cloud dev, stg, prod configurations](https://discourse.getdbt.com/t/dbt-cloud-dev-stg-prod-configurations/16786)

<div class="topic-metadata">

**Author:** [@ethomas](https://discourse.getdbt.com/u/ethomas)\
**Replies:** 0\
**Last updated:** [October 30, 2024, 6:48pm UTC](https://discourse.getdbt.com/t/dbt-cloud-dev-stg-prod-configurations/16786 "2024-10-30T18:48:14Z")

</div>

Currently my company uses two bigquery projects, one dev and one prod and our dbt dev work is done in dev and pushed through to prod with PRs. We are now going to have 3 projects: dev, staging, and prod. where staging wi…

---

## [Using dynamic schemas for snapshots](https://discourse.getdbt.com/t/using-dynamic-schemas-for-snapshots/1070)

<div class="topic-metadata">

**Author:** [@claire](https://discourse.getdbt.com/u/claire)\
**Replies:** 10\
**Last updated:** [March 27, 2024, 1:19pm UTC](https://discourse.getdbt.com/t/using-dynamic-schemas-for-snapshots/1070 "2024-03-27T13:19:34Z")

</div>

Unlike models, snapshots build into the same target\_schema, no matter who is running them. This helps ensure that whenever you ref a snapshot, you’re using the production version of the snapshot, so that your dev transf…

---

## [Dbt dev/prod data pipelines](https://discourse.getdbt.com/t/dbt-dev-prod-data-pipelines/4812)

<div class="topic-metadata">

**Author:** [@lawwu](https://discourse.getdbt.com/u/lawwu)\
**Replies:** 8\
**Last updated:** [January 16, 2024, 12:35am UTC](https://discourse.getdbt.com/t/dbt-dev-prod-data-pipelines/4812 "2024-01-16T00:35:01Z")

</div>

Hello, First time adopter of dbt in the last couple months. I had a question around best practices in handling dbt runs for dev and prod. I’d like to: Have a daily job that runs dbt run to target a dev schema Run dbt …

---

## [Connecting Multiple Databases in Dbt Cloud](https://discourse.getdbt.com/t/connecting-multiple-databases-in-dbt-cloud/10137)

<div class="topic-metadata">

**Author:** [@Nili099](https://discourse.getdbt.com/u/Nili099)\
**Replies:** 0\
**Last updated:** [September 28, 2023, 1:40pm UTC](https://discourse.getdbt.com/t/connecting-multiple-databases-in-dbt-cloud/10137 "2023-09-28T13:40:54Z")

</div>

Hello dbt community, I’m new to dbt and currently have a project connected with PostgreSQL in my development database. My question is whether it’s possible to connect multiple databases in dbt Cloud to accommodate diff…

---

## [Runtime Error when running dbt build in deployment environment (Databricks)](https://discourse.getdbt.com/t/runtime-error-when-running-dbt-build-in-deployment-environment-databricks/6926)

<div class="topic-metadata">

**Author:** [@npschafer](https://discourse.getdbt.com/u/npschafer)\
**Replies:** 1\
**Last updated:** [August 16, 2023, 12:58am UTC](https://discourse.getdbt.com/t/runtime-error-when-running-dbt-build-in-deployment-environment-databricks/6926 "2023-08-16T00:58:14Z")

</div>

The problem I’m having Runtime Error Runtime Error Catalog 'npschafer@constantiambio.com' plugin class not found: spark.sql.catalog.npschafer@constantiambio.com is not defined The context of why I’m trying to do t…

---

## [Get System Information as a Pre or Post-Hook](https://discourse.getdbt.com/t/get-system-information-as-a-pre-or-post-hook/9191)

<div class="topic-metadata">

**Author:** [@jonogan](https://discourse.getdbt.com/u/jonogan)\
**Replies:** 0\
**Last updated:** [July 18, 2023, 3:36pm UTC](https://discourse.getdbt.com/t/get-system-information-as-a-pre-or-post-hook/9191 "2023-07-18T15:36:11Z")

</div>

I need to be able to leverage information about the machine that dbt is running on within my dbt project. This is primarily to aid in troubleshooting and providing environment status to developers and users. We have dbt …

---

## [Multiple build/deploys and CI; searching for best practice](https://discourse.getdbt.com/t/multiple-build-deploys-and-ci-searching-for-best-practice/6900)

<div class="topic-metadata">

**Author:** [@niklashjortingwersen](https://discourse.getdbt.com/u/niklashjortingwersen)\
**Replies:** 0\
**Last updated:** [February 21, 2023, 1:16pm UTC](https://discourse.getdbt.com/t/multiple-build-deploys-and-ci-searching-for-best-practice/6900 "2023-02-21T13:16:18Z")

</div>

Hi there I’ve searched through documentation, this forum and Google(lol), but haven’t really found the answer. Hope that someone can help here. Context We are having 3 models, and they are all deployed by the same job…

---

## [dbt cloud multiple execution projects](https://discourse.getdbt.com/t/dbt-cloud-multiple-execution-projects/6739)

<div class="topic-metadata">

**Author:** [@Khalid](https://discourse.getdbt.com/u/Khalid)\
**Replies:** 0\
**Last updated:** [February 9, 2023, 1:28pm UTC](https://discourse.getdbt.com/t/dbt-cloud-multiple-execution-projects/6739 "2023-02-09T13:28:39Z")

</div>

I’m using dbt cloud, trying out the single developer version. My DW is BQ. I wish to add a deployment environment which would be a different project and dataset to that of my development environment. I can work around …

---

## [Snapshots are not being built in a CI schema during SlimCI -- PRODUCTION affected during CI run!](https://discourse.getdbt.com/t/snapshots-are-not-being-built-in-a-ci-schema-during-slimci-production-affected-during-ci-run/6536)

<div class="topic-metadata">

**Author:** [@gnilrets](https://discourse.getdbt.com/u/gnilrets)\
**Replies:** 9\
**Last updated:** [February 7, 2023, 5:03pm UTC](https://discourse.getdbt.com/t/snapshots-are-not-being-built-in-a-ci-schema-during-slimci-production-affected-during-ci-run/6536 "2023-02-07T17:03:32Z")

</div>

I have snapshots that are built a separate Snowflake database, which is defined by an environment variable. {% snapshot snap\_qb\_etahub\_\_assemblies %} {{ config( tags=\['snowflake-only'\], ta…

---

## [How to run jobs in the background with on CI/CD.](https://discourse.getdbt.com/t/how-to-run-jobs-in-the-background-with-on-ci-cd/6324)

<div class="topic-metadata">

**Author:** [@espy](https://discourse.getdbt.com/u/espy)\
**Replies:** 1\
**Last updated:** [January 24, 2023, 6:59pm UTC](https://discourse.getdbt.com/t/how-to-run-jobs-in-the-background-with-on-ci-cd/6324 "2023-01-24T18:59:46Z")

</div>

The problem I’m having I am new to dbt and working with our data team. We have built our models and we are thinking about how to deploy them to our dev and production warehouse which is running on Snowflake. We are curr…

---

## [Best practice for dev environment in a project writing to multiple databases](https://discourse.getdbt.com/t/best-practice-for-dev-environment-in-a-project-writing-to-multiple-databases/6308)

<div class="topic-metadata">

**Author:** [@ptrn](https://discourse.getdbt.com/u/ptrn)\
**Replies:** 0\
**Last updated:** [January 23, 2023, 11:14pm UTC](https://discourse.getdbt.com/t/best-practice-for-dev-environment-in-a-project-writing-to-multiple-databases/6308 "2023-01-23T23:14:08Z")

</div>

I’m following How do I maintain different environments with dbt? In our Snowflake instance, we use dbt to write to multiple databases. Let’s say I have: ANALYTICS\_DB (production) marketing finance ANALYTICS\_DEV\_DB …

---

## [Scheduling DBT pipelines using two mandatory tags](https://discourse.getdbt.com/t/scheduling-dbt-pipelines-using-two-mandatory-tags/5743)

<div class="topic-metadata">

**Author:** [@And123](https://discourse.getdbt.com/u/And123)\
**Replies:** 3\
**Last updated:** [January 10, 2023, 1:02am UTC](https://discourse.getdbt.com/t/scheduling-dbt-pipelines-using-two-mandatory-tags/5743 "2023-01-10T01:02:17Z")

</div>

I’m trying to find a solution for scheduling and tagging my models. I have two tags e.g. environment and schedule, where environment can take values like staging/production, while schedule can take values like daily/week…

---

## [Waiting Time tab appeared in model-timing-tab for long running spikes](https://discourse.getdbt.com/t/waiting-time-tab-appeared-in-model-timing-tab-for-long-running-spikes/5148)

<div class="topic-metadata">

**Author:** [@obar1](https://discourse.getdbt.com/u/obar1)\
**Replies:** 2\
**Last updated:** [October 27, 2022, 6:08pm UTC](https://discourse.getdbt.com/t/waiting-time-tab-appeared-in-model-timing-tab-for-long-running-spikes/5148 "2022-10-27T18:08:09Z")

</div>

Hello, I am using RedShift usually is timing tab looks like today I saw I see not much details in any idea/experience - what should I look for in the logs? that might be already helpful

---

## [How do I temporarily make an archive copy of a schema?](https://discourse.getdbt.com/t/how-do-i-temporarily-make-an-archive-copy-of-a-schema/5051)

<div class="topic-metadata">

**Author:** [@ff9991](https://discourse.getdbt.com/u/ff9991)\
**Replies:** 1\
**Last updated:** [October 13, 2022, 8:27am UTC](https://discourse.getdbt.com/t/how-do-i-temporarily-make-an-archive-copy-of-a-schema/5051 "2022-10-13T08:27:08Z")

</div>

Thanks @joellabes . For what concerns option 1: what is your suggested approach to temporarily archive a schema we’d like to keep for disaster recovery as we test for Blue / Green Deployment? I couldn’t find a post spe…

---

## [Using Grants in a target-specific way](https://discourse.getdbt.com/t/using-grants-in-a-target-specific-way/4981)

<div class="topic-metadata">

**Author:** [@minhajpasha](https://discourse.getdbt.com/u/minhajpasha)\
**Replies:** 7\
**Last updated:** [October 4, 2022, 11:17pm UTC](https://discourse.getdbt.com/t/using-grants-in-a-target-specific-way/4981 "2022-10-04T23:17:14Z")

</div>

Hello , Dbt version :1.2 We have 3 git branches develop - pointing to GCP dev project uat - pointing to GCP uat project prod - pointing to GCP prod project. If we use the Grant in models/schema.yml file as below , …

---

## [Looker user attributes and \`if dev\` to auto-switch between dev & prod schemas](https://discourse.getdbt.com/t/looker-user-attributes-and-if-dev-to-auto-switch-between-dev-prod-schemas/54)

<div class="topic-metadata">

**Author:** [@michael.dunn](https://discourse.getdbt.com/u/michael.dunn)\
**Replies:** 11\
**Last updated:** [November 8, 2020, 10:52am UTC](https://discourse.getdbt.com/t/looker-user-attributes-and-if-dev-to-auto-switch-between-dev-prod-schemas/54 "2020-11-08T10:52:22Z")

</div>

At RealSelf, people developing in DBT default to having their models built in user-specific sandbox schemas. My sandbox schemas are dbt\_md\_base for raw or lightly cleansed data, dbt\_md\_work for interstitial models, and d…

---

## [Custom Versions of generate\_schema\_name](https://discourse.getdbt.com/t/custom-versions-of-generate-schema-name/1591)

<div class="topic-metadata">

**Author:** [@josh](https://discourse.getdbt.com/u/josh)\
**Replies:** 0\
**Last updated:** [September 8, 2020, 8:44pm UTC](https://discourse.getdbt.com/t/custom-versions-of-generate-schema-name/1591 "2020-09-08T20:44:31Z")

</div>

Hello all dbt-ers! There has been a lot of discussion in various places about how folks set up their dbt environments, databases, schemas/datasets, etc. I would like to share here the specific changes we have made to ge…

---

## [FAQ: Configuring models' materializations based on environments](https://discourse.getdbt.com/t/faq-configuring-models-materializations-based-on-environments/463)

<div class="topic-metadata">

**Author:** [@claire](https://discourse.getdbt.com/u/claire)\
**Replies:** 0\
**Last updated:** [July 17, 2019, 6:14pm UTC](https://discourse.getdbt.com/t/faq-configuring-models-materializations-based-on-environments/463 "2019-07-17T18:14:25Z")

</div>

We’ve had a couple of questions recently about configuring models based on your environment (or target) over on Slack, spefically around: Using views in dev and tables in prod \[Snowflake only\] Using transient tables …

---

## [Questions/Thoughts on Staging versus Analytics Areas in Warehouse](https://discourse.getdbt.com/t/questions-thoughts-on-staging-versus-analytics-areas-in-warehouse/234)

<div class="topic-metadata">

**Author:** [@josh](https://discourse.getdbt.com/u/josh)\
**Replies:** 3\
**Last updated:** [February 11, 2019, 7:25pm UTC](https://discourse.getdbt.com/t/questions-thoughts-on-staging-versus-analytics-areas-in-warehouse/234 "2019-02-11T19:25:22Z")

</div>

Hello All - Question how everyone handles their schema management for staging data versus transformations done on staging data. It’s a good rule of thumb to not let users access the staging data, because as you build a…