Ingesting Data Formats

Format for Input

ClapDB can accept data in various formats. A format supported for input can be used to parse the data provided to INSERTs, to perform SELECTs from a file-backed table such as File, URL. All format names are case insensitive.

the supported formats are:

Format
CSV
CSVWithNames
TSV
TSVRaw
TSVWithNames
TSVRawWithNames
NDJSON
JSON

CSV

Comma seperated format without header line. support double quote escaping rule.

CSVWithNames

same as CSV except it has header(column names) as the first line.

TSV

Tab seperated format without header line. support double quote escaping rule.

TSVRaw

same as TSV except NOT support double quote escaping rule.

TSVWithNames

same as TSV except it has header(column names) as the first line.

TSVRawWithNames

same as TSVRaw except it has header(column names) as the first line.

NDJSON

a separated, newline-delimited JSON Object at each row.

Example:

{"num":42,"str":"hello","arr":[0,1]}
{"num":43,"str":"hello","arr":[0,1,2]}
{"num":44,"str":"hello","arr":[0,1,2,3]}

JSON

same as NDJSON.