CSV
Loading CSV Into ClickHouse From the Command Line Fast
Load CSV into ClickHouse with clickhouse-client and FORMAT CSVWithNames, tune delimiter, errors and dates, and check a file first with clickhouse-local.
7 min read
Topic
ClickHouse
Column-store speed for billions of rows: table engines, ingestion and queries that scan a year of events before your coffee cools.
CSVGuide
Loading CSV Into Cloud Warehouses Without Painful Reloads
How to load CSV into BigQuery, Snowflake and ClickHouse: stage the file, declare the schema, pick an error policy, load once and check the counts afterward.
17 min read
JSON
Storing JSON in ClickHouse and Querying Its Fields Fast
Store JSON in ClickHouse as a String with JSONExtract functions or as the native JSON type, with size and speed measured on 200,000 documents.
7 min read
Get new articles by email
We send one email when a new article is published. No spam.