The last step is to setup a sync. Click on Syncs and then pick the model you created in Step 3.Next, pick a destination. Depending on your destination you will have different options to configure.For Google Sheets, we mirror data from the source to the sheet. Just select the Google Sheet we created in Step 2.The Slack destination lets you pick a channel and message format. Below, we set a simple message for the channel. For Slack, we only update on changes, so your channel won't be flooded with every row in your model.Hubspot, for example, provides options for updating or upserting (inserting new records and updating existing records). For Hubspot, we'll need to map the fields from our Source to our Destination.
This configuration is specific to each destination that the query results are being sent to. This particular configuration will upsert the Hubspot object contacts for each row in the query of users, and map id, name, and email to id, lastname, and email respectively.For more information on the configuration of each destination, check out the Destinations section of the documentationLastly, we have to schedule how often the query is run and subsequently synced to your destinations.You can pick a recurring interval, manual interval, or even setup a sync with dbt. In our case, we picked a 1 hour interval.
Not all fields have to be mapped! If you leave certain mappings empty, the fields simply wont be synced to the object created in Hubspot.