# \#modeling

**URL:** https://discourse.getdbt.com/tag/modeling/87.md

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

---

## [Anyone out there with a similar tech stack? SQL server/SQL agent jobs -\> Snowflake/dbt with IBM as400 source](https://discourse.getdbt.com/t/anyone-out-there-with-a-similar-tech-stack-sql-server-sql-agent-jobs-snowflake-dbt-with-ibm-as400-source/21010)

<div class="topic-metadata">

**Author:** [@thomas.starr](https://discourse.getdbt.com/u/thomas.starr)\
**Replies:** 1\
**Last updated:** [October 8, 2026, 5:12pm UTC](https://discourse.getdbt.com/t/anyone-out-there-with-a-similar-tech-stack-sql-server-sql-agent-jobs-snowflake-dbt-with-ibm-as400-source/21010 "2026-10-08T17:12:46Z")

</div>

Greetings dbt community! My company has started the migration journey from legacy stack IBM as400 source system with sql server and sql agent jobs as the data warehouse and ETL tool, to the new landscape of dbt and Snowf…

---

## [How to populate Catalog Modeling layer?](https://discourse.getdbt.com/t/how-to-populate-catalog-modeling-layer/19728)

<div class="topic-metadata">

**Author:** [@jackiesbauer](https://discourse.getdbt.com/u/jackiesbauer)\
**Replies:** 1\
**Last updated:** [December 24, 2025, 3:40pm UTC](https://discourse.getdbt.com/t/how-to-populate-catalog-modeling-layer/19728 "2025-12-24T15:40:48Z")

</div>

In dbt Cloud in Catalog, under Model we see table listing all our models. There is a column named Modeling layer but it is not populated. How can I get this populated? We have Generate docs on run checkmarked for our dai…

---

## [Preview problem in dbt cloud.](https://discourse.getdbt.com/t/preview-problem-in-dbt-cloud/8980)

<div class="topic-metadata">

**Author:** [@sivareddy3244](https://discourse.getdbt.com/u/sivareddy3244)\
**Replies:** 1\
**Last updated:** [November 25, 2025, 1:17pm UTC](https://discourse.getdbt.com/t/preview-problem-in-dbt-cloud/8980 "2025-11-25T13:17:29Z")

</div>

The problem I’m having is with the Preview problem as it does not display any error message when the sql file has error in it. Normally it should have a error message but it does not show form the past few days. Some…

---

## [Inserting data into Table A with sequential transformations in dbt](https://discourse.getdbt.com/t/inserting-data-into-table-a-with-sequential-transformations-in-dbt/9376)

<div class="topic-metadata">

**Author:** [@Ajinkya](https://discourse.getdbt.com/u/Ajinkya)\
**Replies:** 3\
**Last updated:** [January 30, 2025, 11:59am UTC](https://discourse.getdbt.com/t/inserting-data-into-table-a-with-sequential-transformations-in-dbt/9376 "2025-01-30T11:59:31Z")

</div>

Hi all, I’m facing a unique challenge with data insertion and transformation using dbt. Here’s the situation: Step 1: I have raw data that requires some transformations, and the result needs to be inserted into Table A…

---

## [Datavault stage model using datavault4dbt](https://discourse.getdbt.com/t/datavault-stage-model-using-datavault4dbt/13436)

<div class="topic-metadata">

**Author:** [@hemanathgoud](https://discourse.getdbt.com/u/hemanathgoud)\
**Replies:** 0\
**Last updated:** [May 18, 2024, 10:25am UTC](https://discourse.getdbt.com/t/datavault-stage-model-using-datavault4dbt/13436 "2024-05-18T10:25:15Z")

</div>

Hi All, I am new to using data vault design using the automate\_Dv and datavault4dbt packages. I can able to create the data vault tables using the automate\_dv package. while trying to create the data vault tables using…

---

## [Modeling existing multistep ETL process](https://discourse.getdbt.com/t/modeling-existing-multistep-etl-process/11926)

<div class="topic-metadata">

**Author:** [@ajn47041](https://discourse.getdbt.com/u/ajn47041)\
**Replies:** 0\
**Last updated:** [February 6, 2024, 5:06pm UTC](https://discourse.getdbt.com/t/modeling-existing-multistep-etl-process/11926 "2024-02-06T17:06:09Z")

</div>

The problem I’m having I am new to dbt and I am trying to understand how I would best take an existing process, which is just a bunch of SQL usps, and put it into a dbt model format. I understand the core concepts of dbt…

---

## [Unable to run the example model when I connect to oracle DB. I am getting the below error.](https://discourse.getdbt.com/t/unable-to-run-the-example-model-when-i-connect-to-oracle-db-i-am-getting-the-below-error/8674)

<div class="topic-metadata">

**Author:** [@Mala](https://discourse.getdbt.com/u/Mala)\
**Replies:** 3\
**Last updated:** [June 15, 2023, 5:34am UTC](https://discourse.getdbt.com/t/unable-to-run-the-example-model-when-i-connect-to-oracle-db-i-am-getting-the-below-error/8674 "2023-06-15T05:34:34Z")

</div>

Unable to run the example model when I connect to oracle DB. I am getting the below error. I am able to connect to the DB without any problem when I run dbt debug. I have made sure all the details in the model is correct …

---

## [How to dynamically skip a model run](https://discourse.getdbt.com/t/how-to-dynamically-skip-a-model-run/7968)

<div class="topic-metadata">

**Author:** [@Process](https://discourse.getdbt.com/u/Process)\
**Replies:** 3\
**Last updated:** [April 24, 2023, 2:06am UTC](https://discourse.getdbt.com/t/how-to-dynamically-skip-a-model-run/7968 "2023-04-24T02:06:33Z")

</div>

I have many models and materialization=Table. Before the model runs, I want to check the source and the model table. If they have the same max(some\_col), then I want to skip the model run and keep the model table as is. …

---

## [Is it ok to join marts tables ?](https://discourse.getdbt.com/t/is-it-ok-to-join-marts-tables/7345)

<div class="topic-metadata">

**Author:** [@greenglass](https://discourse.getdbt.com/u/greenglass)\
**Replies:** 1\
**Last updated:** [March 16, 2023, 2:33pm UTC](https://discourse.getdbt.com/t/is-it-ok-to-join-marts-tables/7345 "2023-03-16T14:33:45Z")

</div>

Let’s suppose I have on my marts layer the following tables: dim\_customers dim\_accounts fct\_transactions I want to create a report that joins all these tables. Therefore my query will contain the 3 tables. BUT I do n…

---

## [Syntax error in models on Lines that don't exist](https://discourse.getdbt.com/t/syntax-error-in-models-on-lines-that-dont-exist/6452)

<div class="topic-metadata">

**Author:** [@pfan](https://discourse.getdbt.com/u/pfan)\
**Replies:** 0\
**Last updated:** [January 30, 2023, 9:21pm UTC](https://discourse.getdbt.com/t/syntax-error-in-models-on-lines-that-dont-exist/6452 "2023-01-30T21:21:32Z")

</div>

---

## [Multiple Case Statements Wildcard matches](https://discourse.getdbt.com/t/multiple-case-statements-wildcard-matches/5436)

<div class="topic-metadata">

**Author:** [@derrickt](https://discourse.getdbt.com/u/derrickt)\
**Replies:** 2\
**Last updated:** [December 1, 2022, 2:13am UTC](https://discourse.getdbt.com/t/multiple-case-statements-wildcard-matches/5436 "2022-12-01T02:13:44Z")

</div>

Hello! I’m trying to create a set something similar to the following {%- set payment\_methods = \['bank\_transfer', 'credit\_card', 'coupon', 'gift\_card'\] -%} with payments as ( select \* from {{ ref('stg\_payments') }} …