This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
|Tells provider to expose empty strings as null values.
|Set to true if file extensions should be excluded from table names.
|Limits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
|These hidden properties are used only in specific use cases.
|Mimics beahviour of SET EXACT ON mode in Microsoft OLE DB provider.
|A filepath pointing to the JSON configuration file containing your custom views.