Connecting to Redshift using Python from an EC2 instance and not die trying
A step by step ODBC driver setup

I don’t know why is it so complicated to configure ODBC drivers in Python nor why there are so many conflicting instructions out there, so I have created this list to help you obtain precious success in this task.