---
title: "DIM_SPACES"
slug: "dim-spaces"
updated: 2026-07-23T10:13:05Z
published: 2026-07-23T10:13:05Z
canonical: "docs.thrivelearning.com/dim-spaces"
---

> ## 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_SPACES

> [!NOTE]
> 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 |