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]
Last updated