Copy Options
Customize COPY_OPTIONS for the COPY INTO operation. The default is COPY_OPTIONS ('mergeSchema' = 'true').
When Use Copy Into is enabled, the generated COPY INTO command ends with a COPY_OPTIONS clause; when this setting is blank, COPY_OPTIONS ('mergeSchema' = 'true') is used. A value in this setting replaces the whole clause verbatim, so it must be a complete COPY_OPTIONS (...) expression.
When to Change This Setting
Leave it blank for the schema-merging default. Set it when the ingestion needs different copy options — for example additional Databricks COPY INTO copy options alongside or instead of mergeSchema.
Related Settings
| Setting | Interaction |
|---|---|
| Use Copy Into | Enables the COPY INTO load pattern these options apply to |
| Copy Format Options | The companion override for the FORMAT_OPTIONS clause |
Notes
- This setting is part of the Databricks settings category.
- This setting is blank by default;
COPY_OPTIONS ('mergeSchema' = 'true')then applies.