HarperDB is a schemaless database that offers NoSQL and SQL capabilities natively. HarperDB supports schemas and tables but the data (columns and data types) is unstructured.

The connector models the schemaless HarperDB tables into relational tables. When you connect, the connector dynamically updates the table schemas to reflect changes you make to HarperDB tables. The connector automatically finds the data types in a HarperDB table by scanning a configured number of rows from the table data.

You can use RowScanDepth, FlattenArrays, and FlattenObjects to control the relational representation of the columns in HarperDB tables. More information can be found on the Automatic Schema Discovery page.