Importing from various data formats to 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 are looking to connect a BI tool like Grafana, Tableau and others, check out the Visualize category of the docs.