Reverse ETL Sources

RudderStack’s Reverse ETL feature lets you use the customer data residing in your data warehouse and route it to your entire data stack, including analytics, sales, and marketing tools.

With this feature, you can set up your data warehouse as a source in the RudderStack dashboard, specify the data to import, then sync it to your desired destination.

You can set up to 10 connections in the RudderStack Free and Starter plan and unlimited connections in the Growth and Enterprise plans.

Supported Reverse ETL Sources

Amazon Redshift

Amazon S3

Databricks

Google BigQuery

MySQL

PostgreSQL

Snowflake

Trino

Required permissions

• Admins have full access to create and manage Reverse ETL sources created via warehouse tables, SQL Models, and Audiences.
• Members can have the following permissions depending on their workspace policy:

To make a connection, that is, connect a source to a destination, the member must have both Edit and Connect permissions on both the resources.

Click here to see how these permissions appear in the workspace policy.

Permissions for legacy RBAC system

In the legacy Permissions Management (RBAC) system:

• Org Admins and members with the Connections Admin role in their workspace policy can create and delete Reverse ETL sources, and connect them to destinations
• Members with the Connections Editor role in their workspace policy can only edit the Reverse ETL source configuration and connect Reverse ETL sources to destinations

FAQ

For answers to commonly asked questions around the Reverse ETL feature, see FAQ.