https://dagster.io/ logo
#integration-dbt
Title
# integration-dbt
b

Binoy Shah

02/02/2023, 9:16 PM
Hi is it possible to override the Snowflake Warehouse name for each workflow/pipeline run. We have multiple wareouses, which are tracked/managed separately and have different credit limits. We’d like to have each workflow use its own dedicated warehouse instead of a global one. does Dagster-Dbt apis allow switching warehouse for such scenarios ?
n

Nicolas Parot Alvarez

02/03/2023, 10:34 AM
I think you could define a different DBT target for each DWH in your DBT
profiles.yml
. Then you can configure different Dagster resources for each DBT target using the dagster-dbt configuration method:
Copy code
dbt_assets = with_resources(
    load_assets_from_dbt_project(DBT_PROJECT_PATH),
    {
        "dbt": dbt_cli_resource.configured(
            {'profiles_dir': pathToDir, 'project_dir': pathToproject, 'target': yourPreferredTarget},
        )
    },
)
🌈 1
b

Binoy Shah

02/06/2023, 2:53 PM
Thanks Nicolas
5 Views