MSCEWI2005

GEO-SPATIAL not supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

This issue has been deprecated since SnowConvert for Teradata 2.0.144

Teradata geospatial type has an equivalent on Snowflake, therefore, this EWI is no longer useful.

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

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

• If you need more support, you can email us at [email protected]