Awesome Vertica

A curated list of awesome Vertica libraries, tools and resources.

Contributions are welcome. Please take a look at the contribution guidelines for details.

Contents

• Clients
• Tools
• UDXs
• Examples
• Integrations
• Deployments
• Other Resources

Clients

• vertica-python - Official Python driver.
• vertica-sql-go - Official Go driver.
• vertica-nodejs - Official Nodejs driver.
• vcli - CLI with auto-completion and syntax highlighting.

Tools

• d2l - Infer table DDL from csv-like files.
• PGVertica - Proxy server to connect from BI tools using PostgreSQL connectors
• verticaextractor - Extract data from tables and write native binary files.
• verticareader - Convert native binary files to CSV files.
• verticat - Count the rows, and take rows from native binary files.
• QueryParser - Library to parse Vertica, Hive, and Presto SQL.
• VerticaPy - Machine learning toolkit.

UDXs

• vertica-extension-packages - Official UDX samples.
• vertica-hyperloglog - HyperLogLog (approximate count distinct) UDX.
• vertica-plsql - Stored PL/SQL procedure in database or external.
• ODBC-Loader - User-Defined Load functions to load/query the external database.
• dblink - User-Defined Transform Function to run SQL against other databases via ODBC.

Examples

• vertica-ami-packer-templates - AMI build templates.
• vertica-geospatial - Geospatial example applications.
• vertica-machine-learning-examples - In-database machine learning examples.
• client-application-examples - Examples for connecting to Vertica in various clients, drivers and programming languages.

Integrations

• Apache NiFi - Data integration & ETL platform.
• DataGrip - JDBC-based SQL IDE (Commercial Software).
• DBVisualizer - JDBC-based SQL IDE.
• DBeaver - JDBC-based SQL IDE.
• H2O Flow - Analytics & data science platform (Commercial Software).
• JasperSoft - Analytics, BI & ETL platform (Commercial Software).
• Knime - Analytics & data science platform (Commercial Software).
• Pentaho - Analytics, BI and ETL platform (Commercial Software).
• RapidMiner - Analytics & data science platform (Commercial Software).
• SQuirrel SQL - JDBC-based SQL IDE.
• SQLS Language Server - Language Server Protocol for SQL.
• vertica-grafana-datasource - A data source for Grafana.
• vertica-snippets - SQL code snippets for Emacs.

Deployments

• Docker Images - Official images on Docker Hub.
• docker-vertica - Docker image targetted at UDF development.

Other Resources

• Vertica Academy - Free self-paced online Vertica courses.
• Vertica Blog - The official blog.
• Vertica Documentation - The official documentation.
• Vertica Knowledge Base - Short how-to's, integration guides, and best practices articles.
• Vertica Forum - The official community forum.
• Vertica Integrator's Guide - Integration guides, tips and strategies about provisioning, monitoring, management, storage, clients, loaders, and other tools.