IntegrationsData ExportSnowflake Data Export

Snowflake Data Export schema reference

This integration is not available in LaunchDarkly's European Union (EU) instance
To learn more, read LaunchDarkly in the European Union (EU).

Overview

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

To learn more about the Snowflake destination, read Snowflake’s documentation.

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_idvarchar671a6cc51ac07d3f1be70ab2The ID of the event.
flag_keyvarcharflag-keyThe key of the feature flag requested.
context_keyvarcharuser-key-123abcThe key of the context that the flag was evaluated for.
context_kindvarcharuserThe kind of the context that the flag was evaluated for.
context_attributesvariant{ "attribute_name": "attribute_value" }The attributes of the context that the flag was evaluated for.
variation_idvarchare4959af7-0481-4878-b9c3-a3075c1cf685The ID of the variation of the flag requested.
variation_valuevariantfalseThe value of the variation that the flag served.
reason_kind (optional)varcharFALLTHROUGHThe 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)variant{ "in_experiment": true }Other attributes detailing the reason for the flag variation.
experiment_iteration_idvarchar14e2dff3-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_idvarchar671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.
export_key (primary key)varcharceec8d94-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_idvarchar671a6cd294bbf76b5dfdd870The ID of the event.
kindvarcharcustomThe kind of the event. Only custom metric events are available.
context_kindvarcharuserThe kind of the context for the metric event.
context_keyvarcharuser-key-123abcThe key of the context for the metric event.
context_attributesvariant{ "attribute_name": "attribute_value" }The attributes of the context for the metric event.
event_keyvarcharorder-placedThe event key.
event_value (optional)float3.1The event value.
data (optional)variant{ "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_idvarchar671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.
export_key (primary key)varchar16aa074e-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)varchar14e2dff3-cbf9-4ffc-b99e-88c83555f4c6The ID of the experiment iteration.
iteration_numbernumber1The experiment iteration number.
experiment_idvarchar4f045bb9-d853-4cfe-af06-299f96480119The ID of the experiment.
experiment_namevarcharMy sales volume experimentThe name of the experiment.
randomization_unitvarcharuserThe 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_idvarchar671874fe99197c658ae2cbd2The 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_idvarchar62c977b6-6b1d-4559-9326-7b2be677c30eThe ID of the experiment arm.
arm_namevarcharcontrolThe name of the experiment arm.
experiment_iteration_idvarchar14e2dff3-cbf9-4ffc-b99e-88c83555f4c6The ID of the experiment iteration.
flag_variation_idvarchare4959af7-0481-4878-b9c3-a3075c1cf685The ID of the flag variation configured for the experiment arm.
flag_variation_valuevariantfalseThe 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_idvarchar671874fe99197c658ae2cbd2The client-side ID for the LaunchDarkly environment.
export_key (primary key)varchard1628066-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)varchare4959af7-0481-4878-b9c3-a3075c1cf685The ID of the flag variation.
variation_name (optional)varcharcontrolThe name of the flag variation.
variation_valuevariantfalseThe value of the flag variation.
flag_keyvarcharflag-key-123bcThe key of the feature flag.
flag_namevarcharMy boolean flagThe name of the feature flag.
updated_attimestamp2024-10-22T14:00:00ZThe time (UTC) the the flag or variation was last updated.
environment_idvarchar671874fe99197c658ae2cbd2The 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.