JSON data type
- 05 Oct 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
JSON data type
- Updated on 05 Oct 2023
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
JSON data type
When setting a connector to ingest nested data as JSON data type, Panoply will ingest the entire object or JSON string as JSON. Any additional deeper nested fields will be part of the Panoply JSON field and will not be handled in any other way.
For example, the following record contains a nested location object:
{id:1, location: {city: 'San Francisco', state: 'CA', country: 'USA'}}
It would be ingested into the table in the following format:
| id | location |
|---|---|
| 1 | {city: 'San Francisco', state: 'CA', country: 'USA'} |
Note that ingesting as JSON data type is applicable for nested objects only, not for nested lists. For example, the following record cannot be ingested as JSON data type:
{locations: [ 'one', 'two', 'three' ]}
Note
This option is only available for BigQuery accounts
The nested data behavior exists directly in the data sources. Either change the default behavior or enter specific field paths and set their nested behavior to ingest as JSON data type.
Was this article helpful?
.png)