Steps for configuring Redshift with Intentwise Analytics Cloud
1. Create a new database ‘intentwise' in Redshift
2. If your database is behind the firewall, whitelist the following IP addresses. This is required for the Intentwise data pipeline to access your database
52.25.90.16
52.68.49.96/32
52.26.72.39/32
52.48.81.207/32
54.86.110.101/32
52.64.101.124/32
52.74.180.132/32
18.196.243.206/32
3. Create a new user ‘intentwise_user’ with the <password> in your Redshift database
4. Create the following two new schemas within the database:
amazon_source_data
intentwise_ecommerce_graph
5. Grant read/write permissions for the user created in step #3 by using these queries:
GRANT ALL ON schema amazon_source_data TO intentwise_user;
GRANT ALL ON schema intentwise_ecommerce_graph TO intentwise_user;
6. Now, go to the Intentwise platform and navigate to My Connections under Intentwise Analytics Cloud. Click on "+ Add Destination", choose Redshift as the destination and click Next
7. And enter the Host, Port, Database, User, and Password details and Save
8. On successful completion, you will see the below message:
9. For any further question on the pipeline setup, please email us at [email protected] .