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
sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')From PyPI:
pip install sqlalchemy-vertica-python
From git:
git clone https://github.com/bluelabsio/vertica-sqlalchemy-python cd vertica-sqlalchemy-python python setup.py 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)