sqlalchemy-vertica-python 0.1.0

Vertica dialect for sqlalchemy using vertica_python

Vertica dialect for sqlalchemy. Forked from the Vertica ODBC dialect.

This module implements a Vertica dialect for SQLAlchemy using vertica-python. Engine creation:

import sqlalchemy as sa
sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')

Installation

From PyPI:

pip install sqlalchemy-vertica-python

From git:

git clone https://github.com/LocusEnergy/vertica-sqlalchemy
cd vertica-sqlalchemy
python setup.py install

Known Issues

• Error handling is subpar. In particular, sqlalchemy attempts to raise a dbapi.Error, which vertica_python does not have. This can likely be fixed in the future by overriding some of the Default Dialect methods.