How to Configure Snowflake

Read the article and follow the step-by-step instructions for configuring Snowflake with Intentwise Analytics Cloud

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 <PASSWORD> placeholder with the password of your choice.

   • 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 PASSWORD="<PASSWORD>" DEFAULT_ROLE = intentwise;
   ​GRANT ROLE intentwise TO USER intentwise

4. 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:

5. 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:

6. Execute the below query to allow intentwise to use a WAREHOUSE

   GRANT ALL ON WAREHOUSE "<WAREHOUSE>" TO intentwise;

7. Now, login to the Intentwise platform and navigate to My Connections under Intentwise Analytics Cloud. Click on "+ Add Destination", choose Snowflake as the destination and click Next.

   

8. Enter the Account Name, Username, Password, Database Name, Warehouse, Region, and click on Save.

   

   • Account Name field value here corresponds to 'Locator' value. You will be able to find the 'Locator' details under Admin > Accounts in the Snowflake console.

   

   • Username, Password, 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.

   

   • 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.

    
   
    

9. On successful completion, you will see this message:

   

10. For any further questions on the pipeline setup, please reach out to us on chat or at help@intentwise.com.
    ​