Skip to main content
A fact table contains measurements that describe your entities.

​
Create a Fact Table

1

Go to Confidence

2

Select Admin > Fact tables

On the left sidebar, select Admin > Fact tables.
3

Click Create

Click + Create to create a new fact table.
4

Enter a name for the fact table

In the About section, enter a name and select an owner.
5

Enter the SQL query

In the Query section, enter the SQL that selects your fact rows and click Run query. See the SQL query section in the reference documentation for SQL query best practices.
6

Configure the table

In the Configure table section, map the timestamp column, entity columns, measurement columns, and dimension columns.
7

Click Create

When you click create, the fact table goes into state CREATING. Confidence then runs a sample query towards the fact table to verify that the SQL query produces columns that match what you’ve specified. After this the table either goes to state ACTIVE or FAILED.
To create fact tables via the API, see Create Fact Tables in the API how-to guides.

Fact Tables Reference

Deep dive into fact table configuration

Create Metrics

Build metrics from your fact tables

Create Dimension Tables

Add segmentation dimensions