Create Assignment Tables

​

Before You Begin

• An API access token with appropriate permissions
• Created the entity you want to track assignments for
• Prepared a SQL query that selects assignment rows from your data warehouse
• Identified the columns for timestamp, entity ID, exposure key, and variant key

​

Create an Assignment Table

curl -X POST "https://metrics.confidence.dev/v1/assignmentTables" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "displayName": "My Assignment Table",
    "dataDeliveredUntilUpdateStrategyConfig": {
      "strategy": "AUTOMATIC",
      "automaticUpdateConfig": {
        "incrementDuration": "P13H",
        "commitDelay": "P13H"
      }
    },
    "sql": "SELECT * FROM my_table",
    "entityColumnMapping": {
      "column": {
        "name": "user_id"
      },
      "entity": "entities/user"
    },
    "timestampColumn": {
      "name": "timestamp"
    },
    "exposureKeyColumn": {
      "name": "experiment_id"
    },
    "variantKeyColumn": {
      "name": "group"
    }
  }'

​

Column Mapping Fields

• entityColumnMapping: Maps the column containing entity IDs to the entity resource
  • column.name: Name of the column in your query results
  • entity: Resource name of the entity (for example, entities/user)
• timestampColumn: Column containing the assignment timestamp
• exposureKeyColumn: Column identifying which experiment the assignment belongs to
• variantKeyColumn: Column identifying which variant was assigned

​

Data Delivery Strategy

"dataDeliveredUntilUpdateStrategyConfig": {
  "strategy": "AUTOMATIC",
  "automaticUpdateConfig": {
    "incrementDuration": "P13H",
    "commitDelay": "P13H"
  }
}

"dataDeliveredUntilUpdateStrategyConfig": {
  "strategy": "DAILY",
  "dailyUpdateConfig": {}
}

​

Next Steps

• Create fact tables to measure outcomes
• Create metrics using your assignment and fact tables
• Configure experiments to use this assignment table