Convert JSONL to PARQUET
Turn JSONL files into PARQUET. A Parquet table with one row per line and its columns and types inferred by DuckDB; nested objects and lists become structs and lists.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop JSONL files on the dialor turn it to pick what to do
JSON Lines as a typed Parquet table.Each line becomes one row, with columns and types worked out for you.
What you get
One PARQUET file with a row for every line of the JSONL file. The columns and their types are inferred by DuckDB from the data in the lines.
Parquet stores data in typed columns, so the result is a table you can load into analytics tools.
Nested data
Objects inside a line do not get flattened. A nested object becomes a struct, and a list becomes a list, so the shape of each record is kept in its column.
When it fails
If the file cannot be parsed, the conversion stops with
input_corrupted. This happens when the JSONL file is not valid JSON Lines.To go the other way, use PARQUET to JSONL.
JSONL and PARQUET.What each format is.
The formats
JSON Lines
JSON Lines, one JSON object per line, the format of logs and datasets.
- Extensions
- .jsonl .ndjson
- MIME type
- application
/jsonl - Kind
- Text and data
Parquet
The columnar data format of analytics. Compressed, typed and fast to scan.
- Extensions
- .parquet .pq
- MIME type
- application
/vnd .apache .parquet - Kind
- Text and data
In your code.The same JSONL to PARQUET conversion through the API, for your app or your agent.
$ cv convert report.jsonl report.parquet$ cv convert report.jsonl report.parquetQuestions.What people ask about JSONL to PARQUET.
It makes one PARQUET file.
DuckDB infers the columns and their types from the data in your file. You do not set them yourself, and this conversion has no options.
Nested objects become structs and lists become lists. They are not split into separate columns or rows.
NDJSON files use the same format as JSONL, and the extension ndjson is listed for it. They are read like any other JSON Lines file.