JSON Overview

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 modelling JSON - Legacy approaches to modelling JSON. Not recommended.

Important: A new JSON type is available in Beta

This guide considers existing techniques for handling JSON. A new JSON type is available in Beta. Further details here.