v.19.16New Feature

Introduce Customseparated Data Format That Supports Custom Escaping and Delimiter Rules

Introduce CustomSeparated data format that supports custom escaping and delimiter rules. #7118 (tavplubix)
Introduces the CustomSeparated data format in ClickHouse, allowing users to define custom escaping and delimiter rules for data parsing and serialization.

Why it matters

The CustomSeparated format addresses the need for flexible data import and export where standard delimiters and escape characters do not suffice. It enables users to tailor the format to match proprietary or unusual data files, improving compatibility and ease of data integration.

How to use it

Users can specify the CustomSeparated format in data import/export commands and configure custom delimiter and escape characters according to their data requirements. This can be done by setting appropriate format-specific parameters when reading from or writing to tables.