Snowflake provides the following data types for geospatial data:
The GEOGRAPHY data type, which models Earth as though it were a perfect sphere.
The GEOMETRY data type, which represents features in a planar (Euclidean, Cartesian) coordinate system.
Data Types
Snowflake provides the following data types for geospatial data:
The GEOGRAPHY data type, which models Earth as though it were a perfect sphere.
The GEOMETRY data type, which represents features in a planar (Euclidean, Cartesian) coordinate system.
https://docs.snowflake.com/en/sql-reference/data-types-geospatial
C and D: https://docs.snowflake.com/en/sql-reference/data-types-geospatial
Snowflake provides the following data types for geospatial data:
The GEOGRAPHY data type, which models Earth as though it were a perfect sphere.
The GEOMETRY data type, which represents features in a planar (Euclidean, Cartesian) coordinate system.
The GEOGRAPHY and GEOMETRY data types can store the following types of geospatial objects: WKT / WKB / EWKT / EWKB / GeoJSON geospatial objects: Point. MultiPoint.
For geospatial data storage like longitude/latitude Geography is the option
https://docs.snowflake.com/en/sql-reference/data-types-geospatial#:~:text=If%20you%20have,use%20geospatial%20functionality.
The GEOGRAPHY data type, which models Earth as though it were a perfect sphere.
The GEOMETRY data type, which represents features in a planar (Euclidean, Cartesian) coordinate system. [only PREVIEW as of Mar-2023] => D is correct
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Kate0204
Highly Voted 2 years, 1 month agoAndywu213
Highly Voted 2 years, 1 month agoPrashantGupta1616
Most Recent 7 months, 3 weeks ago_yyukta
11 months, 1 week agoMarge23
1 year, 4 months agosinghks
1 year, 5 months agoMultiCloudIronMan
1 year, 6 months agoHopefan
1 year, 8 months agolearner2023
1 year, 9 months agoKarBiswa
1 year, 10 months agoKarBiswa
1 year, 10 months agoSnowProCertDec22
2 years, 1 month agoEmiB
1 year, 10 months ago