'Create a new Geojson polygon smaller/bigger size and the same shape from an original one in Snowflake

We need to create a polygon buffer zone - both positive and negative (bigger and smaller size polygons) from the given one of a random shape. That could have been done if there was a functionality to create a perpendicular line of the given length to the original polygon, but I can not find such functionality in Snowflake.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source