---
title: "DIM_CONTENT_SERVICE_CONTENTS"
slug: "dim-content-service-contents"
updated: 2026-05-26T14:33:07Z
published: 2026-05-26T14:33:07Z
canonical: "docs.thrivelearning.com/dim-content-service-contents"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thrivelearning.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DIM_CONTENT_SERVICE_CONTENTS

> [!NOTE]
> The purpose of DIM_CONTENT_SERVICE_CONTENTS is to show meta data for each content item within the platform. It can be joined to various FACT tables on Content ID, 1 to many, to show activity by content. It can also be joined to BRG_CONTENT_TAGS, 1 to many, to show a row for each tag that is applied to the content item

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | CURRENT AVAILABLE VALUES | EXAMPLE |
| --- | --- | --- | --- | --- |
| Archived At | TIMESTAMP_NTZ(9) | Datetime the content was archived |  | 2025-01-01T00:00:00.000+0000 |
| Artefact ID | VARCHAR(16777216) | Identifier for the artefact; various content types such as file, url, elearning will have an artefact id. This identifier changes when new versions of the artefact are uploaded |  | 123a12b3cd4e5f67g890h1ij |
| Assessment Count | NUMBER(13,0) | The number of assessments within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 0 |
| Assigned Audiences (ID) | VARIANT | List of audience IDs this content is assigned too |  | [“123a12b3cd4e5f67g890h1ij“] |
| Assigned Audiences (Name) | VARCHAR(16777216) | List of audience names this content is assigned too |  | Sales North East |
| Audiences Shared With (ID) | VARIANT | List of audience IDs this content has been shared with |  | [“123a12b3cd4e5f67g890h1ij“] |
| Audiences Shared With (Name) | VARCHAR(16777216) | List of audience names this content has been shared with |  | Sales North East |
| Audio Count | NUMBER(13,0) | The number of audio items within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 1 |
| Author | VARCHAR(16777216) | Content author ID |  | 123a12b3cd4e5f67g890h1ij |
| Author Email | VARCHAR(16777216) | Content author email address |  | [john.smith@emailaddress.com](mailto:john.smith@emailaddress.com) |
| Author First Name | VARCHAR(16777216) | Content author first name |  | John |
| Author Full Name | VARCHAR(16777216) | Content author full name - concatenation of first and last names |  | John Smith |
| Author Last Name | VARCHAR(16777216) | Content author last name |  | Smith |
| Author Ref | VARCHAR(16777216) | Content author ref |  | ABC123 |
| Available Translations | VARCHAR(16777216) | Comma-separated list of languages/transalations available (e.g. - en-us, de, en-gb etc.) |  | en-us, fr-ca |
| CPD Category (ID) | VARCHAR(16777216) | ID of the CPD category the content relates to |  | 123a12b3cd4e5f67g890h1ij |
| Can Reshare | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
| Collaboration Id | VARCHAR(16777216) | ID of the collaboration who own the content |  | 123a12b3cd4e5f67g890h1ij |
| Collaboration Name | VARCHAR(16777216) | Name of the collaboration who own the content |  | Sales Training |
| Completion | VARCHAR(16777216) | Completion types for the content | Auto, External Confirmation, None - Switched Off, Pathway - Accept Historical Completions, Pathway - Accept Recent Completions, User Confirmation | Auto |
| Content Body Updated At | TIMESTAMP_NTZ(9) | Datetime the content body was last updated |  | 2025-01-01T00:00:00.000+0000 |
| Content Carousel Count | NUMBER(13,0) | The number of content carousel blocks within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 0 |
| Content ID | VARCHAR(16777216) | Identifier for the content |  | 123a12b3cd4e5f67g890h1ij |
| Content Tag List | VARCHAR(16777216) | Comma-separated list of tags linked to this content. Replaces the legacy "Content Tags" (VARIANT) column |  | sales, teamwork |
| ⚠️ *Deprecated* Content Tags | VARIANT | Tags linked to this content. Returned as a VARIANT array - use "Content Tag List" instead, which provides the same data as a comma-separated string for filtering within platform Insights reporting. This column is due to be deprecated |  | [“sales”, “teamwork”] |
| Content Title | VARCHAR(16777216) | Content title |  | How to boost your sales this quarter |
| Content Type | VARCHAR(16777216) | Type of content (e.g. - url, file, video etc.) |  | mixed |
| Created At | TIMESTAMP_NTZ(9) | Datetime the content was created |  | 2025-01-01T00:00:00.000+0000 |
| Default Duration | NUMBER(38,0) | Default content duration in minutes |  | 15 |
| Deleted | BOOLEAN | Boolean flag (true/false) to show if the content has been deleted | TRUE, FALSE, null | FALSE |
| Deleted At | TIMESTAMP_NTZ(9) | Datetime the content was deleted |  | 2025-01-01T00:00:00.000+0000 |
| Deleted By (ID) | VARCHAR(16777216) | ID of the user who deleted the content |  | 123a12b3cd4e5f67g890h1ij |
| Description | VARCHAR(16777216) | Content description |  | A quick guide to support you to achieve your sales goals |
| Distinct Item Count | NUMBER(18,0) | A distinct count of items included within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 7 |
| Distinct Item Types | ARRAY | A list of distinct items included within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | [ "Video", "Text", "Audio", "Image", "Link", "Social Feed", "PDF/File", ] |
| 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 |
| Embed Count | NUMBER(13,0) | The number of embedded content blocks within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 0 |
| Erasure | VARIANT | Details of the content deletion including deleted datetime, deleted by details and whether it is a hard or soft deletion |  | { "deletedAt": "2025-01-01T00:00:00.000Z", "deletedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" }, "isHard": true, "isSoft": false } |
| Error Messages | VARIANT | Error messages related to the creation and uploading of content (e.g. - Unsupported format type, Scorm CAM 1.3 version is not supported”, No asset or sco items found etc.) |  | [ "Unsupported format type" ] |
| Event Log | VARIANT | Details of the content and related events such as draft created and content published. Along with associated timestamps |  | [ { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentDraftCreated", "loggedBy": { "type": "service", "value": "video-artefact-service" } }, { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentPublished", "loggedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" } }, { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentArchived", "loggedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" } }, { "createdAt": "2025-01-01T00:00:00.000", "eventType": "contentDeleted", "loggedBy": { "type": "user", "value": "123a12b3cd4e5f67g890h1ij" } } ] |
| External Reference | VARCHAR(16777216) | External reference for the content |  | 123456789 |
| Has Picture | BOOLEAN | Boolean flag (true/false) to show if the content has an image | TRUE, FALSE, null | FALSE |
| Image Count | NUMBER(13,0) | The number of images within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 1 |
| Internal Version (__v) | VARCHAR(16777216) | Internal version number derived from the number of events within Versions |  | 1 |
| Is Allowed To Comment | BOOLEAN | Boolean flag (true/false) to show if comments are enabled for this piece of content | TRUE, FALSE, null | TRUE |
| Is Archived | BOOLEAN | Boolean flag (true/false) to show if the content has been archived | TRUE, FALSE, null | FALSE |
| Is Official | BOOLEAN | Boolean flag (true/false) to show if the content is endorsed | TRUE, FALSE, null | TRUE |
| Is Private | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | FALSE |
| Is Published | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | FALSE |
| Is Visible | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
| Item Count | NUMBER(18,0) | A total count of items included within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 11 |
| Last Viewed Date | DATE | The date this content item was last viewed |  | 2025-01-01 |
| Last Viewed Time | VARCHAR(16777216) | The time this content item was last viewed |  | 00:00:00 |
| Last Viewed Timestamp | TIMESTAMP_NTZ(9) | The datetime this content item was last viewed |  | 2025-01-01T00:00:00.000+0000 |
| Link Count | NUMBER(13,0) | The number of links within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 1 |
| Linked Contents | BOOLEAN | List of content IDs this content is linked with |  | [“123a12b3cd4e5f67g890h1ij“] |
| Linked Contents (Title) | VARCHAR(16777216) | List of content titles this content is linked with |  | Sales Top Tips |
| Marked Ready | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | FALSE |
| Material Type | VARCHAR(16777216) | Type of content material (e.g. - zip, mp3, jpeg etc.) |  | pptx |
| Mentorship Programme Count | NUMBER(13,0) | The number of mentorship programme blocks within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 0 |
| Notifications | VARIANT | Legacy field which is no longer in use, around who would receive notifications for the content |  | { "userName": { "firstName": "John", "lastName": "Smith" } } |
| Ordered Item Types | ARRAY | An ordered list of items included within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | [ "Image", "Video", "Text", "Audio", "Text", "Link", "Video", "Text", "PDF/File", "Social Feed", "PDF/File", ] |
| PDF/File Count | NUMBER(13,0) | The number of PDFs/files within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 2 |
| Page Navigation Count | NUMBER(13,0) | The number of page navigation blocks within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 0 |
| Processing Status | VARCHAR(16777216) | Shows the processing status of the content | failed, processing, null, complete, preprocessing | processing |
| Provider | VARCHAR(16777216) | The name of the content provider (e.g. - udemy, linkedIn, blinkist etc.) |  | andersPink |
| Published At | TIMESTAMP_NTZ(9) | Datetime the content was published2025-01-01T00:00:00.000+0000 |  |  |
| Quiz Count | NUMBER(13,0) | The number of quizzes within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 0 |
| Raw Items | VARIANT | The raw items document which includes all items within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | [ { "_id": "123a12b3cd4e5f67g890h1ij", "ai": null, "createdAt": "2025-01-01T00:00:00.000", "meta": { "body": "", "mentions": [], "uniqueId": "" }, "rank": 1, "status": "ok", "summary": "test-summary", "type": "rich_text", "updatedAt": "2025-01-01T00:00:00.000" } ................ ] |
| Set Duration | NUMBER(38,0) | Set content duration in minutes |  | 15 |
| Skill Boosts | VARIANT | Where completion of the content is linked to boosting learner skills the skill name and level is recorded |  | [ { "criteria": "on_completion", "level": 1024, "name": "sales" } ] |
| Social Feed Count | NUMBER(13,0) | The number of social feeds within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 1 |
| Tenant ID | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| Text Count | NUMBER(13,0) | The number of text blocks within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 3 |
| Thumbnail Updated At | TIMESTAMP_NTZ(9) | Datetime the content thumbnail was last updated |  | 2025-01-01T00:00:00.000+0000 |
| Updated At | TIMESTAMP_NTZ(9) | Datetime the content was last updated - this may include audience updates |  | 2025-01-01T00:00:00.000+0000 |
| User IDs with Private Content Access | ARRAY | List of all user ids who can access this content, if the content is set to private |  | [“123a12b3cd4e5f67g890h1ij“] |
| Users Shared With (Full Name) | VARCHAR(16777216) | List of user names this content has been shared with |  | [“John Smith“] |
| Users Shared With (ID) | VARIANT | List of user IDs this content has been shared with |  | [“123a12b3cd4e5f67g890h1ij“] |
| Users from Assigned Audiences (ID) | ARRAY | Array of all user IDs the content has been assigned too |  | [“123a12b3cd4e5f67g890h1ij“] |
| Users from Audiences Shared With (ID) | ARRAY | Array of all user IDs the content has been shared with |  | [“123a12b3cd4e5f67g890h1ij“] |
| Version | NUMBER(38,0) | Shows the current version of the content |  | 1 |
| Versions | VARIANT | Shows the content version history including the artefactId for each version |  | [ { "artefactId": "123a12b3cd4e5f67g890h1ij", "version": 1 } ] |
| Video Count | NUMBER(13,0) | The number of videos within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 2 |
| ZIP Files & Archive Count | NUMBER(13,0) | The number of zip files & archives within a content item created using the content creator If no items exist in the record or the content has not been created by the content creator this will show null |  | 0 |