v.23.4New Feature

Add PrettyJSONEachRow Format for Pretty JSON Output

Official CH changelog text
Add PrettyJSONEachRow format to output pretty JSON with new line delimiters and 4 space indents. #48898 (Kruglov Pavel).
Introduces the PrettyJSONEachRow output format that produces pretty-printed JSON with new line delimiters and 4-space indentation.

Why it matters

This feature enhances readability of JSON output by formatting each row as pretty-printed JSON. It solves the problem of hard-to-read compact JSON outputs, making it easier for users to visually parse and debug JSON data exported from ClickHouse.

How to use it

To use this feature, specify PrettyJSONEachRow as the output format in your query, for example:

sql<br>SELECT * FROM table FORMAT PrettyJSONEachRow<br>

Related resources

PreviousNext