Create a Fact Table

Learn how to create a fact table in Confidence.

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.

Related Resources

Fact Tables Reference

Deep dive into fact table configuration

Create Metrics

Build metrics from your fact tables

Create Dimension Tables

Add segmentation dimensions