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

# Create an Assignment Table

> Learn how to create an assignment table in Confidence.

export const HowToSchema = ({name, description, steps = []}) => {
  const schema = {
    "@context": "https://schema.org",
    "@type": "HowTo",
    name,
    description
  };
  if (steps.length > 0) {
    schema.step = steps.map((s, i) => ({
      "@type": "HowToStep",
      position: i + 1,
      name: typeof s === "string" ? s : s.name,
      text: typeof s === "string" ? s : s.text || s.name
    }));
  }
  return <script type="application/ld+json" dangerouslySetInnerHTML={{
    __html: JSON.stringify(schema)
  }} />;
};

<HowToSchema
  name="Create an Assignment Table"
  description="Learn how to create an assignment table in Confidence."
  steps={[
"Go to Confidence",
"Select Admin > Assignment tables",
"Click + Create",
"Enter the name of your assignment table",
{
  name: "Enter the SQL that selects your assignment rows",
  text: "See the configuration section in the reference documentation for SQL query best practices.",
},
{
  name: "Select columns from the query result",
  text: "Map the timestamp, entity, exposure key, and variant key columns.",
},
"Click Create",
]}
/>

An [assignment table](../metrics/assignment-tables) stores records of what entities have been assigned what configuration.

## Create an Assignment Table

<Steps>
  <Step title="Go to Confidence" />

  <Step title="Select Admin > Assignment tables" />

  <Step title="Click + Create" />

  <Step title="Enter the name of your assignment table" />

  <Step title="Enter the SQL that selects your assignment rows">
    See the [configuration section](../metrics/assignment-tables#configuration) in the reference documentation for SQL query best practices.
  </Step>

  <Step title="Select columns from the query result">
    Map the timestamp, entity, exposure key, and variant key columns.
  </Step>

  <Step title="Click Create" />
</Steps>

<Tip>
  To create assignment tables via the API, see [Create Assignment Tables](../api/how-to-guides/metrics/create-assignment-table) in the API how-to guides.
</Tip>

## Related Resources

<CardGroup cols={2}>
  <Card title="Assignment Tables Reference" href="/docs/metrics/assignment-tables">
    Deep dive into assignment table configuration
  </Card>

  <Card title="Create Entities" href="/docs/how-to-guides/create-entity">
    Set up the entity for your assignments
  </Card>

  <Card title="Analyze Past Experiments" href="/docs/quickstarts/analyze-past-experiment">
    Use assignment tables for analysis
  </Card>

  <Card title="Exposure Reference" href="/docs/metrics/exposure">
    Understand experiment exposure calculations
  </Card>
</CardGroup>