[FIXED] AssertionError: Could not determine version from string 'Redshift 1.0.32574 on Amazon Linux, compiled by gcc-7.3.0'

Issue

I am using the python pandas library to read data in reshift warehouse. The command pd.read_sql() fails with the error message, AssertionError: Could not determine version from string 'Redshift 1.0.32574 on Amazon Linux, compiled by gcc-7.3.0'

Anyone here knows how I can resolve this?

Solution

This is a known issue from a recent cluster (patch) upgrade where the version string format changed. Apps that expect a specific string format so they can parse to ensure it's a supported version can error out. See https://forums.aws.amazon.com/thread.jspa?messageID=998260&#998260 for an AWS contact you can ping for immediate fix. If you have a support agreement with AWS, you can create a ticket there also.

Answered By - SQLmojoe