Skip to main content

Enable Staging

Determines if the Azure Data Factory Copy Activity uses Staging. Use this together with Copy Method PolyBase to load data to PolyBase supported targets.

When enabled, the generated Copy Activity sets EnableStaging and includes the Staging Settings. Validation PRJ_22005004 requires the project to have a PolyBase Landing connection (Azure Blob Storage or Data Lake Storage) when staging is enabled and the staging settings use the @@this placeholder.

When to Change This Setting​

Enable this together with Copy Method PolyBase when loading Azure Synapse, so the Copy Activity stages the data in blob storage before the PolyBase load.

SettingInteraction
Staging SettingsThe staging configuration emitted when staging is enabled
Copy MethodPolyBase is the copy method staging is designed to support
PolyBase SettingsThe PolyBase configuration applied on the Synapse sink

Notes​

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