KNOWLEDGE BASE

Spatial Data Type Not Available on Presto Connection With Custom SQL Query


Published: 21 Oct 2021
Last Modified Date: 21 Oct 2021

Issue

Spatial data type not available on Presto Custom SQL Query.

Environment

  • Tableau Desktop
  • Presto

Resolution

The ability to connect to spatial data using Presto connector is currently not built into the Tableau Desktop product.

As a workaround, try the following:

Migrate the spatial data to one of the following databases, then use the corresponding native connector to connect to the spatial columns to build the map visualizations in Tableau.
  • Microsoft SQL Server
  • PostgreSQL 
  • Pivotal Greenplum 
  • Oracle

Cause

Currently, Tableau does not support direct connections to spatial data using Presto connector.

Additional Information

You can use spatial columns stored in your database to build map visualizations in Tableau.

Tableau supports direct connections to spatial data using these connectors:

  • Microsoft SQL Server
  • PostgreSQL + PostGIS
  • Pivotal Greenplum + PostGIS
  • Oracle
For more information, see: Connect to Spatial Data in a Database.
 
Did this article resolve the issue?