dbt Destination Config

The config property for a destination object varies for each type of destination.

Webhook

config:
subscribeAdd: true
subscribeChange: false
subscribeDelete: false
mappings:
- from: id
to: id
- from: email
to: email
- from: first_name
to: firstName
- from: last_name
to: lastName

Where subscribeAdd, subcribeChange, and subscribeDelete define when the sync results should deliver data to the destination.

And where mappings is an array of from and to properties defining field mapping transformations.

Slack

config:
format: message|table|csv
channel: C01FA3A40LW
addedBody: "Added things"
removedBody: "Removed things"

Where format define how the update is sent to Slack (either as a message, table, or csv).

And where channel is the ID of the Slack channel to send the updates to.

If the value format is message then you must include addedBody and optionally removedBody.

Iterable

config:
emailFrom: email
userIdFrom: id
mappings:
- from: id
to: id
- from: email
to: email
- from: first_name
to: firstName
- from: last_name
to: lastName

Where emailFrom defines which column references the name of the column on the Hightouch query that will map to the email field for in Iterable. This is used as the primary key in Iterable.

And where userIdFrom is an optional field defining which column will map to the userId field in Iterable.

mappings is an array of from and to properties defining field mapping transformations.

Google Sheets

config:
spreadsheetURL: https://docs.google.com/spreadsheets/d/1iH7r9crb3btOuO1y_NUPa1xvXAY6XlQ8Qc1hxhnSmQ8
sheetName: Sheet 1

Where spreadsheetURL is the url to the Google Sheet and where sheetName is the name of the sheet within the spreadsheet.