Convert SQLITE to PARQUET

Turn SQLITE files into PARQUET files. One Parquet file per table, named after it, with the columns typed as stored.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQLITE files on the dialor turn it to pick what to do

Every table as its own Parquet file.One Parquet file per table, with the columns typed as stored.

  1. What you get

    Each table in the SQLite database becomes a separate Parquet file, named after the table. A database with several tables gives you several files.

    The columns keep the types they have in the database, so numbers stay numbers in the Parquet file.

  2. What it leaves behind

    Views are skipped. Only tables are written, so a view gets no Parquet file.

  3. When a table fails

    A table with text stored in a number column fails. Check that columns declared as numbers hold only numbers before you convert.

    A file that cannot be parsed stops with input_corrupted.

  4. Going the other way

    To turn Parquet back into a database, use PARQUET to SQLITE.

SQLITE and PARQUET.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data
To · PARQUET

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 SQLITE to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report/ --to parquet
$ cv convert report.sqlite report/ --to parquet

Questions.What people ask about SQLITE to PARQUET.

01OF 04

Yes. Each table is written to one Parquet file named after it.

They are skipped. Only tables produce Parquet files.

Yes. The columns are typed as stored in the database.

It stops with input_corrupted when the SQLite file could not be parsed.

More conversions.Other ways in and out of SQLITE and PARQUET.