4 of 4 people found this helpful
Hi Christopher Poss,
Spatial data from Redshift is not yet supported in Tableau. There is also no generic way to read WKT or WKB. Can you further explain your use case and what types of datasets you would be working with, in terms of geometry primitives (just points? points, lines and polygons?) and volumes (hundreds? thousands? more?)? Redshift will allow you to get the X and Y coordinates using ST_X and ST_Y, with those coordinates, you can visualize the results in Tableau using the MakePoint(x,y,srid) spatial function. If your geometry is stored with WKB, you will probably need to convert to a geometry first using ST_GeomFromWKB().
Tableau currently supports spatial data directly from the following sources:
- Esri Shapefiles
- Esri File Geodatabases
- MapInfo Tables (mid/mif and Tab)
- PostgreSQL + PostGIS
- Greenpplum + PostGIS
- SQL Server
- Tableau Extracts (.hyper)
We continue to look at new data sources, considering many factors, like customer demand and industry trends.
Kent Marten, Product Manager, Maps and Spatial Analysis, Tableau
Hat-tip to Sarah Battersby.
Wait, I didn't tag you, Kent. What is this? What did you do with Sarah?
Thanks so much for the quick response Kent Marten I'll provide some info below, but I'd love to show and discuss in some more detail the use case I'm working on. Is it possible to do a Webex with you?
some details -
We've been using GeoJSON files for our data and making great use of the spatial join within Tableau. At this time we have about 200 Multipolygon shapes in one file and about 118,000 Points in another file. We'd like to get away from using files, and prefer using Redshift as the database solution. As I mentioned, I'd be happy to provide you some more info "offline".
You tagged Sarah.
Sarah lateralled to me.
Sorry - no. Can you follow me within the forum here and send me a private message?
Haha! Well done!
Hi Chris, I'd love to know how you went with this. We already use Tableau extensively over Redshift. At present, we join the Redshift data to shapefiles in Tableau, but I'd love to explore using Redshift to do spatial joins as part of our data transformation processes. As we already use shape files in Tableau, I'm not too concerned if I can't get the spatial info from Redshift into Tableau (we already read have lat/long in Redshift and use that in Tableau) but it would be a bonus if I didn't need to use the separate shape files (maybe at some stage in the future).
Hi David Barham,
I would love to learn more about how people are thinking about working with Redshift Spatial + Tableau. Feel free to reach out to me to setup a call.
Kent Marten.Product Manager, Maps and Spatial Analysis