Only run a set of models?
I started to migrate some of your transformations jobs to DBT. As you can see on the image bellow, there is usually 1 to 2 transformations before to have our final table (up to 5 transformations in some cases).
What I am trying to achieve is to do dbt run only for a set on linked model. For instance, sales_prediction and forecast. I am currently able to run either for everything with dbt run or just speficif model using dbt run --select model_name
Solution
Dbt allows syntax of
- selecting a node and all nodes it requires (
+before the model name) - selecting a node and all nodes that depend on it (
+after the model name) - you can also do both (
+model_name+)
In your case dbt run --select +forecast should do the trick
Also check the documentation of the + operator.
- handle dbt variables while using sqlfluff
- Dbt docs generate is not working with an odd error
- Only run a set of models?
- How can I create a custom dbt materialization for sequences in Snowflake?
- Select unique records in SQL union based on latest updated time value
- Unable to upgrade dbt version to 1.10
- Configure SQLFluff rules
- How can I stop dbt inserting an invalid character into a table creation script?
- Why do I get a 'select active warehouse' error in dbt when trying the table materialization, but not with the view materialization?
- is there a way to create an incremental model without duplicates
- CalledProcessError when running dbt in Databricks
- how to use dbt for data lakehouse when using Python or Spark for transformations
- How to run DBT model and pass a variable at run time
- How to implement dbt.this in Incremental Python Models when BigQuery project id contains hyphens
- How to add a Jinja function to .sqlfluff config
- How to do dbt_tests on timestamp data type?
- dbt macros not compiling parameters
- DBT CLI Selector – Run tests for a specific column on a specific model
- Specify target in dbt model based on the folder location
- Pandas in python dbt model duckdb
- DBT(Data Build Tools) - drop the default database prefix that gets added to each model on deployment
- With dbt. How do I use a jinja macro in a yaml file
- How to deploy SQL views to snowflake using config object?
- How to list (and count) all the models?
- Overriding dbt snapshot table generation
- How do I run SQL model in dbt multiple times by looping through variables?
- dbt keeps returning database error for invalid field even after removing the field
- How to run dbt unit tests with csv files as input and output
- Validate specific date format in dbt
- Can we have intellisense on dbt's yml?