MSCEWI2005

GEO-SPATIAL not supported.

Severity

Medium

Description

GEO-SPATIAL data types are not supported in Snowflake.

Code Example

CREATE TABLE T_2005
(
GEOM SYSUDTLIB.ST_GEOMETRY(2097088000) INLINE LENGTH 9920 NOT NULL
);

Recommendations

  • Consider the possibility of using Snowflake's GEOGRAPHY data type when viable.

  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.