Snowflake Integration Guide

STEP 1

Login to Snowflake Account

Ensure you have access to your Snowflake account and login with your credentials.

STEP 2

Open a New Worksheet

Navigate to Snowflake's worksheet interface to begin the integration process.

STEP 3

Alter User Default Role to SysAdmin

Query 1

ALTER USER <username>SET DEFAULT_ROLE = SYSADMIN;

STEP 4

Create Security Integration

Query 2

CREATE SECURITY INTEGRATION
demo_integration
TYPE = OAUTH
enabled = true
OAUTH_CLIENT = custom
OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
OAUTH_REDIRECT_URI = 'https://joveo.success4.us/v1/api/data-feed/oauth/'
OAUTH_ISSUE_REFRESH_TOKENS = TRUE
OAUTH_REFRESH_TOKEN_VALIDITY = 86400;

STEP 5

Describe Security Integration

Query 3

DESCRIBE SECURITY INTEGRATION <name>;

This query will provide detailed information about the created security integration. Save

these details.

STEP 6

Obtain Client Secret

Query 4

select SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('<security_integration_name>');

Execute this query to retrieve the client secret. Keep this information secure.

STEP 7

Data Feed Creation and Consent

Using the obtained details, proceed to create the data feed. Afterward, provide consent by

logging in to the same account from which these steps were followed.Here are the

screenshots for snowflake.