⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_USER_HUB relates to any widgets on a user's Hub within the platform. The table can be joined to DIM_USER_SERVICE_USERS on User ID, many to 1, to show which users have widgets on their Hub
.png?sv=2026-02-06&spr=https&st=2026-11-04T03%3A47%3A21Z&se=2026-11-04T03%3A58%3A21Z&sr=c&sp=r&sig=C3atKfR0JMHzNIGu%2Bk5BGqiKFl6Kl%2FsQt1fgZv0sWQg%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 user’s 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 user’s Hub | large, small, tall, wide | wide |
Status | VARCHAR(16777216) | The current status for this widget. An inactive widget is one that appears on a user’s 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 user’s Hub | 2025-01-01T00:00:00.000+0000 | |
Widget ID | VARCHAR(16777216) | Identifier for the widget | 123a12b3cd4e5f67g890h1ij |