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

   See the SQL query section in the reference documentation for SQL query best practices.

4. Select columns from the query result

   Map the timestamp column, entity columns, measurement columns, and dimension columns.

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

Structure Fact Tables

Best practices for fact table design