- About the Snowflake connector
- Snowflake authentication
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
- Username
- Password
- Warehouse
- 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:
Permissions
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 region
of your account, as follows:
For the URL
https://app.snowflake.com/east-us-2.azure/za96341/dashboards
the accountID
is za96341
and the
region
is east-us-2.azure
.
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
za96341.east-us-2.azure.snowflakecomputing.com
.
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.