Establishing a Geodatabase connection to Snowflake computing

[EricAnderson14]

We have a data repository that resides in a Snowflake computing environment. We are wondering if it is possible to establish a ArcGIS Geodatabase connection to the cloud based Snowflake computing environment? 

Please let us know if anyone has any experience with anything like this. 

Thank you. 

Eric Anderson

[BruceHarold]

All, FYI creating a feature service from a Snowflake connection is under consideration.

[MichaelMirobelli]

Thanks for the great news @BruceHarold! What is a rough time to market from when a feature is under consideration to when it is available in Beta?

[BruceHarold]

@NanaDeiCan you help Michael here?

[NanaDei]

@MichaelMirobelli, there are several factors that are considered in the implementation of a feature. We’re currently working on providing native support for Snowflake (Cloud data warehouses) within ArcGIS Pro and ArcGIS Enterprise, and the roadmap has been updated to near-term. Please join us in the ArcGIS Enterprise: The Road Ahead UC session to learn more about the current work to support cloud data warehouses.

[MichaelMirobelli]

@NanaDei Thanks for the heads up! I was actually going to end up missing that session for a work meeting, but I'll rearrange my schedule to accommodate it.

[BenHiggs]

Hi Eric,

It is possible to establish a connection between ArcGIS and Snowflake. You would just need to install and set up the Snowflake ODBC driver, then pull the data into your map as a query layer (Map > Add Data > Query Layer).

Here is a step-by-step video on how to do that https://www.youtube.com/watch?v=pnSaS95Rlqs

[DavidHoy]

When Pro or Insights retrieves information from Snowflake - it casts Geography coordinates to Geometry and interprets the feature as point, line or polygon.
But I am not clear whether a Coordinate transformation occurs on the fly. Does snowflake actually record coordinate system (Datum in particular) or does it always presume Lat/Long in WGS84?

[Dan_Joyce_OE]

I dipping my toes into Snowflake for the first time and had the same question regarding coord system for the Geography objects...from the doco it looks like WGS84 geographic is the default.

The Geometry object looks like it can accept projected coordinate systems.