> ## Documentation Index
> Fetch the complete documentation index at: https://confidence-auth-testing.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Create a Fact Table

> Learn how to create a fact table in Confidence.

**Create a Fact Table**

Learn how to create a fact table in Confidence.

[Do this via the API →](/docs/reference/api/how-to-guides/metrics/create-fact-table.md)

A [fact table](/docs/capabilities/metrics/fact-tables.md) contains measurements that describe your entities.

## Create a Fact Table

**1. Go to Confidence**

**2. Select Admin > Data Tables > Fact tables**

On the left sidebar, select **Admin > Data Tables > 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](/docs/capabilities/metrics/fact-tables.md#sql-query) 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`.

> [!TIP]
>
> To create fact tables via the API, see [Create Fact Tables](/docs/reference/api/how-to-guides/metrics/create-fact-table.md) in the API how-to guides.

## Related Resources

> **[Fact Tables Reference](/docs/capabilities/metrics/fact-tables.md)**
>
> Deep dive into fact table configuration

> **[Create Metrics](/docs/capabilities/metrics/create-metric.md)**
>
> Build metrics from your fact tables

> **[Create Dimension Tables](/docs/capabilities/metrics/create-dimension-table.md)**
>
> Add segmentation dimensions