Convert SQL to PARQUET

Turn SQL files into PARQUET files. The tables the script creates are loaded first, with a dump from MySQL, MariaDB or PostgreSQL rewritten into SQLite's dialect.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

One Parquet file for each table in your script.The tables the script creates are loaded, then written out with typed columns.

  1. What you get

    One PARQUET file per table, named after the table. Each column is typed from the type the script gives it.

    A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before the tables are loaded, so you do not need to edit the script first.

  2. What changes

    Dates that are not real dates, such as MySQL's 0000-00-00, are left empty. PostgreSQL true and false become 1 and 0.

  3. What is left out

    Views, functions and triggers are not carried over. The conversion leaves them out with a warning. Only the tables and their rows end up in the PARQUET files.

    To go the other way, use PARQUET to SQL.

SQL and PARQUET.What each format is.

The formats

From · SQL

SQL Script

SQL statements as text. A database dump that any SQL tool can read or replay.

Extensions
.sql
MIME type
application/sql
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 SQL to PARQUET conversion through the API, for your app or your agent.

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

Questions.What people ask about SQL to PARQUET.

01OF 04

One PARQUET file for each table the script creates. Each file is named after its table.

Yes. A dump from MySQL, MariaDB or PostgreSQL is rewritten into SQLite's dialect before the tables are loaded.

Dates that are not real dates, such as MySQL's 0000-00-00, are left empty in the PARQUET file.

No. Views, functions and triggers are left out, and the conversion gives a warning.

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