FCT_SPACE_PAGE_MEMBERSHIP relates to who has been added to spaces either individually or by a group membership. The table can be joined to DIM_SPACES on PageID
.png?sv=2026-02-06&spr=https&st=2026-05-30T19%3A06%3A04Z&se=2026-05-30T19%3A17%3A04Z&sr=c&sp=r&sig=ZlK5CxMBdCTVP%2BXtbt9H6EEwDCpQqdNom13nmLgQJ3w%3D)
.png?sv=2026-02-06&spr=https&st=2026-05-30T19%3A06%3A04Z&se=2026-05-30T19%3A17%3A04Z&sr=c&sp=r&sig=ZlK5CxMBdCTVP%2BXtbt9H6EEwDCpQqdNom13nmLgQJ3w%3D)
.png?sv=2026-02-06&spr=https&st=2026-05-30T19%3A06%3A04Z&se=2026-05-30T19%3A17%3A04Z&sr=c&sp=r&sig=ZlK5CxMBdCTVP%2BXtbt9H6EEwDCpQqdNom13nmLgQJ3w%3D)
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Created At | TIMESTAMP_NTZ(9) | Datetime the membership was created | 2025-01-01T00:00:00.000+0000 | |
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 | |
Group ID | VARCHAR(16777216) | Identifier for the group | 123a12b3cd4e5f67g890h1ij | |
Is Program Mentee | BOOLEAN | Indicator to show if the user has a program mentee role | TRUE, FALSE | TRUE |
Is Program Mentor | BOOLEAN | Indicator to show if the user has a program mentor role | TRUE, FALSE | FALSE |
Is Published | BOOLEAN | Indicator to show if the space was published when the member/group was added to it. If true then a notification is sent immediately, if not they are notified once it has been published | TRUE, FALSE, null | TRUE |
Is Space Admin | BOOLEAN | Indicator to show if the user has a space admin role | TRUE, FALSE | FALSE |
Is Space Member | BOOLEAN | Indicator to show if the user has a space member role | TRUE, FALSE | TRUE |
Membership ID | VARCHAR(16777216) | Identifier for the group membership | 123a12b3cd4e5f67g890h1ij | |
Page ID | VARCHAR(16777216) | Identifier for the page This is currently a duplicate of the Space ID | 123a12b3cd4e5f67g890h1ij | |
Principal Type | VARCHAR(16777216) | Shows whether the user was added individually or through a group. The user can appear multiple times if added both individually and via groups | group, user | user |
Published At | TIMESTAMP_NTZ(9) | Datetime the membership was published | 2025-01-01T00:00:00.000+0000 | |
Roles | VARCHAR(16777216) | Comma seperated list of all roles the user has | space member, program mentee | |
Space ID | VARCHAR(16777216) | Identifier for the space | 123a12b3cd4e5f67g890h1ij | |
Space Name | VARCHAR(16777216) | Name of the space | Sales Team Mentoring | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Datetime the membership was last updated | 2025-01-01T00:00:00.000+0000 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |