Parquet best practices

This page summarizes the projects mentioned and recommended in the original post on /r/dataengineering

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • odbc2parquet

    A command line tool to query an ODBC data source and write the result into a parquet file.

  • Is this a one-time task? Maybe check out ODBC2PARQUET https://github.com/pacman82/odbc2parquet

  • sql-spark-connector

    Apache Spark Connector for SQL Server and Azure SQL

  • I do not whether you have a spark cluster available or not, but you can try it out this way. Install SQL server spark JDBC driver https://github.com/microsoft/sql-spark-connector into spark cluster, query out the SQL server, and save into parquet files. I used it before, it was pretty fast.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts