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:
SELECT ST_GEOGFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))', TRUE);
Output Code:
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]
Last updated