Snowflake Data Pipeline in ArcGIS Online

458
3
12-06-2023 06:49 AM
JenniferHowell
New Contributor II

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
3 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
New Contributor II

Thanks Max, I will follow up with you via email 

0 Kudos
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
0 Kudos