KNOWLEDGE BASE

Geometry Column Showing Null When Connecting To Redshift Database


Published: 12 Mar 2021
Last Modified Date: 15 Mar 2021

Issue

In Tableau Desktop 2020.4, when bringing a single Redshift table that has a geometry column, the preview reports the value as null.

Environment

  • Tableau Desktop 2020.4.1
  • Amazon Redshift

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.
Did this article resolve the issue?