Does snowflake support geometry data type which is used in sql server?

1
votes

Does snowflake support geometry data type, which is used in SQL server? i only see geography data type in snowflake, whether same data from sql server to snowflake can be stored from geometry data type to geography data type column?

1
snowflake-cloud-data-platform

1 Answers

1
votes

Snowflake supports only GEOGRAPHY data type. It's different than geometry data so you can not store them directly but you can try to convert it on SQL Server:

https://social.msdn.microsoft.com/Forums/en-US/a17a9320-8360-4497-942a-c3cbcec1d4cf/how-to-convert-geometry-to-geography-?forum=sqlspatial