Direct Import from Archive Formats in ClickHouse

Why it matters

This feature enables users to easily read and import data stored inside compressed archive files without manually extracting them first. It simplifies the data ingestion process and saves time and resources by allowing ClickHouse to directly handle archive formats during query execution.

How to use it

To import data from compressed archives, use the file table function with a path pattern specifying the archive and the inner file, for example: file('*.zip :: *.csv'). This syntax instructs ClickHouse to read the CSV files directly from zip archives matching the pattern.