# 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](/files/GhhNRlVx9yAkkxQySO4D)

| 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>    |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/pdi-job-entries-reference-overview/bulk-load-into-databricks/options-bulk-load-into-databricks/input-tab-bulk-load-into-databricks.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.