Hi Dylan - thanks for your question - first for clarification - we don't allow you to connect to ODBC sources yet from Qlik Sense Cloud (as per title of your discussion) - so do you mean Qlik Sense Enterprise Server, a local installation on premise or up in your own cloud-like infrastructure? (I assume so)
If that is the case - the ODBC connector pack drivers are not recommend to connect to Redshift they are for standard PostgreSQL installations only - Redshift is packaged and licensed differently Amazon Redshift and PostgreSQL - Amazon Redshift - and that message is coming from the driver itself.
As you have stated, you can obtain the specific Redshift driver - but it would require someone to install it and configure the ODBC system DSN: Configure an ODBC Connection - Amazon Redshift - then you would be able to use the generic ODBC connector to connect to Redshift form the Data Load Editor and select the DSN name:
Let me know how you do.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Mike Tarallo (@mtarallo) | https://twitter.com/mtarallo