Skip to main content

Create External On Stage

Should the Staging process DROP and CREATE EXTERNAL TABLE before running the Staging Stored Procedure.

For Data Factory solutions this applies when the source has a Landing connection and the target is SQL Server, Azure SQL Database, or Azure Synapse: the process pipeline adds an activity that recreates the external table over the staged files before the staging stored procedure runs.

When to Change This Setting​

Enable this for external-table (PolyBase) staging patterns where the external table definition must be refreshed to match the staged files on every load.

SettingInteraction
External File FormatThe WITH clause used for generated external table definitions
Create Dummy FileEnsures the external table location always contains a file
Stage On ExtractControls whether the stage process runs as part of the extract

Notes​

  • This setting is part of the Azure settings category.
  • The default value for this setting is N.