PolyBase Settings
The default Azure PolyBase settings to use when using the Copy Method PolyBase and enabling Staging for the Copy Activity.
For Azure Synapse sinks, the value is emitted as the <PolyBaseSettings ... /> node on the Copy Activity when Copy Method is PolyBase. When the setting is blank, a built-in default of RejectType="Value" RejectValue="0" UseTypeDefault="true" is used.
When to Change This Setting
Keep the default to fail the load on the first rejected row. Raise RejectValue (or switch RejectType to a percentage) when a load should tolerate a bounded number of unconvertible rows.
Related Settings
| Setting | Interaction |
|---|---|
| Copy Method | Must be PolyBase for these settings to be emitted |
| Enable Staging | Stages the data for the PolyBase load |
Notes
- This setting is part of the Azure Copy settings category.
- The default value for this setting is
RejectType="Value" RejectValue="0" UseTypeDefault="true".