⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_MENTORSHIP_RELATIONSHIPS records all mentoring relationships within platform spaces. The table can be joined to DIM_SPACES on Space ID, many to 1, to show spaces which have relationships. It can also be joined to DIM_USER_SERVICE_USER on Participant ID, many to 1, to show which users have mentoring relationships
.png?sv=2026-02-06&spr=https&st=2026-05-30T18%3A02%3A51Z&se=2026-05-30T18%3A13%3A51Z&sr=c&sp=r&sig=4zTIwZnKJNu5PrlVf0S0OpXicCzXR3sboQOmMxzOGIc%3D)
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Created At | TIMESTAMP_NTZ(9) | Datetime the relationship was created (match datetime) | 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 | |
Participant ID | VARCHAR(16777216) | Unique identifier for the user, can be used along with the space details and role to asertain if the partipant is a mentor or/and mentee | 123a12b3cd4e5f67g890h1ij | |
Participant Role | VARCHAR(16777216) | Flag to show if the participant is a program mentee or mentor (please note they can be both) | program mentee, program mentor | program mentor |
Relationship ID | VARCHAR(16777216) | Identifier for the relationship between mentor and mentee | 123a12b3cd4e5f67g890h1ij | |
Space ID | VARCHAR(16777216) | Identifier for the space | 123a12b3cd4e5f67g890h1ij | |
Space Name | VARCHAR(16777216) | Name of the space | Sales Team Mentoring | |
Status | VARCHAR(16777216) | The current status of the relationship | active, concluded | active |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Datetime the relationship was last updated (match last updated) | 2025-01-01T00:00:00.000+0000 |