This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
|MaxRows||Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.|
|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.|
|RowScanDepth||The maximum number of rows to scan to look for the columns available in a table.|
|RTK||The runtime key used for licensing.|
|SupportEnhancedSQL||This property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.|
|Timeout||The value in seconds until the timeout error is thrown, canceling the operation.|