FCT_CONTENT_EVENT_SERVICE_WAITLISTS is related to Events within the platform. This specific dataset provides a list of all users who are/were on a waitlist for an event. The table can be joined to DIM_CONTENT_SERVICE_CONTENTS on Event ID to Content ID, many to 1, to show the event/content title. It can also be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users are on or have been on a waitlist
.png?sv=2022-11-02&spr=https&st=2026-01-30T19%3A13%3A12Z&se=2026-01-30T19%3A24%3A12Z&sr=c&sp=r&sig=r2s0kLVhoj4LWLvkhh9WEOfiniyIGybU8aiIqMpofP8%3D)
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Availability Notified At | TIMESTAMP_NTZ(9) | Timestamp showing when the user was notificed of availability for the event | 2025-01-01 | |
Created At | TIMESTAMP_NTZ(9) | Timestamp to show when this waitlist record was created | 2025-01-01T00:00:00.000+0000 | |
Days On Waitlist | NUMBER(9,0) | The number of days between created at and either when availability was notified for registered and cancelled status if it exists or updated at. For active waitlists this is the number of days between created at and today | 5 | |
Doc Created At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Doc Updated At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Event ID | VARCHAR(16777216) | Identifier for the event (content) | 123a12b3cd4e5f67g890h1ij | |
Is Active Waitlist Entry | NUMBER(1,0) | Will show 0 if the status is registered or cancelled else 1 | 0, 1 | 1 |
Status | VARCHAR(16777216) | Status of the waitlist entry - registered (user is now registered on an event), cancelled (user has cancelled their waitlist entry), active (user is on a waitlist currently for an event) | registered, cancelled, active | active |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Timestamp to show when this waitlist record was last updated | 2025-01-01T00:00:00.000+0000 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij | |
Waitlist ID | VARCHAR(16777216) | Identifier for the waitlist entry | 123a12b3cd4e5f67g890h1ij |