version: 2

sources:
  - name: sailthru
    tables:
      - name: campaign_sends
        columns:
          - name: event_id
            data_type: string
          - name: message_id
            data_type: string
          - name: campaign_id
            data_type: string
          - name: event_time
            data_type: timestamp
          - name: profile_id
            data_type: string
          - name: list_name
            data_type: string
          - name: subject
            data_type: string

      - name: campaign_opens
        columns:
          - name: event_id
            data_type: string
          - name: message_id
            data_type: string
          - name: campaign_id
            data_type: string
          - name: event_time
            data_type: timestamp
          - name: profile_id
            data_type: string
          - name: list_id
            data_type: string
          - name: is_real_open
            data_type: string

      - name: campaign_clicks
        columns:
          - name: event_id
            data_type: string
          - name: message_id
            data_type: string
          - name: campaign_id
            data_type: string
          - name: event_time
            data_type: timestamp
          - name: profile_id
            data_type: string
          - name: list_id
            data_type: string
          - name: is_real_click
            data_type: string

      - name: triggered_sends
        columns:
          - name: message_id
            data_type: string
          - name: event_id
            data_type: string
          - name: template_id
            data_type: string
          - name: event_time
            data_type: timestamp
          - name: profile_id
            data_type: string
          - name: flow_id
            data_type: string

      - name: triggered_opens
        columns:
          - name: message_id
            data_type: string
          - name: event_id
            data_type: string
          - name: template_id
            data_type: string
          - name: event_time
            data_type: timestamp
          - name: profile_id
            data_type: string
          - name: flow_id
            data_type: string
          - name: is_real_open
            data_type: string

      - name: triggered_clicks
        columns:
          - name: message_id
            data_type: string
          - name: client_id
            data_type: integer
          - name: event_id
            data_type: string
          - name: template_id
            data_type: string
          - name: event_time
            data_type: timestamp
          - name: profile_id
            data_type: string
          - name: signup_time
            data_type: timestamp
          - name: flow_id
            data_type: string
          - name: is_real_click
            data_type: string

      - name: triggered_bounces
        columns:
          - name: message_id
            data_type: string
          - name: event_id
            data_type: string
          - name: template_id
            data_type: string
          - name: event_time
            data_type: timestamp
          - name: profile_id
            data_type: string
          - name: reason_log
            data_type: string

      - name: campaigns
        columns:
          - name: campaign_id
            data_type: string
          - name: template_id
            data_type: integer
          - name: name
            data_type: string
          - name: list_name
            data_type: string

      - name: lifecycle_optimizer_flow
        columns:
          - name: flow_id
            data_type: string
          - name: name
            data_type: string
          - name: create_time
            data_type: timestamp
          - name: modify_time
            data_type: timestamp
          - name: version
            data_type: string
          - name: client_id
            data_type: integer