MSCEWI2005

GEO-SPATIAL not supported.

Severity

Medium

Description

GEO-SPATIAL data types are not supported in Snowflake.

Code Example

Input Code:

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

Output Code:

CREATE TABLE PUBLIC.T_2005
(
    GEOM GEOGRAPHY NOT NULL
)

Recommendations

Last updated