FCT_SPACES_CONTENT_BLOCKS relates to the type of content included within each space/page/subpage. The table can be joined to DIM_SPACES on Page ID
.png?sv=2022-11-02&spr=https&st=2026-03-29T20%3A46%3A15Z&se=2026-03-29T20%3A57%3A15Z&sr=c&sp=r&sig=P1K53s76qEza62M1QimzS6ZEi8FHHOfzK5nTss9m%2FVA%3D)
⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Content Block | VARCHAR(16777216) | What is included within the space/page/subpage | carousel, child navigation, document, iframe, image, mentorship, rich text, social, url, video | social |
Content Block Created At | TIMESTAMP_NTZ(9) | Datetime the content block was created | 2025-01-01T00:00:00.000+0000 | |
Content Block ID | VARCHAR(16777216) | Unique identifier for the content block | 123a12b3cd4e5f67g890h1ij | |
Content Block Updated At | TIMESTAMP_NTZ(9) | Datetime the content block was last updated | 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 | |
Is AI Prompted | BOOLEAN | Indicator to show if the content within the block was created by AI i.e. an image or rich text | TRUE, FALSE | FALSE |
Page ID | VARCHAR(16777216) | Identifier for the page/subpage | 456a12b3cd4e5f67g890h1ij | |
Page Title | VARCHAR(16777216) | Name of the individual page/subpage | Todays Thoughts! | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 |