From the left navigation bar, go to Source > New Source > Reverse ETL. Then, select Redshift:
Assign a name to the source.
Configuring the connection credentials
Choose from the Table or Model option to sync data from either a warehouse table or a model.
For more information on the Table and Model options, refer to the FAQ section.
If you chose the Model option, skip the next steps and refer to the Schedule settings section directly.
Enter the relevant settings in the Connection Credentials section as listed below:
Host: Enter the host name of your Redshift service.
Port: Enter the port number associated with the Redshift database instance.
Database: Enter the database name in your Redshift instance where RudderStack should send the data.
User: Enter the user name of your Redshift cluster created in Step 5 of this section.
Password: Enter the password for the above user.
SSL Mode: Select the SSL mode as disable or require depending on how RudderStack should connect to your Redshift instance.
If you have already configured a destination in RudderStack, choose the Use Existing Destination option which will take you to the Schema tab in the source settings. To add a new destination from scratch, select the Create New Destination option which will take you to the destination configuration page.
Specifying the data to import
While connecting a destination to your Reverse ETL source, you can use the default JSON mapping or the Visual Data Mapping feature.
Based on the option(Table/Model) you chose while setting up the Reverse ETL source, follow the relevant guide for detailed steps:
cookies, the cookies that are categorized as necessary are stored on your browser as they are as
for the working of basic functionalities of the website. We also use third-party cookies that
analyze and understand how you use this website. These cookies will be stored in your browser
consent. You also have the option to opt-out of these cookies. But opting out of some of these
have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This
category only includes cookies that ensures basic functionalities and security
features of the website. These cookies do not store any personal information.
learn more about cookies and why we use them, visit our cookie
policy. We'll assume you're ok with this, but you can opt-out if you wish Cookie Settings.