Albato
  • Language
    En
    English
    Portuguese
    Spanish

    • Welcome to Albato Help

    How to Connect Snowflake to Albato Using OAuth2

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

    IN THIS ARTICLE

    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 to your Albato account.

    2. Go to the Apps section and click the Add a connection button.

    Example.png

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

    snowflake3.png

    1. Create a name for your connection.

    snoflake4.png

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

    snowflake5.png

    1. 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'; SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('ALBATO');

    Run the OAuth security integration statement in Snowflake

    1. Snowflake will return the OAuth credentials. Copy the Client ID.

    Copy the Client ID in Snowflake

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

    Paste the Client ID in Albato

    1. Return to Snowflake and copy the Client Secret.

    Copy the Client Secret in Snowflake

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

    Paste the Client Secret in Albato

    1. Click the Continue button.

    Click Continue in Albato

    1. Click the Grant Albato access button.

    Grant Albato access

    1. You will be redirected to Snowflake. Enter your Snowflake Username.

    Enter your Snowflake username

    1. Enter your Password.

    Enter your Snowflake password

    1. Click the Sign in button.

    Sign in to Snowflake

    1. Click the Allow button to grant access.

    Allow access in Snowflake

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