Skip to main content

Auto Suspend

Determines whether BimlFlex suspends the Snowflake warehouse at the end of each batch pipeline. When set to Y, BimlFlex generates ALTER WAREHOUSE ... SUSPEND as the final activity after all loads and any scale-down operations complete, preventing unnecessary credit consumption during idle periods between batch runs. Set this to N if your warehouse serves concurrent workloads outside of BimlFlex batches and should remain running after the batch completes.

Notes:

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is Y.
  • The suspend activity executes after the scale-down step when both SnowflakeScaleDown and SnowflakeAutoSuspend are enabled.