Snowflake WKT Help

[Dylan Daniels]

I am connected to a Snowflake data table that contains a WKT column that I would like to be able to view on a map as a feature layer. Anyone have any experience with this? 

[Dave Leigh]

Hi Dylan

In order to display the data on a Map Chart you have to do a couple of steps to convert the data to WKB format, and tell Spotfire that the Data Table contains Geo data.

1) You will need to use a Custom Query or an Information Link, or a Snowflake View to convert the WKT column to a WKB using the ST_ASWKB() function.

2) Once you have the Data Table imported into Spotfire, you will need to add the following properties to the Data Table:

a) Add or set a Property called "MapChart.ColumnTypeId" with the value "Geometry"

b) Add or set a Property called "ContentType" with a value of "application/x-wkb"

Once you have these Properties set, you can add the Data Table to a Map Chart visualization as a Feature Layer, or open a Table visualization.  For the Table visualization you will need to set the Column Renderer to "Geometry" to see the shapes.

Cheers
Dave