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