Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AllowPreparedStatement | Specifies whether the provider prepares SQL statements before executing them to improve performance on repeated queries. |
| ConnectRetryWaitTime | Specifies the number of seconds the provider waits before retrying a connection request. |
| ApplicationName | Specifies the application name that the provider includes in the HTTP User-Agent header when connecting to Databricks. |
| AsyncQueryTimeout | Specifies the number of seconds the provider waits for asynchronous requests that retrieve large result sets before timing out. |
| DefaultColumnSize | Specifies the default length, in characters, of string fields when the provider cannot determine a size from metadata. |
| DescribeCommand | Specifies which command the provider uses to retrieve metadata from Databricks. |
| DetectView | Specifies whether the provider uses the DESCRIBE FORMATTED command to determine whether an object in Databricks is a table or a view. |
| IncludeSystemSchemas | Specifies whether to include the system catalog 'system' and system schema 'information_schema'. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| QueryPassthrough | This option passes the query to the Databricks server as is. |
| Readonly | Toggles read-only access to Databricks from the provider. |
| ServerConfigurations | Specifies configuration variables to override the default settings on the Databricks server. |
| ServerTimeZone | Specifies how the provider interprets datetime values returned from Databricks. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UseDescTableQuery | Specifies whether the provider retrieves table column metadata using a DESC TABLE query instead of the Thrift API. |
| UseInsertSelectSyntax | DEPRECATED. This property is no longer supported, and should not be used. It will be removed in a future release. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |