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

1. 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.
   
   

   

   
   

2. 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:

     
     

     

     
     

3. 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 the 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

While creating a connection for Snowflake from Integration Service, the connector always picks up the default role of the user as shown below.

Usually Snowflake Administrators set up custom roles for users since not everyone is granted administrator roles for security reasons. Below you can find an explanation of what exactly is needed in Snowflake for the Integration Service Connect process to work smoothly.

The first step is to make sure that the default role, in this case SAMRAT, has USAGE privilege on both the Database (JULY_DEMO) and Database schema (DEAL_AMOUNT) in Snowflake.

A successful authentication to Snowflake is dependent on these settings. A role can always have additional privileges assigned to it by an Administrator.