---
title: How to Configure Snowflake
description: Read the article and follow the step-by-step instructions for configuring Snowflake with Intentwise Analytics Cloud
---

[Skip to content](https://help.intentwise.com/configure-snowflake#main-content)

![footer-logo.png\]](https://help.intentwise.com/hs-fs/hubfs/footer-logo.png?width=210&height=40&name=footer-logo.png)

Open main navigation

Close main navigation

 Advice and answers from Intentwise

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.intentwise.com/?hsLang=en)
2. [Intentwise Analytics Cloud](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en)
3. [Configuring Data Pipeline](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-data-pipeline)

# How to Configure Snowflake

## Learn how to configure Snowflake with Intentwise Analytics Cloud by following this step-by-step guide.

### Steps for configuring Snowflake

Follow these steps to set up a Snowflake destination: 

1. Create a new database in Snowflake.
2. Connect to the database using any Snowflake-supported SQL editors and execute the queries mentioned in steps #3, #4, #5, & #6 by replacing the below placeholders with the appropriate values:

     - Replace \<DATABASE\> placeholder with the name created in step #1
     - Replace \<WAREHOUSE\> placeholder with the compute warehouse available in the Snowflake dashboard/console under Admin \> Warehouse.

   Feel free to reach out to us at help@intentwise.com if you run into any issues or if you have any questions.
3. Now, create a new user & role, and assign this new role to the new user

   **USE** **ROLE** accountadmin;   
   ​**CREATE** **ROLE** intentwise;   
   ​**CREATE** **USER** intentwise DEFAULT\_ROLE = intentwise;   
   ​**GRANT** **ROLE** intentwise **TO** **USER** intentwise
