---
title: "FCT_USER_HUB"
slug: "fct-user-hub"
updated: 2026-09-07T07:15:03Z
published: 2026-09-07T07:15:03Z
canonical: "docs.thrivelearning.com/fct-user-hub"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thrivelearning.com/llms.txt
> Use this file to discover all available pages before exploring further.

# FCT_USER_HUB

> [!CAUTION]
> ⏰ 👀 COMING SOON - This data set is currently in development and is subject to change

> [!NOTE]
> 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

![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(916).png?sv=2026-02-06&spr=https&st=2026-11-04T05%3A04%3A32Z&se=2026-11-04T06%3A04%3A32Z&sr=c&sp=r&sig=4dLnek%2FSNSY15UDG7jJkTiZQRC09I2eOUaiF0%2BReSjo%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 Note: this will be null for admin link, link, notes and todo widgets | 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 | email |
| **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 Note: if a widget is added, removed and re-added the datetime will reflect when it was most recently added |  | 2025-01-01T00:00:00.000+0000 |
| **Widget ID** | VARCHAR(16777216) | Identifier for the widget |  | 123a12b3cd4e5f67g890h1ij |