# How to Connect Snowflake to Albato Using OAuth2 — Albato Help Center

Source: https://albato.com/wiki/articles/how-to-connect-snowflake-to-albato

Welcome to Albato Help

Search articles

# How to Connect Snowflake to Albato Using OAuth2

Last update:  
23/6/2026 · 3 min read

* * *

IN THIS ARTICLE

[Snowflake](https://albato.com/apps/snowflake) is a cloud-based data platform that helps businesses store, manage, and analyze all their data in one place. By connecting Snowflake to Albato you can streamline data flows across multiple business apps without manual effort. See how you can get more value from your data with Albato and Snowflake.

1.  Before setting up automations with Snowflake connect the app to Albato. [**Sign in**](https://albato.com/app/user/auth/login?lang=en) to your Albato account.
    
2.  Go to the **Apps** section and click the **Add a connection** button.
    

Example.png

3.  Search for **Snowflake** and select it. Click the **Add a connection button**.

snowflake3.png

4.  Create a **name** for your connection.

snoflake4.png

5.  Copy your **Snowflake account name** from your browser's address bar and paste it into the Account name field.

snowflake5.png

6.  Run the following statement below in the **Worksheets section**

`CREATE SECURITY INTEGRATION IF NOT EXISTS ALBATO TYPE = OAUTH OAUTH_CLIENT = CUSTOM OAUTH_CLIENT_TYPE = 'PUBLIC' ENABLED = TRUE OAUTH_REDIRECT_URI = '[https://r.albato.com/oauth/back/state](https://r.albato.com/oauth/back/state)'; SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('ALBATO');`

Run the OAuth security integration statement in Snowflake

7.  Snowflake will return the OAuth credentials. Copy the **Client ID**.

Copy the Client ID in Snowflake

8.  Go back to Albato and paste the value into the **Client ID** field.

Paste the Client ID in Albato

9.  Return to Snowflake and copy the **Client Secret**.

Copy the Client Secret in Snowflake

10.  Go back to Albato and paste the value into the **Client Secret** field.

Paste the Client Secret in Albato

11.  Click the **Continue** button.

Click Continue in Albato

12.  Click the **Grant Albato access** button.

Grant Albato access

13.  You will be redirected to Snowflake. Enter your Snowflake **Username**.

Enter your Snowflake username

14.  Enter your **Password**.

Enter your Snowflake password

15.  Click the **Sign in** button.

Sign in to Snowflake

16.  Click the **Allow** button to grant access.

Allow access in Snowflake

17.  If you see the **Invalid consent request** error, it means the requested role is either incorrect or not granted to the authenticated user.

Invalid consent request error in Snowflake

To resolve this error, run the following statement in Snowflake:

> Important: this statement grants OAuth privileges to all integrations within your Snowflake account. Use it carefully.

```
ALTER ACCOUNT SET OAUTH_ADD_PRIVILEGED_ROLES_TO_BLOCKED_LIST = FALSE;
```

Run the statement to resolve the Invalid consent request error

Now you can use the Snowflake connection in your Albato automations. If you have any questions, contact our support team through the chat in your Albato account.

Did this answer your question?