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
3. Enter the SQL that selects your dimension rows

   See the SQL query section in the reference documentation for more information.

4. Select columns from the query result

   Map the entity column and dimension columns.

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