topic Re: Issues when registering a Snowflake database in Geodatabase Questions

Issues when registering a Snowflake database

SBark_CBRE — Tue, 29 Nov 2022 09:37:30 GMT

Versions: Enterprise 10.9.1 and Pro 3.0

I am trying to publish data up to my ArcGIS Portal from Pro, which is hosted on a Snowflake cloud warehouse. I've successfully created a database connection, so can view the data in ArcGIS Pro. However the issue occurs when trying to share to Portal as a web layer, with the error "00231: Layer's data source must be registered with the server".

When I try to register the database (under Manage Registered Data Stores > Add > Database), I then get the error when validating "The connection property set was missing a required property or the property value was unrecognized. The specified data source (or database) is invalid []". It's worth noting that I am trying to connect to Snowflake using external browser authentication (SSO), so there is no stored username and login.

Can anybody confirm why I am receiving this error and what the next steps would be to resolve? My suspicion is due to either the lack of login credentials or something related to Snowflake not being registered, but any help appreciated!

Re: Issues when registering a Snowflake database

MarlonAmaya — Fri, 09 Dec 2022 00:11:59 GMT

@SBark_CBRE

Please make sure you have snowflake driver also installed on the ArcGIS Server Machine(s).

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

In addition, in order to register a database to ArcGIS Server, we must save the user name and password in the connection file.

https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-snowflake.htm
- If you will use the database connection file to publish web layers or use in geoprocessing models, you must check the Save User/Password check box.
- Only user authentication is supported when you connect to Snowflake from ArcGIS

Thank you

Marlon

Re: Issues when registering a Snowflake database

emoreno — Mon, 17 Nov 2025 18:26:03 GMT

Hi Marlon,

I am receiving this message as well, however I have confirmed that the snowflake odbc is installed on the Server machine and I have saved the username and password in the connection file. Any ideas as to where else I may be going wrong?

Here's the link to my esri community post: Error Registering a Snowflake DB as Datastore - Esri Community