Evaluation events
Theevaluation_events table includes details for each individual feature flag evaluation. The schema fans out flag evaluations with multi-contexts into separate rows, one for each context kind. Evaluations that occurred as an experiment exposure include an experiment_iteration_id.
| Column name | Type | Example | Description |
|---|---|---|---|
| event_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 671a6cc51ac07d3f1be70ab2 | The ID of the event. |
| flag_key | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | flag-key | The key of the feature flag requested. |
| context_key | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | example-user-key | The key of the context that the flag was evaluated for. |
| context_kind | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | user | The kind of the context that the flag was evaluated for. |
| context_attributes | JSON (BigQuery) string (Databricks) super (Redshift) variant (Snowflake) | { "attribute_name": "attribute_value" } | The attributes of the context that the flag was evaluated for. |
| variation_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | e4959af7-0481-4878-b9c3-a3075c1cf685 | The ID of the variation of the flag requested. |
| variation_value | JSON (BigQuery) string (Databricks) super (Redshift) variant (Snowflake) | false | The value of the variation that the flag served. |
| reason_kind (optional) | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | FALLTHROUGH | The reason a context instance receives a given flag variation. Included only if the flag being evaluated was in an experiment and the target was part of the experiment allocation, or if you called a variation detail method. |
| reason_detail (optional) | JSON (BigQuery) string (Databricks) super (Redshift) variant (Snowflake) | { "in_experiment": true } | Other attributes detailing the reason for the flag variation. |
| experiment_iteration_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 14e2dff3-cbf9-4ffc-b99e-88c83555f4c6 | The ID of an associated experiment iteration. Included only if the flag was evaluated as an experiment exposure. |
| received_time | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T17:00:00Z | The time (UTC) the evaluation event was received in second precision. |
| created_time | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T17:00:00.000Z | The time (UTC) the evaluation event was created in millisecond precision. |
| environment_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 671874fe99197c658ae2cbd2 | The client-side ID for the LaunchDarkly environment. |
| export_key (primary key) | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | ceec8d94-2a31-4981-9a20-1fb7f5cb44e3 | This key is generated by hashing the combined event_id, context_kind, and context_key. |
Metric events
Themetric_events table includes custom metric events, which the SDK produces when the client application calls the SDK’s track method. The schema fans out metric events with multi-contexts into separate rows, one for each context kind.
| Column name | Type | Example | Description |
|---|---|---|---|
| event_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 671a6cd294bbf76b5dfdd870 | The ID of the event. |
| kind | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | custom | The kind of the event. Only custom metric events are available. |
| context_kind | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | user | The kind of the context for the metric event. |
| context_key | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | example-user-key | The key of the context for the metric event. |
| context_attributes | JSON (BigQuery) string (Databricks) super (Redshift) variant (Snowflake) | { "attribute_name": "attribute_value" } | The attributes of the context for the metric event. |
| event_key | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | order-placed | The event key. |
| event_value (optional) | float (BigQuery, Databricks, Snowflake) double precision (Redshift) | 3.1 | The event value. |
| data (optional) | JSON (BigQuery) string (Databricks) super (Redshift) variant (Snowflake) | { "some-key": "customer-provided-data" } | Custom data attached to the event. |
| received_time | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T17:00:00Z | The time (UTC) the metric event was received in second precision. |
| created_time | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T17:00:00.000Z | The time (UTC) the metric event was created in millisecond precision. |
| environment_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 671874fe99197c658ae2cbd2 | The client-side ID for the LaunchDarkly environment. |
| export_key (primary key) | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 16aa074e-d311-4bd8-90cc-2ea5f7924a8f | This key is generated by hashing the combined event_id, context_kind, and context_key. |
Experiment iterations
Theexperiment_iterations table includes metadata about the experiment iterations created for your LaunchDarkly environment.
| Column name | Type | Example | Description |
|---|---|---|---|
| iteration_id (primary key) | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 14e2dff3-cbf9-4ffc-b99e-88c83555f4c6 | The ID of the experiment iteration. |
| iteration_number | number | 1 | The experiment iteration number. |
| experiment_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 4f045bb9-d853-4cfe-af06-299f96480119 | The ID of the experiment. |
| experiment_name | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | My sales volume experiment | The name of the experiment. |
| randomization_unit | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | user | The context kind chosen as the randomization unit for the experiment. |
| started_at | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T15:00:00Z | The start time (UTC) of the experiment. |
| ended_at (optional) | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | null | The end time (UTC) of the experiment. |
| updated_at | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T15:00:00Z | The time (UTC) that this iteration or experiment was last updated. |
| environment_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 671874fe99197c658ae2cbd2 | The client-side ID for the LaunchDarkly environment. |
Experiment arm parameters
Theexperiment_arm_parameters table includes metadata about the experiment arms you created for your experiments, including the flag variations configured for them.
| Column name | Type | Example | Description |
|---|---|---|---|
| arm_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 62c977b6-6b1d-4559-9326-7b2be677c30e | The ID of the experiment arm. |
| arm_name | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | control | The name of the experiment arm. |
| experiment_iteration_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 14e2dff3-cbf9-4ffc-b99e-88c83555f4c6 | The ID of the experiment iteration. |
| flag_variation_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | e4959af7-0481-4878-b9c3-a3075c1cf685 | The ID of the flag variation configured for the experiment arm. |
| flag_variation_value | JSON (BigQuery) string (Databricks) super (Redshift) variant (Snowflake) | false | The value of the flag variation. |
| is_arm_baseline | boolean | true | Whether the experiment arm is the baseline. |
| updated_at | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T15:00:00Z | The time (UTC) that this experiment arm was last updated. |
| environment_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 671874fe99197c658ae2cbd2 | The client-side ID for the LaunchDarkly environment. |
| export_key (primary key) | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | d1628066-49c7-45a9-ad7f-03339fc76245 | This key is generated by hashing the combined arm_id and flag_variation_id. |
Flag variations
Theflag_variations table includes metadata about your feature flags and their flag variations. Fields on this table are mutable, and the exported table will be updated to reflect their most up-to-date states. At this time, cloned flags and their variations are missing from the exported data.
| Column name | Type | Example | Description |
|---|---|---|---|
| variation_id (primary key) | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | e4959af7-0481-4878-b9c3-a3075c1cf685 | The ID of the flag variation. |
| variation_name (optional) | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | control | The name of the flag variation. |
| variation_value | JSON (BigQuery) string (Databricks) super (Redshift) variant (Snowflake) | false | The value of the flag variation. |
| flag_key | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | flag-key-123bc | The key of the feature flag. |
| flag_name | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | My boolean flag | The name of the feature flag. |
| updated_at | timestamp (BigQuery, Databricks, Snowflake) timestamptz (Redshift) | 2024-10-22T14:00:00Z | The time (UTC) the flag or variation was last updated. |
| environment_id | string (BigQuery, Databricks) varchar (Redshift, Snowflake) | 671874fe99197c658ae2cbd2 | The client-side ID for the LaunchDarkly environment. |
LaunchDarkly internal tables
Tables prefixed withld_internal_ are for LaunchDarkly internal use only, and are subject to change without warning.