FCT_SPACE_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 Space ID
.png?sv=2022-11-02&spr=https&st=2026-03-29T20%3A46%3A01Z&se=2026-03-29T20%3A57%3A01Z&sr=c&sp=r&sig=Bqc%2FONAOvceftTuuZ40BNDY87LZbEWTZPlU0mAMdYhc%3D)
.png?sv=2022-11-02&spr=https&st=2026-03-29T20%3A46%3A01Z&se=2026-03-29T20%3A57%3A01Z&sr=c&sp=r&sig=Bqc%2FONAOvceftTuuZ40BNDY87LZbEWTZPlU0mAMdYhc%3D)
.png?sv=2022-11-02&spr=https&st=2026-03-29T20%3A46%3A01Z&se=2026-03-29T20%3A57%3A01Z&sr=c&sp=r&sig=Bqc%2FONAOvceftTuuZ40BNDY87LZbEWTZPlU0mAMdYhc%3D)
⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
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 membership 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 | |
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 | |
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 |