README.rst

sqlalchemy-vertica

Vertica dialect for sqlalchemy.

Forked from the Vertica dialect for sqlalchemy using vertica-python.

import sqlalchemy as sa
import urllib
# for pyodbc connection
sa.create_engine('vertica+pyodbc:///?odbc_connect=%s' % (urllib.quote('DSN=dsn'),))

# for turbodbc connection
sa.create_engine('vertica+turbodbc:///?DSN=dsn')

# for vertica-python connection
sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')

# for vertica-python connection with optional parameters
sa.create_engine('vertica+vertica_python://user:pwd@host:port/database',
                 connect_args={"connection_timeout": 5})

Reference vertica-python for additional optional connection parameters

Installation

From PyPI:

pip install sqlalchemy-vertica[pyodbc,turbodbc,vertica-python]  # choose the relevant engines

From git:

git clone https://github.com/startappdev/sqlalchemy-vertica
cd sqlalchemy-vertica
pip install pyodbc turbodbc vertica-python  # choose the relevant engines
python setup.py install