gistfile1.txt

postgres_db = {'drivername': 'postgres',
               'username': 'postgres',
               'password': 'postgres',
               'host': '192.168.99.100',
               'port': 5432}

db_uri = URL(**postgres_db)
engine = create_engine(db_uri)

redshiftPostgreSqlAlchemy.py

import sqlalchemy as sa
engine = sa.create_engine('postgresql://username:password@url:5439/database')
connection = engine.connect()
result = connection.execute("select * from table")
for row in result:
    print(row)
connection.close()