Integration Service
Snowflake authentication - Automation Cloud latest
Integration Service User Guide
Last updated Dec 4, 2023

Snowflake authentication

To authenticate using Snowflake, you first need to select your authentication type:

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:


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 the accountID is za96341 and the region is

To construct a Database host you must use the format So, for the URL used above, the constructed Database host would be

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.

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2023 UiPath. All rights reserved.