What do the three validations under Verifying Credentials imply?

When setting up a Reverse ETL source, you will see the following three validations under the Verifying Credentials option once you proceed after entering the warehouse credentials:

Validating credentials

These options are explained below:

  • Verifying Connection: This option indicates that RudderStack is trying to connect to the warehouse with the provided warehouse credentials.
If this option gives an error, it means that one or more fields specified in the warehouse credentials are incorrect. Verify your credentials in this case.
  • Able to List Schema: This option checks if RudderStack is able to fetch all schema details by using the provided credentials.
  • Able to Access RudderStack Schema: This option implies that RudderStack is able to access the _rudderstack schema you have created by running all commands in the User Permissions section.
If this option gives an error, verify if you have successfully created the _rudderstack schema and given RudderStack the required permissions to access it.

What is the difference between the Table, Model, and Audience options when creating a Reverse ETL source?

When creating a new Reverse ETL source, you are presented with the following options from which RudderStack syncs the data:

Source typeDescription
TableRudderStack uses an existing warehouse table as a data source.

See Use warehouse table as source for detailed setup.
ModelRudderStack uses custom SQL queries to fetch specific warehouse data and sends them to your destinations.

See Use model as source for detailed setup.
AudienceRudderStack filters data in your warehouse tables to create target customer lists and sends them to downstream destinations.

See Use audience as source for detailed setup.

Questions? Contact us by email or on Slack