When defining models, you'll write SQL queries to select the data you want to see in Sailthru. This can be as simple as selecting everything in a specific database table or as complex as creating new calculated values.
From inside your Census account, navigate to the Models page.
Enter a name for your model. You'll use this to select the model later.
Enter your SQL query. If you want to test the query, use the Preview button.
Click Save Model.
You can also use dbt, Looker, or Segments as other source models. And you can also use a Warehouse Table/View.
Step 4: Create your first sync
The sync will move data from your warehouse to Sailthru. In this step, you'll define how that will work.
From inside your Census account, navigate to the Syncs page and click Add Sync.
Under What data do you want to sync?, choose your data warehouse as the Connection and your model as the Source.
Under Where do you want to sync data to?, choose Sailthru as the Connection and an Object from the Sailthru Supported Objects.