Nested Data

Nested data is any array or objects contained within an incoming data source. Nested data may appear in document-stores (Mongo), APIs, and even relational databases like Postgres JSON fields. Additionally, some of Panoply's data enhancement features may produce nested values for flat data.

For example, a table contains a field for the IP may include a nested object with the geo-location information for that IP address.

In order to be fully compatible with most popular analysis tools, like BI suite, and standard SQL queries, Panoply uses a strongly relational model that doesn't allow these nested values to appear in the data. Therefore, Panoply supports several ways to transform these nested structures into a flat relational model.

Subtables
Flattening
JSON data type
Pivoting
Skipping