nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

All comments

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.

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?

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

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.

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.

bharold

@NanaDeiCan you help Michael here?

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?

bharold

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

MichaelMirobelli

@BruceHarold Thanks for the fast answer. I should have been more specific, I was asking about support for/ within ArcGIS Enterprise. That is, will we be able to create WMS/WFS services from data in Redshift.

bharold

Data Interoperability extension supports Redshift now and will add Redshift Spatial (both read and write) at Pro 2.8

MichaelMirobelli

@NanaDei Thanks for the information!! The roadmap that you linked mentioned Snowflake and BigQuery. Is Redshift already supported or will support for that be coming at a different time?

NanaDei

Providing native support for Snowflake within ArcGIS Pro and ArcGIS Enterprise is on the mid-term roadmap, which typically includes new functionality coming in the next two or three ArcGIS releases.

Using Snowflake with ArcGIS as of today depends on your use cases and functionality that is currently available to support them:

ArcGIS Pro 2.6 and later has read-only support for non-spatial data using an OLEDB connection
ArcGIS Data Interoperability extension provides read/write support at ArcGIS Pro 2.6 and later
ArcGIS Insights is scheduled to provide non-spatial support in the March 2021 release, and plans to provide spatial support in Q4 2021

We are interested in understanding how you are using Snowflake today and how you intend to use Snowflake with ArcGIS. Please share your use cases and business requirements in the comments.

AmyKlug

I heard Insights might do this in next release.

MichaelMirobelli

I have the same question about connecting to Snowflake. My understanding is that the roadmap for Snowflake does include geospatial capabilities, but is there any way to connect ArcGIS Enterprise to Snowflake currently?

BirajaNayak

Hi Eric,

Have you tried the below document to connect to SQL server database in Cloud:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html

Some more additional document here for the connection:

http://enterprise.arcgis.com/en/server/latest/cloud/amazon/create-geodatabase-in-amazon-rds-for-sql-server.htm

Thanks,

Biraja

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.