⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_MENTORSHIP_RELATIONSHIPS records all mentoring/coaching/sponsorship 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/coaching/sponsorship relationships
.png?sv=2026-02-06&spr=https&st=2026-07-23T20%3A37%3A19Z&se=2026-07-23T20%3A48%3A19Z&sr=c&sp=r&sig=%2BjVxnc9IsgYzCIZ1Rz%2FGnc%2BOQpwWWR1wF3AcYwuNXPw%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 | |
Has Goals Match | Boolean | True/False indicator to show if the mentoring relationship included a match on goals | TRUE, FALSE | FALSE |
Has Profile Field Match | Boolean | True/False indicator to show if the mentoring relationship included a match on profile fields | TRUE, FALSE | TRUE |
Has Skills Match | Boolean | True/False indicator to show if the mentoring relationship included a match on skills | TRUE, FALSE | TRUE |
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 |
Program Type | VARCHAR(16777216) | Establishes the type of program the relationship was formed within | mentoring, coaching, sponsorship | mentoring |
Relationship ID | VARCHAR(16777216) | Identifier for the relationship between mentor and mentee | 123a12b3cd4e5f67g890h1ij | |
Relationship Match Source | VARCHAR(16777216) | Shows the methods the match was formed upon | profile fields If multiple ‘and’ will seperate the above | profile fields and skills |
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 |