Please follow the step-by-step instructions for setting up Snowflake destination:
1. Create a new database in snowflake.
2. Connect to the database using any Snowflake-supported SQL editors and execute the below queries by replacing the appropriate values as mentioned in the following steps #3, #4 and #5
3. Replace <PASSWORD> with the password of your choice.
4. Replace <DATABASE> with the name created in step #1
5. Replace <WAREHOUSE> with the compute warehouse available in the Snowflake dashboard under Admin > Warehouse.
Feel free to reach out to us at [email protected] if you run into any issues or if you have any questions.
6. Now, Execute the below queries:
USE ROLE accountadmin; -- use this role to be able to grant permissions
CREATE ROLE intentwise; -- create a role to assign to the intentwise user
CREATE USER intentwise PASSWORD=‘<PASSWORD>’ DEFAULT_ROLE = intentwise; -- create a user with a password
GRANT ROLE intentwise TO USER intentwise; -- assign a user to role
CREATE SCHEMA “amazon_source_data”;
CREATE SCHEMA “intentwise_ecommerce_graph”;
-- run the following statements for each database you’d like intentwise to access:
GRANT USAGE ON DATABASE “<DATABASE>” TO ROLE intentwise; -- grant database access to intentwise
GRANT CREATE SCHEMA ON DATABASE “<DATABASE>” TO ROLE intentwise; -- grant schema creation privilege to intentwise
GRANT ALL ON SCHEMA “intentwise_ecommerce_graph” TO ROLE intentwise; -- grant intentwise privileges to do anything within the defined SCHEMA
GRANT ALL ON SCHEMA “amazon_source_data” TO ROLE intentwise; -- grant intentwise privileges to do anything within the defined SCHEMA
GRANT ALL ON SCHEMA public TO ROLE intentwise;
GRANT ALL ON ALL TABLES IN SCHEMA “<DATABASE>“.”intentwise_ecommerce_graph” TO ROLE intentwise; -- grant intentwise privileges to all tables in the SCHEMA
GRANT ALL ON ALL TABLES IN SCHEMA “<DATABASE>“.”amazon_source_data” TO ROLE intentwise;
-- run the following statements for each warehouse you’d like intentwise to use:
GRANT ALL ON WAREHOUSE “<WAREHOUSE>” TO intentwise; -- allow intentwise to use a WAREHOUSE
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.
9. On successful completion, you will see the below message:
