Thursday, February 19, 2015

Redshift sql alchemy dialect installation

It was not obvious to me how to install this thing – I wanted to use csvkit to auto-generate table schema and execute it on a DB server.


Install csvkit:

pip install –upgrade csvkit


install client-side postgresql packages (needed for sqlalchemy dialect install):

apt-get install libpq-dev


install python dev (thanks to this: http://ift.tt/1Eci5Q2):

apt-get install python-dev


install the redshift sqlalchemy dialect (found you could do this from here: http://ift.tt/1GaLSYx):

pip install http://ift.tt/1GaLSYz





No comments:

Post a Comment