4. Next step is genrating a private key. To start, open a terminal window and generate a private key.
   
   **Generate Private Key**
   
   You can generate either an encrypted version of the private key or an unencrypted version of the private key.
   
     - To generate an unencrypted version, use the following command:
   
   openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa\_key.p8 -nocrypt
   
     - To generate an encrypted version, use the following command, which omits `-nocrypt`:
   
   openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out rsa\_key.p8
   
   The commands generate a private key in PEM format and will look like below
   
   -----BEGIN ENCRYPTED PRIVATE KEY-----  
   MIIE6T...  
   -----END ENCRYPTED PRIVATE KEY-----
   
   **Generate Public Key**
   
     - From the command line, generate the public key by referencing the private key. The following command assumes the private key is encrypted and contained in the file named `rsa_key.p8`.
   
   openssl rsa -in rsa\_key.p8 -pubout -out rsa\_key.pub
   
     - The command generates the public key in PEM format.
   
   -----BEGIN PUBLIC KEY-----  
   MIIBIj...  
   -----END PUBLIC KEY-----
   
   **Store the private and public keys securely**  
   Copy the public and private key files to a local directory for storage. The file should still be protected from unauthorized access using the file permission mechanism provided by your operating system. It is your responsibility to secure the file when it is not being used.
   
   **Assign the public key to a Snowflake user**  
   Execute an [ALTER USER](https://docs.snowflake.com/en/sql-reference/sql/alter-user) command to assign the public key to a Snowflake user.
   
   ALTER USER example\_user SET RSA\_PUBLIC\_KEY='\<PUBLIC KEY\>';
   
   Note:
   
     - Only owners of a user, or users with the SECURITYADMIN role or higher can alter a user. For more information, see [Overview of Access Control](https://docs.snowflake.com/en/user-guide/security-access-control-overview) and [GRANT OWNERSHIP](https://docs.snowflake.com/en/sql-reference/sql/grant-ownership)
     - Exclude the public key delimiters in the SQL statement.

 

 

1. Next, create the schemas in the database

   **CREATE** **SCHEMA** "amazon\_source\_data";  
   ​**CREATE** **SCHEMA** "intentwise\_ecommerce\_graph";

   ​**CREATE** **SCHEMA** "amazon\_marketing\_cloud" (*recommended if you are currently using or intend to use Amazon Marketing Cloud*)  
   ​**CREATE** **SCHEMA** "criteo\_source\_data" (*recommended if you are currently using or intend to use Criteo*)  
   ​**CREATE** **SCHEMA** "instacart\_source\_data" (*recommended if you are currently using or intend to use Instacart*)  
   ​**CREATE** **SCHEMA** "walmart\_source\_data" (*recommended if you are currently using or intend to use Walmart*)

   ​*Please run the following statements for each database you’d like intentwise to access:*
2. Execute the below queries to grant access, create, and all privileges to intentwise user to perform changes on the schema and associated tables

   **GRANT** **USAGE** **ON** **DATABASE** "\<DATABASE\>" **TO** **ROLE** intentwise;  
   ​**GRANT** **CREATE** **SCHEMA** **ON** **DATABASE** "\<DATABASE\>" **TO** **ROLE** intentwise;  
   ​**GRANT** **ALL** **ON** **SCHEMA** "intentwise\_ecommerce\_graph" **TO** **ROLE** intentwise;  
   ​**GRANT** **ALL** **ON** **SCHEMA** "amazon\_source\_data" **TO** **ROLE** intentwise;   
   ​**GRANT** **ALL** **ON** **SCHEMA** **public** **TO** **ROLE** intentwise;  
   ​**GRANT** **ALL** **ON** **ALL** **TABLES** **IN** **SCHEMA** "\<DATABASE\>"."intentwise\_ecommerce\_graph" **TO** **ROLE** intentwise;   
   ​**GRANT** **ALL** **ON** **ALL** **TABLES** **IN** **SCHEMA** "\<DATABASE\>"."amazon\_source\_data" **TO** **ROLE** intentwise;  
   ​  
   ​*Please run the following statements for each warehouse you’d like intentwise to use:*
3. Execute the query below to allow intentwise to use a WAREHOUSE

   **GRANT** **ALL** **ON** **WAREHOUSE** "\<WAREHOUSE\>" **TO** intentwise;
4. Now, login to the Intentwise platform and navigate to **My Connections** under **Foundation.** Clickon **"+ Add Destination",** choose **Snowflake** as the destination,and **click Next.![](https://help.intentwise.com/hs-fs/hubfs/image-png-Jun-30-2026-01-02-03-5617-PM.png?width=670&height=415&name=image-png-Jun-30-2026-01-02-03-5617-PM.png)**
5. Enter the **Account Name, Username, Private Key, Pass Phrase (optional), Database Name, Warehouse, Region,** and click on **Save**.

   ![image](https://help.intentwise.com/hs-fs/hubfs/Knowledge%20Base%20Import/image.png?width=655&height=632&name=image.png)
   
     - Account Name field value here corresponds to the 'Locator' value. You will be able to find the 'Locator' details under Admin \> Accounts in the Snowflake console.

   ![](https://downloads.intercomcdn.com/i/o/713892414/cd7f4c48e2657f91479bc8fc/image.png?expires=1739358900&signature=ef0173b41950255309325c7cbdb322cf13c1d5cb213841e165e028b8d7b4cfff&req=cyEkHsB8mYBbFb4f3HP0gLHTeaau3yEMgQhvvyAYG6j3SRsagsmzbyE94oJb%0AXQ8%3D%0A)
   
     - Username and Database field values here correspond to the ones you created in Steps #1 & #3 above

     - Warehouse field values corresponds to the Warehouse name in Snowflake and it can be found in Admin \> Warehouses in the Snowflake console.

   ![](https://downloads.intercomcdn.com/i/o/711999611/5b05e38f0f559ed8185a75cb/image.png?expires=1739358900&signature=2f41043a2ac294b3423ce2168328648778427faa80ea906794f640862d71d08a&req=cyEmH8B3m4BeFb4f3HP0gHFyT7OqgrC6%2FRN575lGnCKRVXq2%2FoKuEaX9xsoO%0AZB0%3D%0A)
   
     - Finally, 'Region' field value is a combination of the 'Cloud' and 'Region' values (Joined using Hyphen '-' ) in the Snowflake console. For example: If Cloud = AWS and Region = US West (Oregon), then Intentwise Region field value = AWS-US West (Oregon)  
       ​  
       You will be able to find the 'Cloud' & 'Region' details under Admin \> Accounts in the Snowflake console.

    
   
   ![](https://downloads.intercomcdn.com/i/o/713892853/a40c2fdbb5b8a805d3990c6b/image.png?expires=1739358900&signature=7d59632e9111f9f8a0358d784233d66713318fd7dc3361f3c8463ee175ebe9dc&req=cyEkHsB8lYRcFb4f3HP0gLn%2FYi7PITEGVK3LuhWHgHsj904y5Um8CAz6urD9%0AZI0%3D%0A)
6. On successful completion, you will see this message: 

   ![](https://downloads.intercomcdn.com/i/o/572916658/f49212af7018736ab2674a5e/Screenshot+2022-09-01+at+5.39.36+PM.png?expires=1739358900&signature=628cb5d69af002fbbaf89584a099bf867afd5af7944f0a76ec1de09d39a5b6d7&req=cSclH8h4m4RXFb4f3HP0gDcMcyBxTcvsetNhjD2cuI6CIB160SHuecC20SIR%0AqLw%3D%0A)
7. For any further questions on the pipeline setup, please reach out to us on *chat* or at help@intentwise.com.

- [Getting started](https://help.intentwise.com/getting-started?hsLang=en)
- [Intentwise AI Gateway](https://help.intentwise.com/intentwise-ai-gateway?hsLang=en)
- [Intentwise Ad Optimizer](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#main-content)

    - [Account and Campaign Setup](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#account-and-campaign-setup)
    - [Optimization](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#optimization)
    - [Reporting](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#reporting)
    - [Dashboard Overview](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#dashboard-overview)
    - [Resources](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#resources)
    - [Amazon DSP](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#amazon-dsp)
    - [Additional Features](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#additional-features)
    - [Walmart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#walmart)
    - [Criteo](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#criteo)
    - [Instacart](https://help.intentwise.com/intentwise-ad-optimizer?hsLang=en#instacart)
- [Intentwise Explore (AMC)](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#main-content)

    - [AMC](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#amc)
    - [Instructional Queries](https://help.intentwise.com/intentwise-explore-amc?hsLang=en#instructional-queries)
- [Intentwise Analytics Cloud](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#main-content)

    - [Kickstart Guide](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#kickstart-guide)
    - [Configuring Reporting Tools](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-reporting-tools)
    - [Configuring Data Pipeline](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#configuring-data-pipeline)
    - [Data Sources](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#data-sources)
    - [Looker (Google Data) Studio Tutorials](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#looker-google-data-studio-tutorials)
    - [Intentwise Templates](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-templates)
    - [Intentwise Analytics Cloud features](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#intentwise-analytics-cloud-features)
    - [White Label](https://help.intentwise.com/intentwise-analytics-cloud?hsLang=en#white-label)
- [Intentwise Marketplace Intelligence](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#main-content)

    - [Content Analytics (CA)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#content-analytics-ca)
    - [Share Of Voice (SOV)](https://help.intentwise.com/intentwise-marketplace-intelligence?hsLang=en#share-of-voice-sov)
- [Frequently Asked Questions (FAQs)](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#main-content)

    - [Access and Setup](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#access-and-setup)
    - [Billing](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#billing)
    - [Platform](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#platform)
    - [Reporting](https://help.intentwise.com/frequently-asked-questions-faqs?hsLang=en#reporting)

intentwise.com Help Center

Copyright © 2026, Intentwise Inc.