The purpose of DIM_SPACES is to show meta data for each space within the platform. It can be joined to various FACT tables on Page ID, 1 to many, to show content blocks and space membership
Space Object ID can also be joined to FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY to show space engagement
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Created At | TIMESTAMP_NTZ(9) | Datetime the space/page/subpage/post was created | 2025-01-01T00:00:00.000+0000 | |
Created By | VARCHAR(16777216) | Name of who created the space/page/subpage/post | John Smith | |
Created By ID | VARCHAR(16777216) | Identifier of who created the space/page/subpage/post | 123a12b3cd4e5f67g890h1ij | |
Created By Type | VARCHAR(16777216) | Identifier of who created the space/page/subpage/post | user | |
Depth | NUMBER(38,0) | Used to show space hierarchy. A space is 0, page is 1, sub page 2 etc | 1 | |
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 Public | BOOLEAN | Flag to show if the space/page/subpage/post is public | TRUE, FALSE | FALSE |
Page Description | VARCHAR(16777216) | Description for the individual page/subpage | What is the number 1 thing you would recommend a colleague to try? | |
Page ID | VARCHAR(16777216) | Identifier for the page/subpage | 456a12b3cd4e5f67g890h1ij | |
Page Name | VARCHAR(16777216) | Name of the individual page/subpage | Todays Thoughts! | |
Page Status | VARCHAR(16777216) | Identifier to show if the page is published, draft or ready | published, draft, ready | published |
Post | VARCHAR(16777216) | The first text block of the post | I recommend recording your calls and seeking feedback and coaching | |
Post ID | VARCHAR(16777216) | Identifier for the post | 123a12b3cd4e5f67g890h1ij | |
Post Hashtags | VARIANT | List of any hashtags used within a post | [”sales”] | |
Post Status | VARCHAR(16777216) | Identifier to show if the post is published, draft or ready | published, draft, ready | published |
Post Type | VARCHAR(16777216) | List of what is included within the post | rich_text, url | |
Space Description | VARCHAR(16777216) | Description for the space | Use this space to share knowledge with your peers | |
Space ID | VARCHAR(16777216) | Identifier for the space | 123a12b3cd4e5f67g890h1ij | |
Space Name | VARCHAR(16777216) | Name of the space | Sales Team Mentoring | |
Space Object ID | VARCHAR(16777216) | Identifier for the space, page, subpage or post | 123a12b3cd4e5f67g890h1ij | |
Space Status | VARCHAR(16777216) | Identifier to show if the space is published, draft or ready | published, draft, ready | published |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Type | VARCHAR(7) | Identifier to show if this is a space, page, subpage or a post | space, page, subpage | page |
Updated At | TIMESTAMP_NTZ(9) | Datetime the space/page/subpage/post was last updated | 2025-01-01T00:00:00.000+0000 |