Sign up and get started with Confidence today! Create your account
Get Started
Feature Flags
Metrics
Stats
Experiments
Surfaces
IAM
Connectors
Sign up and get started with Confidence today! Create your account
AssignmentTable
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.
An assignment table is a description of a dataset of how entities have been assigned to variants.
A data warehouse-specific query to get the data of the assignment table.
Human friendly name of the assignment table.
The column of the assignment table that represents the entity
Show child attributes
Show child attributes
The column of the assignment table that represents the time the assignment occurred.
Show child attributes
Show child attributes
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.
Show child attributes
Show child attributes
The column of the table that represents the variant that was assigned.
Show child attributes
Show child attributes
The current state of the assignment table.
TABLE_STATE_UNSPECIFIED, TABLE_STATE_CREATING, TABLE_STATE_ACTIVE, TABLE_STATE_FAILED, TABLE_STATE_UPDATING, TABLE_STATE_DELETED Resource name of the sql job that was used to validate the schema of the fact table.
Time when the assignment table was first created.
Time when the assignment table was last updated.
Reference to the identity that created this assignment table.
Reference to the identity that last updated this assignment table.
Unique identifier of the assignment table.
For example: assignmentTables/0smva5nxuhv4yts6paxt
Human readable description of the assignment table.
Defines how time is truncated in the timestamp column.
Show child attributes
Show child attributes
Mapping between columns and dimensions of the entities.
Show child attributes
Show child attributes
The current maximum time point where there is available data for the assignment table.
Show child attributes
Show child attributes
Indicates whether an errors has occurred.
Show child attributes
Show child attributes
The strategy for updating assignment_data_delivered_until_time in the
assignment table.
Show child attributes
Show child attributes
Time when the assignment table was deleted.
Custom labels for this assignment table.
Show child attributes
Show child attributes
The owner of the resource. If not set will default to the creator.
If this table is an automatically created internal table.
Was this page helpful?
{
"sql": "<string>",
"displayName": "<string>",
"entityColumn": {
"name": "<string>",
"type": "COLUMN_TYPE_UNSPECIFIED",
"repeated": true
},
"timestampColumn": {
"name": "<string>",
"type": "COLUMN_TYPE_UNSPECIFIED",
"repeated": true
},
"exposureKeyColumn": {
"name": "<string>",
"type": "COLUMN_TYPE_UNSPECIFIED",
"repeated": true
},
"variantKeyColumn": {
"name": "<string>",
"type": "COLUMN_TYPE_UNSPECIFIED",
"repeated": true
},
"state": "TABLE_STATE_UNSPECIFIED",
"schemaValidationJob": "<string>",
"createTime": {},
"updateTime": {},
"creator": "<string>",
"updater": "<string>",
"name": "<string>",
"description": "<string>",
"dimensions": [
{
"name": "<string>",
"type": "COLUMN_TYPE_UNSPECIFIED",
"repeated": true
}
],
"assignmentDataDeliveredUntilTime": {},
"partitionedUpdateStrategyState": {
"currentPartitionLastCheckTime": {},
"existsCheckDuration": {},
"state": "STATE_UNSPECIFIED",
"usualLateness": {},
"count": 123
},
"error": {
"message": "<string>",
"details": [
"<string>"
]
},
"deleteTime": {},
"labels": [
{}
],
"owner": "<string>",
"systemCreated": true
}