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 ?

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:

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},
        )
    },
)

Thanks Nicolas