add support of spatial data

[erwanj]

It seems that spatial data is not supported and is recognized as string in tableau.
Does the lack of the support of spatial data is a limitation of Tableau itself or of the connector?

[elefeint]

Not sure, but we'll figure it out. Can you describe your usecase?

[erwanj]

I want to be able to create a map with geometries (points/polygons) that are stored in a duckdb table. I already use this with postgis and it works well.

I have added the following instructions to the connexion of duckdb in the SQL initial:
INSTALL spatial;
LOAD spatial;

The query to test is :

SELECT ST_GeomFromText('SRID=4326;POLYGON((-71 42,-71 43,
-72 43,-72 42,-71 42))')::geometry as geom

• query on duckdb in dbeaver :
  
  It works.

• query on duckdb in tableau
  
  We can see that tableau doesn't detect the geom attribute as a geometry but a string.

For information, I show how it behaves with postgis on tableau :

• query on postgis in tableau
  
  We can see that tableau does detect the geom attribute as a geometry with postgis.
  

[rferraton]

Hello, I have the same problem importing a shapefile into Duckdb into a table, The Taco for DuckDB does not recognize the geometry datatype of the geom field whereas Dbeaver can :

[kglover29]

This is a Tableau platform limitation. I've added it to our backlog.