Setting up Snowflake OAuth
Last updated
Last updated
This section outlines the steps required to create an integration and use OAuth to connect to Snowflake.
Whitelist Inforiver IPs in the Azure SQL firewall. .
For Saas customers, should be whitelisted in the firewall so the application can reach the server configured.
STEP 1: Use the ACCOUNTADMIN role to log in to the Snowflake web interface. Navigate to Projects -> Worksheets -> Click the Add icon at the top left -> Select SQL worksheet.
STEP 2: Create an OAuth Security Integration by executing the query:
STEP 3: Fetch details for client configuration. You will need to enter these details while creating a Snowflake destination or connection in Inforiver.
Retrieve the Client ID and Client secret:
Get the Authorization and Token URL:
You will be redirected to the Snowflake login page, where you need to enter your Username and Password to connect.
After specifying the integration details for OAuth and signing into Snowflake, you will need to enter details in the section highlighted in the image:
Account: Enter the name of your Snowflake server. Example: https://<account>.snowflakecomputing.com/
Database and Schema: Snowflake Database and schema name where the writeback table will be created.
Warehouse: The Snowflake compute warehouse.
Role: The user role associated with the Snowflake username. Ensure this role has “USAGE” and “CREATE TABLE” permissions. This is mandatory to be able to writeback from Inforiver to Snowflake.
STEP 1: Enter the Integration Name, Client ID, Client Secret, Authorization URL, and Token URL required for OAuth in the Inforiver console. Refer to the to learn more about fetching the integration details from Snowflake. Click Connect.