Spatial data not coming through when queried

[rob-k]

Hi,

I'm having issues with loading spatial data into Alteryx from SQL Server. If I put anything in the WHERE part of the query the Spatial type column comes through incorrectly - see image below.

If I leave WHERE empty then Spatial columns are loaded without any issues. 

 

I've tried troubleshooting it but have been unsuccessful so far. Any advice on how to fix this would be much appreciated.

Thanks,

[aatalai]

@rob-k have you selected read spatial objects as centroids in the data input tool?

[rob-k]

I do if my data is a point. Most of the time i'm looking at Polygons.

[alexnajm]

Are you using an OleDB connection? That seems to be the fix according to this: https://knowledge.alteryx.com/index/s/article/Spatial-Data-from-SQL-Server-shows-up-as-None-Null-or-...