Create a Dimension Table

Learn how to create a dimension table in Confidence.

A dimension table lets you segment your entities.

Create a Dimension Table

1. Go to Confidence
2. Select Admin > Dimension tables

   On the left sidebar, select Admin, then select Dimension tables.

3. Click Create
4. 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.

5. 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 in the reference documentation for more information.

6. Configure the table

   In the Configure table section, map the entity column and dimension columns from the query result.

7. 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.

To create dimension tables via the API, see Create Dimension Tables in the API how-to guides.

Related Resources

Dimension Tables Reference

Deep dive into dimension table configuration

Create Fact Tables

Set up measurement data sources

Explore Results

Segment results by dimensions

Create Metrics

Build metrics from your data