Skip to main content

Warehouse

The Snowflake warehouse name to use.

The value is passed into the generated packages and pipelines as the SnowflakeWarehouse variable or parameter, supplied to the Snowflake SQL tasks that execute the generated statements, and referenced by the ALTER WAREHOUSE statements generated for warehouse scaling and suspension at the batch boundaries.

When to Change This Setting

Set this to the virtual warehouse the generated loads should run on. Use a Settings override at the project scope to run different projects on different warehouses.

SettingInteraction
Scale UpResizes this warehouse at the start of a batch
Scale DownResizes this warehouse at the end of a batch
Auto SuspendSuspends this warehouse at the end of a batch

Notes

  • This setting is part of the Snowflake settings category.