Create, update, and fetch details from custom SQL models.
RudderStack’s Models feature lets you create models by defining custom SQL queries. You can then run these queries on your warehouse and send the resulting data to specific destinations. You can create as many models and reuse them with their corresponding Reverse ETL sources.
With this feature, you can:
Build models with complex SQL queries via an intuitive UI.
Manage views of all models synced to different destinations in one place.
Set up a reverse ETL source by going to Collect > Sources. Select the warehouse used to create the model.
Under Source type, specify Model and configure the rest of the settings.
Connect the reverse ETL source to your destination. Configure the destination settings and click Continue.
In the Data Mapping section, select the model created in step 1 in from the dropdown.
Follow the steps listed in the Importing data using models guide for configuration settings required to import and sync data from this model.
What do the three validations under Verifying Credentials imply?
Once you proceed after entering the connection credentials, you will see the following validations under the Verifying Credentials option:
These options are explained below:
Verifying Connection: Indicates that RudderStack is trying to connect to the warehouse with the information specified in the connection credentials.
If this option gives an error, it means that one or more fields specified in the connection credentials are incorrect. Verify your credentials in this case.
Able to List Schema: Checks if RudderStack is able to fetch all schema details using the provided credentials.
Able to Access RudderStack Schema: Checks if RudderStack has the required access to the _RUDDERSTACK schema. To create the schema, run all commands listed in the Permissions section of the respective Reverse ETL source documentation:
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.