The purpose of DIM_PATHWAY_CONTENT_TASK_FLATTENED is to show for each pathway in the platform the different sections, content items and/or tasks included within it
This table does not include any archived or deleted pathways, contents or tasks. Only published pathways, contents and tasks are included
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Content/Task Description | VARCHAR(16777216) | The description for the individual pieces of content/tasks within the pathway | A quick guide to support you to achieve your sales goals | |
Content/Task ID | VARCHAR(16777216) | Identifier for the content | 123a12b3cd4e5f67g890h1ij | |
Content/Task Position | NUMBER(38,0) | The order in which the content/tasks show within the section | 1 | |
Content/Task Tags | VARIANT | Tags for the individual pieces of content/tasks within the pathway | [“sales”, “teamwork”] | |
Content/Task Title | VARCHAR(16777216) | The title for the individual pieces of content/tasks within the pathway | How to boost your sales this quarter | |
Content/Task Type | VARCHAR(16777216) | The type of content i.e. video, url. Will show PathwayBasicTask for tasks | video | |
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 Approval Req | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | FALSE |
Is Private | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
Is Section Restriction Enabled | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
Item Type | VARCHAR(7) | Shows whether each row is Content or Task item | Content, Task | Content |
Pathway Description | VARCHAR(16777216) | The description for the overall pathway | A sales focused pathway to support you wtith your sales goals | |
Pathway ID | VARCHAR(16777216) | Identifier for the pathway | 123a12b3cd4e5f67g890h1ij | |
Pathway Tags | VARIANT | Tags for the pathway | [“sales”, “teamwork”] | |
Pathway Title | VARCHAR(16777216) | The title for the overall pathway | Your Sales Goals | |
Section ID | VARCHAR(16777216) | Identifier for the section | 123a12b3cd4e5f67g890h1ij | |
Section Position | NUMBER(38,0) | The order in which the sections show within the pathway | 1 | |
Section Summary | VARCHAR(16777216) | The summary for the section | In this section we will explore your sales goals and how we can support you to achieve them | |
Section Title | VARCHAR(16777216) | The title for the section | Section 1: Your Sales Goals | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
User IDs with Private Content Access | ARRAY | A list of users who have access to the private content either because it has been assigned to an audience they are in, shared with an audience they are in or shared with them directly | ["123a12b3cd4e5f67g890h1ij", "123a12b3cd4e5f67g890h1ij"] |