Snowflake Connection

Help Activities
, ,
1

Hi Everyone,

I am working on a use case where I need to connect the snowflake with UiPath.

Can you suggest me how we can connect UiPath with snowflake?

Thanks.

2

Welcome to the community @IshaAgarwal

There are a few ways:

  1. Use the Snowflake Integration Service in Orchestrator
  2. Use a snowflake ODBC driver connection for Database activities in Studio
  3. Use a Snowflake REST API that might be available for you (not sure what the project is for but worth checking).
3

Hi @IshaAgarwal,

Welcome to the Community.

You can create a connection in Orchestrator for Snowflake first.

Install the Snowflake package from Manage Packages and call the connection to use the activities.

4

Hi @IshaAgarwal ,
Use the UiPath Snowflake Connector through Integration Service.
For authentication, UiPath currently supports options such as OAuth 2.0, Microsoft Entra ID client credentials, RSA key pair, and Programmatic Access Token.

Thanks

5

Hi @IshaAgarwal

You can connect UiPath with Snowflake using the Snowflake activities/package available in UiPath Marketplace. You can also use the Database Activities with the appropriate Snowflake driver/connection string.

For a simple setup:

  1. Install the required Snowflake/Database activities package.
  2. Configure the Snowflake connection details.
  3. Use the available activities to execute queries and read/write data.

If you share your UiPath Studio version and whether you need to read, insert, or update data, I can suggest the exact approach.

6

Hi @IshaAgarwal,

Welcome to the community.

You need to create an Integration Service Connection in UiPath Orchestrator. Then install the Snowflake Activities package in your UiPath Studio Project and you can use the Snowflake activities.

Check the documentation below for the step-by-step configuration and available activities:

Thanks!

8

Thanks Alot @YankitSingh