Skip to main content

Remove Stage

Determines if the Snowflake internal stage is removed after the load completes.

Each generated load creates its stage with CREATE OR REPLACE STAGE, uploads the landing files, and calls the load procedure. When this setting is enabled, a final DROP STAGE IF EXISTS task removes the stage after the load procedure completes.

When to Change This Setting​

Keep the default Y to clean up the per-object stages and their uploaded files after each load. Disable it to keep the stage and its files available after the load, for example for troubleshooting; the next load replaces the stage in either case.

SettingInteraction
File FormatThe file format created for the stage

Notes​

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is Y.