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
⏰ 👀 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 |
|---|---|---|---|---|
Created At | TIMESTAMP_NTZ(9) | Datetime the space/page/subpage was created | 2025-01-01T00:00:00.000+0000 | |
Created By | VARCHAR(16777216) | Name of who created the space/page/subpage | John Smith | |
Created By ID | VARCHAR(16777216) | Identifier of who created the space/page/subpage | 123a12b3cd4e5f67g890h1ij | |
Created By Type | VARCHAR(16777216) | Identifier of who created the space/page/subpage | 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 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! | |
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 Tips & Tricks | |
Status | VARCHAR(16777216) | Identifier to show if the space/page/subpage is published or draft | published, draft | 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 or a subpage | space, page, subpage | page |
Updated At | TIMESTAMP_NTZ(9) | Datetime the space/page/subpage was last updated | 2025-01-01T00:00:00.000+0000 |