⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_COMMENTS shows comments within spaces or on content. It can be joined to DIM_USER_SERVICE_USERS on User ID, many to 1, to show which users have commented. It can also join to DIM_SPACES - Object ID to Space Object ID, many to 1, to show which space comments have been left on. For content comments join to DIM_CONTENT_SERVICE_CONTENTS - Object ID to Content ID, many to 1
.png?sv=2026-02-06&spr=https&st=2026-11-04T04%3A57%3A46Z&se=2026-11-04T05%3A08%3A46Z&sr=c&sp=r&sig=MuVzqKaBcwnLdLEXYcNSrnU6mgSk5vk6mPyxcQAOEAw%3D)
.png?sv=2026-02-06&spr=https&st=2026-11-04T04%3A57%3A46Z&se=2026-11-04T05%3A08%3A46Z&sr=c&sp=r&sig=MuVzqKaBcwnLdLEXYcNSrnU6mgSk5vk6mPyxcQAOEAw%3D)
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Comment | VARCHAR(16777216) | The verbatim text of the comment | This is great advice, thank you for sharing | |
Comment ID | VARCHAR(16777216) | Identifier for the comment | 123a12b3cd4e5f67g890h1ij | |
Comment Type | VARCHAR(7) | The type of comment made - comment for a standard comment or reply in response to an existing comment | comment, reply | comment |
Created At | TIMESTAMP_NTZ(9) | Datetime the comment 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 | |
Language Code | VARCHAR(16777216) | The language the comment was wrote in | en | |
Object ID | VARCHAR(16777216) | Used to join to DIM_SPACES or DIM_CONTENT_SERVICE_CONTENTS to see which space the comment was logged on or the piece of content where the comment was left | 123a12b3cd4e5f67g890h1ij | |
Parent Comment ID | VARCHAR(16777216) | Where the comment is in reply to an existing comemnt the parent comment ID will align to the origin comment ID | 123a12b3cd4e5f67g890h1ij | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Datetime the comment was updated | 2025-01-01T00:00:00.000+0000 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |