Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| ColumnEncoding | The Encoding used for the column values. Accepted entries are None, UTF8, and BASE64. None is the default. |
| DatetimeFormat | The format used when inserting datetime values into the database. |
| ExposeColumnTimestamp | Specifies whether to expose the cell timestamp as a separate column when executing the SELECT Statement. |
| IncludeDisabledTables | Specifies whether to retrieve disabled tables. |
| 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. |
| Pagesize | Specifies the maximum number of records per page the provider returns when requesting data from Apache HBase. |
| Readonly | Toggles read-only access to Apache HBase from the provider. |
| ResetTableMetadataOnDelete | Specifies whether to reset the cache table after executing the DELETE Statement. |
| RetrieveSelectedColumnsOnly | Specifies whether to retrieve selected columns only when executing a SELECT statement. |
| RowScanDepth | The maximum number of rows to scan to look for the columns available in a table. |
| ScannerCaching | Specify a scanner cache that will be filled before the Scan result is returned, setting setCaching to the number of rows to cache before returning the result. By default, the caching setting on the table is used. The goal is to balance IO and network load. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| TypeDetectionScheme | Determines how to determine the data type of columns. |
| 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. |
| UseSQLFiltering | Specifies whether to use the ScannerFilter when executing the SELECT Statement. |