Skip to main content
PATCH
/
v1
/
assignmentTables
/
{assignmentTable}
Update AssignmentTable
curl --request PATCH \
  --url https://metrics.eu.confidence.dev/v1/assignmentTables/{assignmentTable} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{}'
{
  "sql": "<string>",
  "displayName": "<string>",
  "entityColumn": {},
  "timestampColumn": {},
  "exposureKeyColumn": {},
  "variantKeyColumn": {},
  "state": {},
  "schemaValidationJob": "<string>",
  "createTime": {},
  "updateTime": {},
  "creator": "<string>",
  "updater": "<string>",
  "name": "<string>",
  "description": "<string>",
  "timestampTruncation": {},
  "dimensions": [
    {}
  ],
  "assignmentDataDeliveredUntilTime": {},
  "partitionedUpdateStrategyState": {},
  "error": {},
  "dataDeliveredUntilUpdateStrategyConfig": {},
  "deleteTime": {},
  "labels": [
    {}
  ],
  "owner": "<string>",
  "systemCreated": true
}

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

assignmentTable
string
required

Query Parameters

updateMask
object

The list of fields to update. Fields are specified relative to the AssignmentTable (e.g. display_name, sql; not assignment_table.display_name or assignment_table.sql).

Body

application/json

The body is of type object.

Response

200 - application/json

OK

An assignment table is a description of a dataset of how entities have been assigned to variants.

sql
string
required

A data warehouse-specific query to get the data of the assignment table.

displayName
string
required

Human friendly name of the assignment table.

entityColumn
object
required

The column of the assignment table that represents the entity

timestampColumn
object
required

The column of the assignment table that represents the time the assignment occurred.

exposureKeyColumn
object
required

The column of the table that represents what the group of variants that the entity was assigned to, this would typically be the rule id or the flag name.

variantKeyColumn
object
required

The column of the table that represents the variant that was assigned.

state
object
required

The current state of the assignment table.

schemaValidationJob
string
required

Resource name of the sql job that was used to validate the schema of the fact table.

createTime
object
required

Time when the assignment table was first created.

updateTime
object
required

Time when the assignment table was last updated.

creator
string
required

Reference to the identity that created this assignment table.

updater
string
required

Reference to the identity that last updated this assignment table.

name
string

Unique identifier of the assignment table. For example: assignmentTables/0smva5nxuhv4yts6paxt

description
string

Human readable description of the assignment table.

timestampTruncation
object

Defines how time is truncated in the timestamp column.

dimensions
object[]

Mapping between columns and dimensions of the entities.

assignmentDataDeliveredUntilTime
object

The current maximum time point where there is available data for the assignment table.

partitionedUpdateStrategyState
object
error
object

Indicates whether an errors has occurred.

dataDeliveredUntilUpdateStrategyConfig
object

The strategy for updating assignment_data_delivered_until_time in the assignment table.

deleteTime
object

Time when the assignment table was deleted.

labels
object[]

Custom labels for this assignment table.

owner
string

The owner of the resource. If not set will default to the creator.

systemCreated
boolean

If this table is an automatically created internal table.