Spatial data must be cataloged before performing spatial analytics, such as using spatial operations in Data Integrity Suite pipelines.
For instance, you may have a spatial table representing store catchment areas boundaries, which you can utilize in a pipeline to assign a store ID to each customer record. Data Integrity Suite catalog process supports cataloging of spatial data tables in Snowflake. Both Snowflake spatial data types are supported:
- GEOGRAPHY data type, modeling Earth as a perfect sphere with coordinates in latitude and longitude using the WGS84 spatial reference system (EPSG:4326).
- GEOMETRY data type with coordinates projected to a flat surface as x and y coordinates pairs, often in meters. This data type can support any spatial reference systems defined by the EPSG (European Petroleum Survey Group). For more information, see https://epsg.org/home.html.