odbc2parquet 0.1.5

Query an ODBC data source and store the result in a Parquet file.
odbc2parquet-0.1.5 is not a library.

ODBC to Parquet

Query ODBC databases and save the result in a parquet file.


odbc2parquet run "Driver={ODBC Driver 17 for SQL Server};Server=localhost;UID=SA;PWD=<YourStrong@Passw0rd>;" "SELECT * FROM Birthdays" out.par1

Use odbc2parquet --help to see all option.


Currently only deployed via cargo. Use cargo +nightly install odbc2parquet to install it.

Mapping of types

The tool queries the ODBC Data source for type information and maps it to parquet type as such:

ODBC SQL Type Parquet Logical Type
Decimal(p=0..18, s=0) Decimal(p,s)
Numeric(p=0..18, s=0) Decimal(p,s)
Bit Boolean
Double Double
Real Float
Float Float
Tiny Integer Int8
Small Integer Int16
Integer Int32
Big Int Int64
Date Date
Timestamp Timestamp Microseconds
All others Utf8 Byte Array

p is short for precision. s is short for scale. Intervals are inculsive the last element.