Working with spatial data from Snowflake data source in TIBCO Spotfire map charts

book

Article ID: KB0071938

calendar_today

Updated On:

Products	Versions
TIBCO Cloud Spotfire	All
Spotfire Desktop	All

Description

Using the Snowflake data connector to bring in spatial data to TIBCO Spotfire can result in missing data in map charts unless some extra configurations are completed.

Issue/Introduction

This article explains how best to import spatial (map chart) data from Snowflake into Spotfire to prevent issues.

Environment

All

Resolution

1. Snowflake geometry data is in WKT format, which is not supported in Spotfire. The data will need to be converted to WKB format. Details on this process can be found here:

https://docs.snowflake.com/en/sql-reference/functions-geospatial.html

2. Snowflake geometry data doesn't include all location data by default, e.g. X- and Y- Min/Max/Center information. If these columns are missing in Spotfire then they will need to be added as new columns in the data. Those instructions can be found here: