IntegrationsData ExportWarehouse Data Export

Warehouse Data Export schema reference

Overview

This topic explains the different event kinds for warehouse Data Export destinations. The schemas for warehouse Data Export destinations are formatted differently than LaunchDarkly’s streaming Data Export integrations.

Evaluation events

The evaluation_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. Evaluations that occurred as an experiment exposure include an experiment_iteration_id.

Column nameTypeExampleDescription
event_id

string (BigQuery, Databricks)
varchar (Snowflake)

671a6cc51ac07d3f1be70ab2The ID of the event.
flag_key

string (BigQuery, Databricks)
varchar (Snowflake)

flag-keyThe key of the feature flag requested.
context_key

string (BigQuery, Databricks)
varchar (Snowflake)

user-key-123abcThe key of the context that the flag was evaluated for.
context_kind

string (BigQuery, Databricks)
varchar (Snowflake)

userThe kind of the context that the flag was evaluated for.
context_attributes

JSON (BigQuery)
string (Databricks)
variant (Snowflake)

{ "attribute_name": "attribute_value" }The attributes of the context that the flag was evaluated for.
variation_id

string (BigQuery, Databricks)
varchar (Snowflake)

e4959af7-0481-4878-b9c3-a3075c1cf685The ID of the variation of the flag requested.
variation_value

JSON (BigQuery)
string (Databricks)
variant (Snowflake)

falseThe value of the variation that the flag served.
reason_kind (optional)

string (BigQuery, Databricks)
varchar (Snowflake)

FALLTHROUGHThe 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)
variant (Snowflake)

{ "in_experiment": true }Other attributes detailing the reason for the flag variation.
experiment_iteration_id

string (BigQuery, Databricks)
varchar (Snowflake)

14e2dff3-cbf9-4ffc-b99e-88c83555f4c6The ID of an associated experiment iteration. Included only if the flag was evaluated as an experiment exposure.
received_timetimestamp2024-10-22T17:00:00ZThe time (UTC) the evaluation event was received in second precision.
created_timetimestamp2024-10-22T17:00:00.000ZThe time (UTC) the evaluation event was created in millisecond precision.
environment_id

string (BigQuery, Databricks)
varchar (Snowflake)

671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.
export_key (primary key)

string (BigQuery, Databricks)
varchar (Snowflake)

ceec8d94-2a31-4981-9a20-1fb7f5cb44e3This key is generated by hashing the combined event_id, context_kind, and context_key.

Metric events

The metric_events table includes custom metric events, which the SDK produces when the client application calls the SDK’s track method.

Column nameTypeExampleDescription
event_id

string (BigQuery, Databricks)
varchar (Snowflake)

671a6cd294bbf76b5dfdd870The ID of the event.
kind

string (BigQuery, Databricks)
varchar (Snowflake)

customThe kind of the event. Only custom metric events are available.
context_kind

string (BigQuery, Databricks)
varchar (Snowflake)

userThe kind of the context for the metric event.
context_key

string (BigQuery, Databricks)
varchar (Snowflake)

user-key-123abcThe key of the context for the metric event.
context_attributes

JSON (BigQuery)
string (Databricks)
variant (Snowflake)

{ "attribute_name": "attribute_value" }The attributes of the context for the metric event.
event_key

string (BigQuery, Databricks)
varchar (Snowflake)

order-placedThe event key.
event_value (optional)float3.1The event value.
data (optional)

JSON (BigQuery)
string (Databricks)
variant (Snowflake)

{ "some-key": "customer-provided-data" }Custom data attached to the event.
received_timetimestamp2024-10-22T17:00:00ZThe time (UTC) the metric event was received in second precision.
created_timetimestamp2024-10-22T17:00:00.000ZThe time (UTC) the metric event was created in millisecond precision.
environment_id

string (BigQuery, Databricks)
varchar (Snowflake)

671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.
export_key (primary key)

string (BigQuery, Databricks)
varchar (Snowflake)

16aa074e-d311-4bd8-90cc-2ea5f7924a8fThis key is generated by hashing the combined event_id, context_kind, and context_key.

Experiment iterations

The experiment_iterations table includes metadata about the experiment iterations created for your LaunchDarkly environment.

Column nameTypeExampleDescription
iteration_id (primary key)

string (BigQuery, Databricks)
varchar (Snowflake)

14e2dff3-cbf9-4ffc-b99e-88c83555f4c6The ID of the experiment iteration.
iteration_numbernumber1The experiment iteration number.
experiment_id

string (BigQuery, Databricks)
varchar (Snowflake)

4f045bb9-d853-4cfe-af06-299f96480119The ID of the experiment.
experiment_name

string (BigQuery, Databricks)
varchar (Snowflake)

My sales volume experimentThe name of the experiment.
randomization_unit

string (BigQuery, Databricks)
varchar (Snowflake)

userThe context kind chosen as the randomization unit for the experiment.
started_attimestamp2024-10-22T15:00:00ZThe start time (UTC) of the experiment.
ended_at (optional)timestampnullThe end time (UTC) of the experiment.
updated_attimestamp2024-10-22T15:00:00ZThe time (UTC) that this iteration or experiment was last updated.
environment_id

string (BigQuery, Databricks)
varchar (Snowflake)

671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.

Experiment arm parameters

The experiment_arm_parameters table includes metadata about the experiment arms you created for your experiments, including the flag variations configured for them.

Column nameTypeExampleDescription
arm_id

string (BigQuery, Databricks)
varchar (Snowflake)

62c977b6-6b1d-4559-9326-7b2be677c30eThe ID of the experiment arm.
arm_name

string (BigQuery, Databricks)
varchar (Snowflake)

controlThe name of the experiment arm.
experiment_iteration_id

string (BigQuery, Databricks)
varchar (Snowflake)

14e2dff3-cbf9-4ffc-b99e-88c83555f4c6The ID of the experiment iteration.
flag_variation_id

string (BigQuery, Databricks)
varchar (Snowflake)

e4959af7-0481-4878-b9c3-a3075c1cf685The ID of the flag variation configured for the experiment arm.
flag_variation_value

JSON (BigQuery)
string (Databricks)
variant (Snowflake)

falseThe value of the flag variation.
is_arm_baselinebooleantrueWhether the experiment arm is the baseline.
updated_attimestamp2024-10-22T15:00:00ZThe time (UTC) that this experiment arm was last updated.
environment_id

string (BigQuery, Databricks)
varchar (Snowflake)

671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.
export_key (primary key)

string (BigQuery, Databricks)
varchar (Snowflake)

d1628066-49c7-45a9-ad7f-03339fc76245This key is generated by hashing the combined arm_id and variation_id.

Flag variations

The flag_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 nameTypeExampleDescription
variation_id (primary key)

string (BigQuery, Databricks)
varchar (Snowflake)

e4959af7-0481-4878-b9c3-a3075c1cf685The ID of the flag variation.
variation_name (optional)

string (BigQuery, Databricks)
varchar (Snowflake)

controlThe name of the flag variation.
variation_value

JSON (BigQuery)
string (Databricks)
variant (Snowflake)

falseThe value of the flag variation.
flag_key

string (BigQuery, Databricks)
varchar (Snowflake)

flag-key-123bcThe key of the feature flag.
flag_name

string (BigQuery, Databricks)
varchar (Snowflake)

My boolean flagThe name of the feature flag.
updated_attimestamp2024-10-22T14:00:00ZThe time (UTC) the the flag or variation was last updated.
environment_id

string (BigQuery, Databricks)
varchar (Snowflake)

671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.

LaunchDarkly internal tables

Tables prefixed with ld_internal_ are for LaunchDarkly internal use only, and are subject to change without warning.