⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_USER_HUB relates to any widgets on a users Hub within the platform. The table can be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users have widgets on their Hub
.png?sv=2026-02-06&spr=https&st=2026-09-06T06%3A40%3A01Z&se=2026-09-06T06%3A51%3A01Z&sr=c&sp=r&sig=d4lYGMnqav%2BZJYlp7daFXTKyk3UsY16mwKiySqmtsns%3D)
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
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 | |
Is Deletable | BOOLEAN | Boolean indicator to show whether this widget can be deleted by the user | TRUE, FALSE | TRUE |
Position | NUMBER(38,0) | Numerical indicator of the widgets position within the users Hub | 1 | |
Provider | VARCHAR(16777216) | The provider of the widget | atlassianjira, bamboohr, github, githubapp, googlecalendar, googlemail, hubspot, microsoftoutlook, microsoftplanner, microsoftteams, thrive, thrive-learning, null | googlemail |
Size | VARCHAR(16777216) | The size of the widget on the users Hub | large, small, tall, wide | wide |
Status | VARCHAR(16777216) | The current status for this widget. An inactive widget is one that appears on a users Hub however it is not connected i.e. googlecalendar. All widgets which do not require specific connections will show as active | active, inactive | active |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Type | VARCHAR(16777216) | The type of widget added | admin link, calendar, crm, email, link, messaging, notes, pull request, task, thrive, timeff, todo | |
User ID | VARCHAR(16777216) | Identifier for the user who has the widget on their Hub | 123a12b3cd4e5f67g890h1ij | |
Widget Created At | TIMESTAMP_NTZ(9) | Datetime the widget was added to the users Hub | 2025-01-01T00:00:00.000+0000 | |
Widget ID | VARCHAR(16777216) | Identifier for the widget | 123a12b3cd4e5f67g890h1ij |