Open your Snowflake instance.

In Snowflake, enter the following query to create the security integration object:

CREATE OR REPLACE SECURITY INTEGRATION <name>
  TYPE=OAUTH
  OAUTH_CLIENT=CUSTOM
  OAUTH_REDIRECT_URI='<redirect URI>' 
  OAUTH_CLIENT_TYPE='CONFIDENTIAL'
  OAUTH_REFRESH_TOKEN_VALIDITY = <1 ~ 90 days in seconds>
  OAUTH_ISSUE_REFRESH_TOKENS=TRUE
  ENABLED=TRUE;

1. Replace the following variables with the correct information for your instance:

   Table 20. Snowflake OAuth variables

   Variable	Description
   Name	Enter the name of the security integration.
   Redirect URI	Enter the import redirect URI of the Varicent ELT application. For NA: https://app.symon.ai/importRedirect For EU: https://eu.symon.ai/importRedirect
   OAUTH_REFRESH_TOKEN_VALIDITY	Enter the integer that specifies how long the refresh token is valid for in seconds. This value is used to expire the refresh token periodically.

   
   
   

Learn more about creating a security integration.

Enter the following query to get the client id and secret:

SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('<security integration name in capital letters>');

This query returns values for OAUTH_CLIENT_ID, OAUTH_CLIENT_SECRET, OAUTH_CLIENT_SECRET_2. You can use either OAUTH_CLIENT_SECRET or OAUTH_CLIENT_SERCRET_2 as your client secret.

In Varicent ELT, go to the Data tab.

Click Import data.

In the Third party sources section, click Snowflake.

Click New connection.

On the Connect to your Database page, enter the following information to connect:

Click Next.

If you want use Storage integration, you must create or replace your storage integration in Snowflake. For more information, see: Snowflake storage integration.

On the Select data page, in the Directory field, select the directory for the data set. Click Next.

For data imports with high performance, switch the toggle on to import using S3 unload.

On the Import data page, review your data and select the data to obfuscate (if any). Click Next.

On the Filter data page, optionally click Filter data to refine your data, or click Import data to continue.

1. Filter the rows in your data by selecting the column to filter, the filter category and the value or text.

2. Click Import data to continue.

On the Review page, review the data sets that you are importing.

Click Import data.