Last Modified Date: 17 Nov 2019
Environment
- Tableau Server
- Amazon Redshift
- PostgreSQL ODBC driver
Resolution
This behavior occurs by design in order to assist with initial setup, however connecting to Amazon Redshift via the PosgtreSQL ODBC is not recommended. Download and install the Redshift ODBC driver in order to connect to Amazon Redshift.Cause
Prior to Amazon’s release of a native Redshift ODBC driver, Tableau used the PostgreSQL driver to connect to Amazon Redshift.Additional Information
While using the PostgreSQL ODBC Driver to connect to Amazon Redshift, the queries are not optimized; you may see performance degradation or loss of Tableau functionality.While the ability to connect using the Postgres driver remains, the only supported driver for connections to Amazon Redshift is the Redshift ODBC driver available at https://www.tableau.com/support/driver.
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials