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.