Unable to display Snowflake geography data type in ArcGIS Data Pipelines

Description

In ArcGIS Data Pipelines, adding Snowflake geography data type as input to the 'Create geometry' tool displays only the basemap with no data in the map preview.

Cause

Using an incorrect geometry format in the tool's parameter prevents the data from being displayed. In this example, the WKT or WKB format is selected instead of GeoJSON.

WKT and WKB define only the geometry format and do not include coordinate semantics, so their interpretation depends on the reference system. Whereas GeoJSON defines both the format and coordinates explicitly in WGS 84. When WKT or WKB is selected, the tool does not interpret the coordinates correctly.

Solution or Workaround

Change the geometry format to GeoJSON

Note:
ArcGIS Data Pipelines consumes credits when the compute resource is active. Refer to ArcGIS Data Pipelines: Credit consumption for more information.

1. Log in to ArcGIS Online with an organizational account.
2. Click Content > My content and select the data pipeline. In this example, it is SNOWFLAKE_DATA PIPELINE.
   
3. On the Overview tab, click Open in Data Pipelines.
   
4. In Data Pipelines, ensure the pipeline connection status is Connected, indicated by a blue check mark.
   
5. On the canvas, click the Create geometry tool.
   
6. In the Create geometry pane, for the Geometry format parameter, select GeoJSON.
   
7. In the Create geometry pane, click Preview to inspect the results.
   
8. In the preview pane, click Map preview to view the data on the map.
9. In the Map preview option, click the Expand icon and select a world basemap. In this example, the Topographic basemap is selected.
   

10. Click the Collapse icon to view the full topographic map.

The topographic map below displays the Snowflake geography point data.