> ## Documentation Index
> Fetch the complete documentation index at: https://confidence-auth-testing.mintlify.site/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.

export const HowToSchema = ({name, description, steps = []}) => {
  const schema = {
    "@context": "https://schema.org",
    "@type": "HowTo",
    name,
    description
  };
  if (steps.length > 0) {
    schema.step = steps.map((s, i) => ({
      "@type": "HowToStep",
      position: i + 1,
      name: typeof s === "string" ? s : s.name,
      text: typeof s === "string" ? s : s.text || s.name
    }));
  }
  return <script type="application/ld+json" dangerouslySetInnerHTML={{
    __html: JSON.stringify(schema)
  }} />;
};

<HowToSchema
  name="Create a Dimension Table"
  description="Learn how to create a dimension table in Confidence."
  steps={[
"Go to Confidence",
{
  name: "Select Admin > Dimension tables",
  text: "On the left sidebar, select Admin, then select Dimension tables.",
},
"Click Create",
{
  name: "Enter a name for the dimension table",
  text: "In the About section, enter a name for the table in the Name field. Optionally, select an Owner.",
},
{
  name: "Enter the SQL that selects your dimension rows",
  text: "In the Query section, enter the SQL query and click Run query. See the SQL query section in the reference documentation for more information.",
},
{
  name: "Configure the table",
  text: "In the Configure table section, map the entity column and dimension columns from the query result.",
},
{
  name: "Click Create",
  text: "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.",
},
]}
/>

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>