Skip to main content

Documentation Index

Fetch the complete documentation index at: https://confidence.spotify.com/llms.txt

Use this file to discover all available pages before exploring further.

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