Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| DirectQueryLimit | Limits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time. |
| EnableForeignKeyDetection | Whether to detect the foreign keys in ODBC. |
| FlattenArrays | Set FlattenArrays to the number of array elements you want to return as table columns. Otherwise, arrays are returned as strings of JSON. |
| FlattenObjects | Set FlattenObjects to true to flatten object properties into columns of their own. Otherwise, nested objects are returned as strings of JSON. |
| MaximumColumnSize | The maximum column size. |
| MaxRows | Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses. |
| Other | These hidden properties are used only in specific use cases. |
| PseudoColumns | This property indicates whether or not to include pseudo columns as columns to the table. |
| Readonly | You can use this property to enforce read-only access to HarperDB from the provider. |
| RefreshCachedSchemaAfterDDL | Whether or not the driver should refresh cached metadata, whether cached in memory or cached otherwise as configured by the driver's caching settings, after the successful execution of the driver's stored procedures, which all affect the schema in HarperDB itself. |
| RowScanDepth | The maximum number of rows to scan when generating table metadata. Set this property to gain more control over how the provider detects data types. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| TypeDetectionScheme | Comma-separated options for how the provider will scan the data to determine the fields and datatypes in each document collection. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |