Issue
In Tableau Desktop 2020.4, when bringing a single Redshift table that has a geometry column, the preview reports the value as null.
Last Modified Date: 15 Mar 2021
Environment
- Tableau Desktop 2020.4.1
- Amazon Redshift
Resolution
- Upgrade Redshift Driver to 1.4.17 or 1.4.20 (https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html)
- Set the SRID when manipulating and store the data in Redshift. E.g.
- UPDATE [table name] SET [geometry field] = st_setsrid([geometry field], 4326);
- UPDATE [table name] SET [geometry field] = st_setsrid([geometry field], 4326);
Cause
- Amazon has released the 1.4.17 Redshift ODBC driver to enable Redshift spatial feature in Tableau 2020.4
- By default, Redshift doesn't have a default SRID set, which is needed for Tableau to read it.
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