Library

Everything you need to level up your coding skills.

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

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.