Configuring Advanced Options on Windows

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

To configure advanced options on Windows:

  1. Open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Advanced Options.
  2. To specify the version of the Starburst Enterprise server that the connector is connecting to, in the Server Version field, type the server version number.
  3. To automatically test the connection, select Connection Test.
  4. To automatically populate the metadata for parameters, select Auto Populate Parameter Metadata.
  5. Choose one:
    • To return SQL_WVARCHAR for VARCHAR columns, and SQL_WCHAR for CHAR columns, select the Use Unicode SQL Character Types check box.
    • Or, to return SQL_VARCHAR for VARCHAR columns and SQL_CHAR for CHAR columns, clear the Use Unicode SQL Character Types check box.
  6. To make calls to SQLTables and SQLColumns without specifying a catalog, select Allow Metadata From Multiple Catalogs.

    7. Note:

    When this option is enabled and the connector makes a call to SQLTables or SQLColumns, the connector queries all catalogs. This may impact performance.

  7. To ignore broken catalogs, select Ignore Broken Catalog.
  8. To remove length, precision, and scale parameters from the SQLColumns() typename, select Remove Type Name Parameters
  9. To use the schema name passed in the DSN for metadata queries, select Use DSN Schema For Metadata.
  10. To use the System Catalog API to run metadata queries, select Use System Catalog For Metadata.
  11. To use an equal sign (=) in metadata queries, select Use Equal In Metadata Filters.
  12. To enable the connector to ignore SQL_ATTR_AUTOCOMMIT and always auto commit, select AutoCommit Always True.
  13. To allow HTTP redirects, select Allow HTTP Redirect.
  14. To cache access tokens, select Cache Access Token (OIDC authentication only).
  15. To specify the maximum data type length for complex types that the connector casts to VARCHAR (JSON, MAP, ROW, and ARRAY), in the Max Complex Type Column Length field, type the maximum length.
  16. To specify the maximum number of characters that the connector can return for the names of certain database objects, do one or more of the following:
    • In the Max Catalog Name Length field, type the maximum number of characters that the driver reports for SQL_MAX_CATALOG_NAME_LEN .
    • In the Max Schema Name Length field, type the maximum number of characters that the driver reports for SQL_MAX_SCHEMA_NAME_LEN.
    • In the Max Table Name Length field, type the maximum number of characters that the driver reports for SQL_MAX_TABLE_NAME_LEN.
    • In the Max Column Name Length field, type the maximum number of characters that the driver reports for SQL_MAX_COLUMN_NAME_LEN.
    • In the Max Varchar Column Length field, type the maximum number of characters for VARCHAR column names.
    • In the Max Prepared Statement Length field, type the maximum prepared query size.
  17. To configure the connector to use a Starburst Resource Group, do one or more of the following:
    • Optionally, in the Application Name Prefix field, type any required prefixes for the Application Name property.
    • In the Application Name field, type the application flag you want applied to the queries sent by the connector.
    • In the ClientTags field, type a comma-separated list of resource group tags that you want applied to the queries sent by the connector.
  18. In the ExtraCredentials field, type a comma-separated list of key-value pairs that you want to pass to an external service.
  19. In the ExtraCredentialsDelimiter field, type a one character delimiter to split up the key-value pairs that you want to pass to an external service.
  20. In the CallingAppName field, type the name of the application you want to use.
  21. In the Roles field, type a comma-separated list of key-value pairs for catalog and role.
  22. To save your settings and close the Advanced Options dialog box, click OK.