> ## Documentation Index
> Fetch the complete documentation index at: https://insightsoftware-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Configuring Advanced Options

You can configure advanced options to modify the behavior of the connector.

To configure advanced options:

1. To access advanced options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click **Configure** , and then click **Advanced Options**.
2. In the **String Column Length** field, type the maximum data length for STRING columns.
3. In the **Binary Column Length** field, type the maximum data length for BINARY columns.
4. In the **Max Complex Type Column Length** field, type the maximum data length for complex data types the connector casts to SQL\_VARCHAR.
5. In the **Max Catalog Name Length** field, type the maximum number of characters that catalog names contain.
6. In the **Max Schema Name Length** field, type the maximum number of characters that schema names contain.
7. In the **Max Table Name Length** field, type the maximum number of characters that table names contain.
8. In the **Max Column Name Length** field, type the maximum number of characters that column names contain.

<Note>
  **Note:** For the options described in steps 4 to 8, you can specify `0` to indicate that there is no maximum length or that the length is unknown.
</Note>

9. In the **Rows To Fetch Per Block** field, type the maximum number of rows to fetch per stream if using the result set streaming API.
10. In the **Max Execution Polling Interval** field, type the maximum time, in milliseconds, to wait between attempts when polling the server for the query execution result.
11. In the **Min Execution Polling Interval** field, type the minimum value of the polling interval in milliseconds.
12. In the **Execution Polling Interval Multiplier** field, type the multiplier by which the connector increases the amount of time between polls.
13. In the **Non Proxy Host** field, type a list of hosts, separated by a comma ( `,` ), that the connector can access without connecting through the proxy server, when a proxy connection is enabled.
14. In the **Trusted CA Certificate** field, type the full path and name of the `.pem` file containing the root certificate of the proxy server.
15. In the **Result Reuse Max Time** field, type the maximum age of previous query results that is considered for reuse.
16. To enable the connector to return SQL\_WVARCHAR instead of SQL\_VARCHAR for ARRAY, MAP, STRING, STRUCT, and VARCHAR columns, select the **Use SQL Unicode Types** check box.
17. To reuse the results of previously run queries, select the **Enable Result Reuse** check box.
18. To enable the use of the AWS result set streaming API, select the **Use Result Set Streaming** check box.
19. To verifiy the certificate via the AWS SDK when connecting over SSL, select the **Verify SSL** check box.
20. To save your settings and close the Advanced Options dialog box, click **OK**.