Pre-Steps

[vitdexoff]

sudo apt-get update

sudo apt-get install python-pip

sudo apt-get install libpq-dev

pip install setuptools

pip install psycopg2==2.7

pip install sqlalchemy

pip install sqlalchemy-redshift==0.5.0

pip install -U sqlalchemy-redshift <--- I faced an issue due old version of this, had to update.

-- To collect all the tables in the cluster in the expected format:

select '"'|| schema ||'.'|| "table" || '",' from svv_table_info;