Select to view content in your preferred language

Snowflake Data Pipeline in ArcGIS Online

1038
4
12-06-2023 06:49 AM
JenniferHowell
Occasional Contributor

Hello, 

I've attempted to create a connection to a Data Store using the BETA Data Pipelines in ArcGIS Online. The data store is Snowflake. On every occasion I insert the requirement parameters, 

Server

Username/Password

Database

Schema

Warehouse

Role

I've confirmed outside of AGOL that the credentials and parameters work and connetion is successful. 

however, in AGOL I continue to get 'Validation Failed"

Any ideas? Is there a specific driver I need? 

 

0 Kudos
4 Replies
MaxPayson
Esri Contributor

Hi Jennifer,

Is your Snowflake connection only accessible from an internal network, and not from an external service like ArcGIS Online? Are the other apps you are using running within your network?

This is one idea. I also have a few more ideas to investigate if you'd like to follow up over email, my email is mpayson@esri.com

Thank you for trying the beta and posting your issue!

Max

0 Kudos
JenniferHowell
Occasional Contributor

Thanks Max, I will follow up with you via email 

SimonMarin
Esri Contributor

Hi Jennifer.

I had the same error. 

when you set up the connection, on the server parameter, you must write it whitout the https. for example if it "https:/<idaccount>.snowflakecomputing.com" is you url you must put  <idaccount>.snowflakecomputing.com

 

Simon Marin
Solution engineer- Esri Colombia
Todd_Payne
Occasional Contributor

I am able to establish the connection to snowflake but cannot view any tables that I can access via the browser.  Any ideas as to why?

Todd_Payne_0-1723646301115.png

 

0 Kudos