Skip to content
Raise a ticket
  • There are no suggestions because the search field is empty.

How to connect Snowflake using OAuth2

Overview

Snowflake is a cloud-based data platform that helps businesses store, manage, and analyse all their data in one place. By connecting Snowflake to Feefo you can streamline data flows across multiple business apps without manual effort. See how you can get more value from your data with Feefo and Snowflake.

Instructions

  1. Before setting up automations with Snowflake connect the app to Feefo Hub. 

  2. Go to the Integration tab and Integration Hub section and click the Add a connection button.

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

  4. Create a name for your connection.

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

  6. Run the following statement below in the Worksheets section

     

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

     

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

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

  9. Return to Snowflake and copy the Client Secret.

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

  11. Click the Continue button.

  12. Click the Grant Feefo access button.

  13. You will be redirected to Snowflake. Enter your Snowflake Username and Password.

  14. Click the Sign in button.

  15. Click the Allow button to grant access.

Now you can use the Snowflake connection in your Feefo flows.

Troubleshooting Hints

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

.

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

Important: this statement grants OAuth privileges to all integrations within your Snowflake account.

ALTER ACCOUNT SET OAUTH_ADD_PRIVILEGED_ROLES_TO_BLOCKED_LIST = FALSE;

If you have any questions, contact our support team through the chat in your Feefo account.