Great Expectations of Vertica

Fri 29 May 2020

First run Vertica:

docker run -p 5433:5433 -e DATABASE_PASSWORD='foo123' jbfavre/vertica:9.2.0-7_debian-8

Confirm that you can connect to it, and create a schema called npi_data:

echo 'create schema npi_data' | vsql -p 5433 -h localhost -U dbadmin -d docker -w foo123

Now, GE uses Sqlachemy, so let's get a valid connection string. We'll rely on

Here's how to do the installs right in your global Python (no virtualenv) as installed via the OSX installer (as a "Framework"):

/Library/Frameworks/Python.framework/Versions/3.8/bin/python3.8 -m pip install -U pip
/Library/Frameworks/Python.framework/Versions/3.8/bin/python3.8 -m pip install great_expectations sqlalchemy sqlalchemy-vertica-python ipython

I like ipython, so you can use it to test the connection. Test it, in ipython:

# /Library/Frameworks/Python.framework/Versions/3.8/bin/ipython
import sqlalchemy as sa
engine = sa.create_engine('vertica+vertica_python://dbadmin:foo123@localhost:5433/docker')

Go ahead and load the example file from GE's tutorial to the databse:

import pandas as pd
df = pd.read_csv("my_data/npidata_pfile_20200511-20200517.csv")

Now we can run through the GE tutorial, using a database. You have the connection string above, so you'll chose the database option, (the "other", it might still be option 6), and create the sample expectations of this table.