Use this tab to configure information about the file to copy into the output table. The input file must exist in either a Databricks external location or a managed volume.
| Field | Description |
|---|---|
| Source | Specify the path to the input file. This must be the path to a file in a Databricks external location or managed volume. |
| What file type is your source? |
Specify the format of the source file. The supported formats are:
|
| Force | Set to false to skip files that have already been copied into the target table (Default). When set to true, files are copied again, even if they have already been copied into the table . |
| Merge schema |
Set to false to fail if the schema of the target table does not match the schema of the incoming files (Default). When set to true, new columns are added to the target table for each column in the source file that does not exist in the target table. Note that the target column types must match the source column types even when Merge schema is selected |
| Format Options |
Each file format has a number of options that are specific to that format. Use this table to specify the appropriate options for your file format. See Databricks Format options. Note: This entry does not validate that the options entered are appropriate for the file format selected.
|