Error Registering a Snowflake DB as Datastore

emoreno

Using Enterprise 10.9.1 and ArcPro 3.1.7

I am trying to register our Snowflake database as a datastore to our Server, but during the validation process I receive the error "the connection property set was missing a required property or the property value was unrecognized. The specified data source (or database) is invalid []."

For background, I am using a stored username and login and have verified that the Snowflake ODBC is on the ArcGIS Server Machine, as seen in this community post: Issues when registering a Snowflake database - Esri Community

I can connect successfully to the Snowflake database in Pro but registering it as a datastore seems to be where the issue is. I believe we run a multimachine deployment if this is relevant. Does anyone have any ideas as to how to solve the issue? Thanks!

 

Priya_Das

Hi @emoreno 

Considerations:

• The Snowflake ODBC Driver must be installed prior to establishing the connection in ArcGIS Pro
  • Below is the Snowflake Driver setup

Snowflake Driver Setup:

• Download and install the latest windows 64-bit Snowflake ODBC Driver
• Perform a Windows search to find and open ODBC Data Source Administrator 
• Click the System DSN tab and click Add and Select SnowflakeDSIIDriver
• Snowflake Configuration Dialog
  • Data Source - Enter a name for the data source
  • User - Provide account name (user@organization.com)
  • Server - The Snowflake server (youraccount.snowflakecomputing.com)
  • Tracing - Set it to "4"
  • Authenticator - Set it to "externalbrowser"
• Click on Test to confirm  Snowflake access
  • Click OK to save

Could you try registering your Snowflake database with ArcGIS Pro 2.9

I believe the compatible version of ArcGIS 10.9.1 is ArcGIS Pro 2.9: https://enterprise.arcgis.com/en/system-requirements/10.9.1/windows/databases-in-the-cloud.htm

Also you can refer to Best practices when integrating data from cloud data warehouses with ArcGIS Pro and ArcGIS Enterprise:https://www.esri.com/arcgis-blog/products/arcgis-enterprise/data-management/best-practices-when-integrating-data-from-cloud-data-warehouses-with-arcgis-pro-and-arcgis-enterprise

https://enterprise.arcgis.com/en/server/11.1/manage-data/windows/connect-snowflake.htm

https://pro.arcgis.com/en/pro-app/latest/help/data/databases/privileges-cloud-data-warehouses.htm#ESRI_SECTION1_8F2E86BDC30C45039451D23B8C0FEA30