# Input tab

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.

![PDI Bulk load Databricks Input tab](https://2745965000-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvZoINBz5C5WnDZQlbOJQ%2Fuploads%2Fgit-blob-bf0d7de304573d3424f5c0ee330c5d57395b078a%2FPDI%20Bulk%20load%20Databricks%20Input%20tab.png?alt=media)

| 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?** | <p>Specify the format of the source file. The supported formats are:</p><ul><li>AVRO</li><li>BINARYFILE</li><li>CSV</li><li>JSON</li><li>ORC</li><li>PARQUET</li><li>TEXT</li></ul>                                                                                                                                                                                                                                               |
| **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**                   | <p>Set to <strong>false</strong> to fail if the schema of the target table does not match the schema of the incoming files (Default). When set to <strong>true</strong>, new columns are added to the target table for each column in the source file that does not exist in the target table.</p><p>Note that the target column types must match the source column types even when <strong>Merge schema</strong> is selected</p> |
| **Format Options**                 | <p>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 <a href="https://docs.databricks.com/en/sql/language-manual/delta-copy-into.html#format-options">Databricks Format</a> options.</p><p><strong>Note:</strong> This entry does not validate that the options entered are appropriate for the file format selected.</p>    |
