Reading Polygon data from Teradata into Tableau

Question

I understand Tableau can't read a clob field in Teradata where I have the Polygons. However I understand there is a work around to extract data that can be used by Mapping capabilities of Tableau. Can you please suggest in SQL or with any other function what format it is expecting the data to be so I can draw the shapes /map inside Tableau?

My CLOB data looks like this:

POLYGON((-xx.xxxxx xx.xxxxxx,-xx.xxxxx xx.xxxxxx,-xx.xxxxx xx.xxxxxx))

I am able to split the lat and long and convert then to decimal numbers however Tableau is still very slow, it is able to render but for one state map it is taking 2 min or more — Aftab
– Aftab, Commented Dec 9, 2024 at 21:16

Alex Blakemore · Accepted Answer · 2024-12-11 19:54:01Z

0

If you are able to read your CLOB field so that Tableau recognizes it as as having the datatype string, and if your text strings contain WKTF, then all you need to do is change the datatype in Tableau to spatial.

Then Tableau will recognize that field as having spatial geometry values. Then you can place your spatial field's bill on the detail shelf, and then the generated Latitude and Longitude fields will populate from the WKTF geometry, allowing you to display and perform calculations on spatial objects.

If your driver ignores CLOBs, you may be able to use Custom SQL to turn the CLOB into some form of text that Tableau can recognize.

answered Dec 11, 2024 at 19:54

Alex Blakemore

12k2 gold badges30 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading Polygon data from Teradata into Tableau

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related