Links

MSCEWI2005

GEO-SPATIAL not supported.
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.
  • 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.