💡 This is a step by step guide to integrate Snowflake and Querio.

Setting Up OAuth2 Integration for Snowflake

Snowflake does not allow direct connections via OAuth2 through an external application. Instead, the user must create an OAuth application within Snowflake and provide the credentials to us. Below are the detailed steps to create and configure this application:

Step 1: Create the OAuth Application in Snowflake

1. Access the Snowflake interface by visiting Snowflake.

2. Navigate to Projects > Worksheets and create a new SQL worksheet.

1. In the worksheet, run the following SQL code to create the OAuth integration:

Setp 2: Retrieve the OAuth Client Credentials

After creating the integration, retrieve the necessary details by running the following commands:

1. Get the client secrets:

2. Describe the security integration:

Step 3: Create a Warehouse

Next, the user needs to create a warehouse in Snowflake. Run the following SQL commands:

CREATE WAREHOUSE querio_warehouse
  WITH WAREHOUSE_SIZE = 'X-SMALL'
  AUTO_SUSPEND = 300
  AUTO_RESUME = TRUE;

GRANT USAGE ON WAREHOUSE querio_warehouse TO ROLE SYSADMIN;
GRANT OPERATE ON WAREHOUSE querio_warehouse TO ROLE

Note: These commands grant the SYSADMIN role access to the warehouse. If a custom role is preferred, it should be based on the SYSADMIN role.

Please provide us with the name of the role as it is required for our application setup.

Step 4: Obtain the Snowflake Account ID

Finally, the user needs to copy the Snowflake account ID. Follow the instructions in the image below to retrieve it:

Final Steps

Once all the steps above are completed, the user has successfully set up the integration for our application.

Step 5: Completing the Setup in Querio Admin Panel

After receiving the required information from the user, we will complete the integration in our Querio admin panel:

1. Go to the Connect Snowflake section.

2. Fill in the details provided by the user.

3. Click Connect. You will be redirected to Snowflake.

At this point, copy the URL and send it to the user. The user will need to:

1. Log in using the Snowflake credentials.

2. Select the database, the Querio warehouse, and the schema they wish to connect.

After these selections, the preprocessing engine will generate the base metadata, and the setup will be complete.