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 add-in models the schemaless HarperDB tables into relational tables. When you connect, the add-in dynamically updates the table schemas to reflect changes you make to HarperDB tables. The add-in 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.