vertica-test.py

import sqlalchemy as sa
import json
from sqlalchemy.ext.automap import automap_base

with open("credentials") as cred_file:
    credentials = json.load(cred_file)

user_pro = XXREDACTEDXX

conn_info_pro = {'drivername' : 'vertica+vertica_python',
                 'host': XXREDACTEDXX,
                 'port': 5433,
                 'username': user_pro,
                 'password' : credentials[user_pro],
                 'database' : 'db_bigju'
                }

connection_url = sa.engine.url.URL(**conn_info_pro)
engine = sa.create_engine(connection_url)
conn = engine.connect()

Base = automap_base()
Base.prepare(engine, reflect=True)

# This now lists only the tables in schema 'public'
Base.metadata.tables.keys()