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