Skip to main content

Vertica dialect for sqlalchemy using vertica_python

Project description

Vertica dialect for sqlalchemy. Forked from the Vertica ODBC dialect, written by James Casbon.

This module implements a Vertica dialect for SQLAlchemy using the pure-Python DB-API driver vertica-python, as adapted by Luke Emery-Fertitta.

It is currently maintained by BlueLabs - PRs are welcome!

Engine creation:

import sqlalchemy as sa


From PyPI:

pip install sqlalchemy-vertica-python

From git:

git clone
cd vertica-sqlalchemy-python
python install


ID/Primary Key Declaration

Do not use this. The INSERT will fail as it will try to insert the ID

id = Column(Integer, primary_key=True)

Do the following instead

id = Column(Integer, Sequence(‘user_id_seq’), primary_key=True)

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for sqlalchemy-vertica-python, version 0.5.10
Filename, size File type Python version Upload date Hashes
Filename, size sqlalchemy_vertica_python-0.5.10-py3-none-any.whl (6.7 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size sqlalchemy-vertica-python-0.5.10.tar.gz (6.0 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page