SSC-EWI-BQ0006

Oriented parameter in the ST_GEOGFROMTEXT function is not supported in Snowflake.

Severity

Low

Description

This warning is added when the oriented parameter is specified in the ST_GEOGFROMTEXT function, because it is not supported in Snowflake. If this parameter is set to TRUE, any polygon in the input is assumed to be oriented as follows: if someone walks along the polygon boundary in the order of the input vertices, the interior of the polygon is to the left. This allows WKT to represent polygons larger than a hemisphere. If oriented is FALSE or omitted, this function returns the polygon with the smallest area.

Code Example

Input Code:

BigQuery

IN -> BigQuery_01.sql

SELECT ST_GEOGFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))', TRUE);

Output Code:

Snowflake

OUT -> BigQuery_01.sql

SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-BQ0007 - ORIENTED PARAMETER IN THE ST_GEOGFROMTEXT FUNCTION IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
ST_GEOGFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))');

Recommendations

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