> ## Documentation Index
> Fetch the complete documentation index at: https://confidence.spotify.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create a Dimension Table

> Learn how to create a dimension table in Confidence.

A [dimension table](../metrics/dimension-tables) lets you segment your entities.

## Create a Dimension Table

<Steps>
  <Step title="Go to Confidence" />

  <Step title="Select Admin > Dimension tables">
    On the left sidebar, select **Admin**, then select **Dimension tables**.
  </Step>

  <Step title="Click Create" />

  <Step title="Enter a name for the dimension table">
    In the **About** section, enter a name for the table in the **Name** field. Optionally, select an **Owner**.
  </Step>

  <Step title="Enter the SQL that selects your dimension rows">
    In the **Query** section, enter the SQL query and click **Run query**. See the [SQL query section](../metrics/dimension-tables#sql-query) in the reference documentation for more information.
  </Step>

  <Step title="Configure the table">
    In the **Configure table** section, map the entity column and dimension columns from the query result.
  </Step>

  <Step title="Click Create">
    When you click **Create**, the dimension table goes into state `CREATING`. Confidence then runs a sample query towards the dimension table to verify that the SQL query produces columns that match what you've specified. After this the table either enters the `ACTIVE` or `FAILED` state.
  </Step>
</Steps>

<Tip>
  To create dimension tables via the API, see [Create Dimension Tables](../api/how-to-guides/metrics/create-dimension-table) in the API how-to guides.
</Tip>

## Related Resources

<CardGroup cols={2}>
  <Card title="Dimension Tables Reference" href="/docs/metrics/dimension-tables">
    Deep dive into dimension table configuration
  </Card>

  <Card title="Create Fact Tables" href="/docs/how-to-guides/create-fact-table">
    Set up measurement data sources
  </Card>

  <Card title="Explore Results" href="/docs/how-to-guides/explore-results">
    Segment results by dimensions
  </Card>

  <Card title="Create Metrics" href="/docs/how-to-guides/create-metric">
    Build metrics from your data
  </Card>
</CardGroup>