- About the Snowflake connector
- Snowflake authentication
To authenticate using Snowflake, you first need to select your authentication type:
- Custom (JDBC authentication)
- RSA (Key Pair Authentication & Key Pair Rotation)
Then provide the following credentials:
- Database host
- Database schema name
- Database name
How to retrieve your credentials from Snowflake
The database host is available in the hyperlink used to connect to your Snowflake app:Note: The Database host format may differ depending on your account identifier type. To learn more, see the official Snowflake documentation and the section on Database Host which can be found below.
Once you are logged in, on the left-side menu, select Data, then Databases.
Database name: A list of databases is displayed:
Database schema name - Select a database to view the list of database schema names:
To retrieve the Warehouse, on the left-side menu, go to Admin > Warehouses:
Connecting allows UiPath to read, write, modify, and delete Snowflake data on your behalf.
Retrieving Database Host from Snowflake
Login to your Snowflake account and copy the URL of your browser window. The URL
contains both the unique
accountID and the
of your account, as follows:
For the URL
za96341 and the
To construct a Database host you must use the format
accountID.region.snowflakecomputing.com. So, for the URL used
above, the constructed Database host would be
Required Roles for connecting to Snowflake
A successful authentication to Snowflake is dependent on these settings. A role can always have additional privileges assigned to it by an Administrator.