Amazon Redshift is a fully managed petabyte-scale data warehouse service in the cloud designed for large scale data set storage and analysis. Redshift’s column-oriented database is designed to connect to SQL-based clients and business intelligence tools, making data available to users in real time.
Electrik.AI exports data from your marketing data source to a database / data warehouse destination of your choice. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI
Do you not have an Amazon Redshift account? Refer this link.
Step 1: Ensure you have following prerequisites to create an Amazon Redshift Connection in Electrik.AI
1. Data Warehouse Connection Details such as Host, Port, DB Name, Username, Password.
Step 2: Signup for your Electrik.AI account.
Step 3: Sign-in into your Electrik.AI account.
Step 4: Select IO in Electrik.AI dashboard.
Step 5: Select the Connections Icon in the left most panel and click on “Add” button the top.
Step 6: Click on Destination tab and choose “Amazon Redshift” connection.
Step 7: Enter Amazon Redshift data warehouse connection details and click on “Save”.
Congratulations you have successfully created Amazon Redshift connection in Electrik.AI