Snowflake authentication

Prerequisites

Depending on the authentication type you select, you need one of the following credentials:

• For Custom authentication (JDBC authentication):
  • Database host
  • Username
  • Password
  • Warehouse
  • Database schema name
  • Database name
• RSA (Key Pair Authentication & Key Pair Rotation)
  • Database host
  • Username
  • RSA private key
  • Warehouse
  • Database schema name
  • Database name

Note:

Known limitations:

• To authenticate using RSA, you must use an unencrypted RSA private key.

• Connections via AWS PrivateLink are not supported.

Add the Snowflake connection

1. Select Integration Service from Automation Suite.

2. From the Connectors list, select Snowflake. You can also use the search bar to find the connector.
3. Select the Connect to Snowflake button.
4. Enter your required Snowflake credentials.

5. Select Connect.

6. Your connection has been added.

How to retrieve your credentials from Snowflake

1. The database host is available in the URL 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 available 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 from 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.