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.
-
Before setting up automations with Snowflake connect the app to Albato. Sign in to your Albato account.
-
Go to the Apps section and click the Add a connection button.
- Search for Snowflake and select it. Click the Add a connection button.
- Create a name for your connection.
- Copy your Snowflake account name from your browser's address bar and paste it into the Account name field.
- 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')
- After running the code, copy the generated Client ID value.
- Then, paste your code into the Client ID field.
- Next, copy the value of “OAUTH_CLIENT_T_SECRET” from your Oauth application.
- Paste it into the Client secret field.
- Click Continue to proceed with the setup.
- Tap the Grant the access button to give access.
- A new pop-up window appears when you click this button. Sign in to your Snowflake account.
- Finally, click the Allow button to access your data in Snowflake.
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.
To resolve this issue, run the following statement to your code:
ALTER ACCOUNT SET OAUTH_ADD_PRIVILEGED_ROLES_TO_BLOCKED_LIST = FALSE;
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.
