Calendars
This table has 1 row per calendar and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| AUTH_ID | Variant | An optional ID used by the connection provider. | ||
| AUTH_PROVIDER | Varchar | The connection provider. | 'google_oauth2' | |
| 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. | |
| CONFERENCE_URL | Varchar | The calendar's personal meeting url. | ||
| CREATED_AT | Timestamp_NTZ | The time this calendar record was last updated in Outreach. | ||
| CREATOR_ID | Varchar | The ID for whomever created a record in Outreach, or who updated it if records are overwritten when changed. Maps to different tables based on the "creator_type" field. | ||
| 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 calendar email address. | |||
| ID | Varchar | An ID for the unique calendar | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| LAST_EVENT_UPDATED_AT | Timestamp_NTZ | The last time an event in this calendar was updated. | ||
| LAST_SYNCED_AT | Timestamp_NTZ | The last time this calendar was synced. | ||
| 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 | |
| PROVIDER_ID | Variant | The name of the connection provider. | ||
| PROVIDER_TYPE | Variant | The type of connection provider. | ||
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | ||
| SYNC_ERROR | Varchar | A description of the sync error. | 'Google service credentials missing or incorrect. Please re-authorize and try again.' | |
| SYNC_ERRORED_AT | Timestamp_NTZ | The last time an error was encountered during sync. | ||
| 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. |
| UPDATER_ID | Varchar | Same as creator_id above, but refers to who last did the update of the record. | ||
| USER_ID | Varchar | The ID of the user associated with this calendar. | Maps to the USERS table |