ClickHouse provides several approaches for handling JSON, each with its respective pros and cons and usage. In this guide, we will cover how to load JSON and design your schema optimally. This guide consists of the following sections:
- Loading JSON - Loading and querying structured and semi-structured JSON in ClickHouse with simple schemas.
- JSON schema inference - Using JSON schema inference to query JSON and create table schemas.
- Designing JSON schema - Steps to design and optimize your JSON schema.
- Exporting JSON - How to export JSON.
- Handling other JSON Formats - Some tips on handling JSON formats other than newline-delimited (NDJSON).
- Other approaches to modeling JSON - Legacy approaches to modeling JSON. Not recommended.