Meeting Attendees
This table has 1 row per meeting attendee, per meeting and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| BENTO | Varchar | A collection of machines that power the Outreach app. Orgs live inside these. | This may distinguish orgs that are in different data centers. | |
| DML_AT | Timestamp_NTZ | A datetime (local to server) in which the row was last modified. dml_at can be used to identify updated and new records, but as tables may not see changed records every day, it is not authoritative on when the table was last synced. | 2019-01-01 12:14:01:10 | Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days. |
| DML_TYPE | Varchar | The type of manipulation that last occurred to a row. | 'update', 'delete', 'insert', 'backfill', 'backfill-delete' | Where dml_type <> 'delete' Excludes deleted rows. |
| Varchar | The email of the event attendee. | |||
| INVITE_RESPONSE | Varchar | The acceptance status of this attendee. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| MEETING_ID | Varchar | The ID of the meeting the attendee was invited to. | ||
| NAME | Varchar | The name of the attendee. | ||
| ORGANIZER | Boolean | Set to true when this attendee is the organizer of the event (from the 3rd party API). | ||
| O_ID | Varchar | Organization ID, also called instance ID. This is the ID for your unique Outreach account. | Most commonly used on joins alongside other primary keys. where a.o_id = b.o_id and a.id = b.a_id | |
| PROSPECT_ID | Varchar | The ID of the attendee if the attendee is a prospect. | This will be null for non prospect attendees. Maps to PROSPECTS table. | |
| UPDATED_AT | Timestamp_NTZ | The UTC datetime for the last time this record was updated. | 2019-01-01 20:14:01:10 | Almost equivalent to dml_at (but adjusted for time zones), but doesn't include record creation or deletion. |
| USER_ID | Varchar | The ID of the attendee if the attendee is an Outreach user. | This will be null for non Outreach user attendees. Maps to USERS table. |