Winning Variant will maintain a view for each resource type (lab, experiment, subject type) as they are created/updated within the platform. These may be used for joins against the primary Assignments View to retrieve context for the assignments.

It’s important to know that each view shows only the current version/state of a resources.

Application Roles

A user must be mapped to one of the following application roles to access dimension views

  • admin
  • editor
  • analyst

Views

Labs

View: <application_name>.experimentation.labs

Unique key: id

FieldDescriptionData Type
idUnique ID for the labvarchar
resource_versionCurrent resource versionint
statusCurrent statusResourceStatus
nameName of the labvarchar
descriptionResource descriptionvarchar

Subject Types

View: <application_name>.experimentation.subject_types

Unique key: id

FieldDescriptionData Type
idUnique ID for the subject typevarchar
resource_versionCurrent resource versionint
statusCurrent statusResourceStatus
nameName of the subject typevarchar
descriptionResource descriptionvarchar
match_typeThe match type for the subject type.MatchType

Experiments

View: <application_name>.experimentation.experiments

Unique key: id

FieldDescriptionData Type
idUnique ID for the experimentvarchar
resource_versionCurrent resource versionint
statusCurrent statusResourceStatus
nameName of the experimentvarchar
descriptionResource descriptionvarchar
parent_lab_idID of the lab the experiment belongs within.varchar
subject_type_idID of the subject type this experiment uses.varchar
hypothesisThe experiment hypothesis.varchar
active_cohortIndex for the active cohort.int
winning_variantIf specified, the ID of the winning variant.varchar
ended_reasonThe reason the experiment was ended, if applicable.EndedReason

Experiment Variants

View: <application_name>.experimentation.experiment_variants

One row for each experiment-variant combo. Unique key: (experiment,id)

FieldDescriptionData Type
experiment_idID of the experiment this variant belongs to.varchar
variant_idID of the variant.varchar
is_controlWhether this variant is the control within the experiment.bool
nameVariant namevarchar
descriptionVariant descriptionvarchar

Experiment Cohort-Variants

View: <application_name>.experimentation.experiment_cohorts

One row for each experiment-cohort-variant combo. Unique key: (experiment_id,cohort_index,variant_id) .

Note that experiment variants may be listed redundantly since they can exist within multiple experiment cohorts. As such, all variant_id values in this table are within the context of the experiment to which they belong.

Within an experiment, the cohort with the highest cohort_index is the active one.

FieldDescriptionData Type
experiment_idID of the experiment this cohort-variant belongs to.varchar
cohort_indexUnique integer assigned to the cohort within its experiment.int
variant_idID of the variant (within its experiment)varchar
splitPercentage of traffic that should see the variant (within the cohort). E.g., 0.500number(5,4)
created_atTimestamp of when the cohort was createdtimestamp

Examples

List all active experiments

SELECT * FROM <application_name>.experimentation.experiments
WHERE status = 'active';