How to Connect Snowflake to Albato Using OAuth2

How to Connect Snowflake to Albato Using OAuth2
4/14/2025
·
3 min. read

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')
  
  1. After running the code, copy the generated Client ID value.

snofwflake7.png

  1. Then, paste your code into the Client ID field.

snowflake8.png

  1. Next, copy the value of “OAUTH_CLIENT_T_SECRET” from your Oauth application.

snoflake9.png

  1. Paste it into the Client secret field.

snoflake10.png

  1. Click Continue to proceed with the setup.

snoflake11.png

  1. Tap the Grant the access button to give access.

snoflake12.png

  1. A new pop-up window appears when you click this button. Sign in to your Snowflake account.

snowflakepopup.png

  1. Finally, click the Allow button to access your data in Snowflake.

snoflakeallowaccess.png

That's it! Now you can create automations with Snowflake in Albato.

  

Errors and solutions

The "Invalid consent request" error indicates that the requested role is either incorrect or has not been granted to the authenticated user.

snowflake16.png

To resolve this issue, run the following statement to your code:

ALTER ACCOUNT SET OAUTH_ADD_PRIVILEGED_ROLES_TO_BLOCKED_LIST = FALSE;

snoflake17.png

Caution: This command grants OAuth privileges to all integrations in your Snowflake account. Use it only if you fully understand the implications and truly need it. Use with care — only when clearly justified by your needs.

If you have any troubles relating to Snowflake connection despite following these guidelines, please contact Albato support through the live chat on our website, and we'll be sure to assist you.

  

About Snowflake

Snowflake enables organizations to collaborate, build AI-powered data apps, and unlock data insights—all within a secure and scalable AI Data Cloud.

With Snowflake, businesses can:

  • Consolidate data from multiple sources into a single source of truth.
  • Run powerful analytics without investing in complex infrastructure.
  • Ensure data security and manage user access with precision.
  • Scale flexibly as the business grows.

Related articles

Show more
How to Connect FormCan to Albato
3 min. read

How to Connect FormCan to Albato

By connecting FormCam to Albato, you can streamline data flows from form submissions to your favorite business apps.

Chatfuel Cuts Churn by 25% and Integration Time by 80% with Albato Embedded
Press Releases
3 min. read

Chatfuel Cuts Churn by 25% and Integration Time by 80% with Albato Embedded

Chatfuel, a leading US-based B2B messaging platform with AI agents, has partnered with Albato Embedded to deliver seamless native integrations, significantly improving user experience and operational efficiency.

Model Context Protocol: Understanding the Future of Automations
7 min. read

Model Context Protocol: Understanding the Future of Automations

In this article, you will learn how Model Context Protocol helps connect AI tools, data sources, and workflows across SaaS apps—no code required.

How to Connect to Care. With Albato
3 min. read

How to Connect to Care. With Albato

By utilizing both Care. and Albato, you can automate routine tasks like job post updates, applicant tracking, and communication management—saving time and reducing manual effort.

How to Connect Keen to Albato
3 min. read

How to Connect Keen to Albato

Here’s a simple guide to help you connect Keen with Albato and automate your lead management workflows.

VoiceDrop and Albato Join Forces to Enhance Ringless Voicemail Integrations
Press Releases
3 min. read

VoiceDrop and Albato Join Forces to Enhance Ringless Voicemail Integrations

VoiceDrop, the #1 fastest-growing AI-powered ringless voicemail platform, has partnered with Albato Embedded to offer native, customer-facing integrations directly within their platform.

How to Connect Drip to Albato
3 min. read

How to Connect Drip to Albato

Create integrations with Drip in Albato to automate email marketing, personalize customer journeys, and keep your contact data in sync.

How to Connect OneDrive to Albato
3 min. read

How to Connect OneDrive to Albato

By connecting OneDrive to Albato, you can automate file organization, synchronize data across applications, and optimize your workflows.

How to Connnect to Forms.app via Webhook
3 min. read

How to Connnect to Forms.app via Webhook

Create integrations with Forms.app in Albato to automate form submissions, streamline response management, and connect your form data with the tools you already use.

Enterprise AI Strategy: Practical Ways to Integrate AI into Your Workflows
10 min. read

Enterprise AI Strategy: Practical Ways to Integrate AI into Your Workflows

Discover best practices for building a successful enterprise AI strategy and see how Albato can help you in this process.

Want to Learn Automation Tricks?
2 min. read

Want to Learn Automation Tricks?

Explore what’s new in Albato: features, apps, and improvements

How to Connect Apollo to Albato
3 min. read

How to Connect Apollo to Albato

Create integrations with Apollo in Albato to automate lead generation, streamline contact management.