Create an Assignment Table

Learn how to create an assignment table in Confidence.

An assignment table stores records of what entities have been assigned what configuration.

Create an Assignment Table

1. Go to Confidence
2. Select Admin > Assignment tables
3. Click + Create
4. Enter the name of your assignment table
5. Enter the SQL that selects your assignment rows

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

6. Select columns from the query result

   Map the timestamp, entity, exposure key, and variant key columns.

7. Click Create

To create assignment tables via the API, see Create Assignment Tables in the API how-to guides.

Related Resources

Assignment Tables Reference

Deep dive into assignment table configuration

Create Entities

Set up the entity for your assignments

Analyze Past Experiments

Use assignment tables for analysis

Exposure Reference

Understand experiment exposure calculations