example.yml

example.yml

in:
  type: td
  apikey: xxxxx
  endpoint: api.treasuredata.com
  database: zendesk
  query: |
    SELECT
      id,  -- Zendesk UserID
      MAP_CONCAT(
        MAP(ARRAY[cast('sfdc_company_name' AS VARCHAR)], ARRAY[cast(sfdc_company_name AS VARCHAR)]),
        MAP(ARRAY[cast('sfdc_subscription_status' AS VARCHAR)], ARRAY[cast(sfdc_subscription_status AS VARCHAR)]),
        ...
      )
    FROM xxxx LEFT JOIN yyyy ON xxxx.email = yyyy.email
out:
  type: zendesk_users
  login_url: https://xxxxx.zendesk.com
  auth_method: token
  username: xxxxx
  token: xxxxx
  method: update
  id_column: id
  user_fields_column: user_fields