Importing from various data formats to ClickHouse

Page describing how to import various data formats into ClickHouse

In this section of the docs, you can find examples for loading from various file types.

Binary

Export and load binary formats such as ClickHouse Native, MessagePack, Protocol Buffers and Cap’n Proto.

CSV and TSV

Import and export the CSV family, including TSV, with custom headers and separators.

JSON

Load and export JSON in various formats including as objects and line delimited NDJSON.

Parquet data

Handle common Apache formats such as Parquet and Arrow.

SQL data

Need a SQL dump to import into MySQL or Postgresql? Look no further.

If you’re looking to connect a BI tool like Grafana, Tableau and others, check out the Visualize category of the docs.