# Advanced options tab

![Bulk load into Azure SQL DB Advanced options tab](/files/6erxAiQUeSMwvdAFpi7U)

Use this tab to configure parameters for the Bulk load into Azure SQL DB. Any **Name/Value** pair added as a parameter is passed to the Azure SQL database as a parameter, but the validation of the parameter is the user’s responsibility. See the [Azure SQL documentation](https://docs.microsoft.com/en-us/azure/azure-sql/) for further details on these parameters. The `Force` parameter here is provided as an example.

| Option    | Description                                                                                                                                                                                                                                                                                                                                                               |
| --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Force** | <p>Specify whether to force loading of files into a database:</p><ul><li><strong>True</strong></li></ul><p>Loads data to the table even if the data was already loaded from that file before. This option can potentially duplicate data in a table.</p><ul><li><strong>False</strong></li></ul><p>Ignores staged data files already loaded into the table (default).</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-azure-sql-db/options-azure-sql-db-bulk/advanced-options-tab-azure-sql-db-bulk.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.