Skip to main content
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.

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