> ## Documentation Index
> Fetch the complete documentation index at: https://launchdarkly-preview.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Warehouse Data Export schema reference

> This topic explains the different event kinds for warehouse Data Export destinations.

> For the complete documentation index, see [llms.txt](/llms.txt). For the full documentation snapshot, see [llms-full.txt](/llms-full.txt).

## 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](/integrations/data-export/schema-reference).

## 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 name

\| Type

\| Example

| Description |
| - |

\| ---

\| ---

\| --- |
\| event\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `671a6cc51ac07d3f1be70ab2`

\| The ID of the event. |
\| flag\_key

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `flag-key`

\| The key of the feature flag requested. |
\| context\_key

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `example-user-key`

\| The key of the context that the flag was evaluated for. |
\| context\_kind

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `user`

\| The kind of the context that the flag was evaluated for. |
\| context\_attributes

\| JSON (BigQuery)<br /> string (Databricks)<br /> variant (Snowflake)

\| `{ "attribute_name": "attribute_value" }`

\| The attributes of the context that the flag was evaluated for. |
\| variation\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `e4959af7-0481-4878-b9c3-a3075c1cf685`

\| The ID of the variation of the flag requested. |
\| variation\_value

\| JSON (BigQuery)<br /> string (Databricks)<br /> variant (Snowflake)

\| `false`

\| The value of the variation that the flag served. |
\| reason\_kind (optional)

\| string (BigQuery, Databricks)<br /> varchar (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)<br /> string (Databricks)<br /> variant (Snowflake)

\| `{ "in_experiment": true }`

\| Other attributes detailing the reason for the flag variation. |
\| experiment\_iteration\_id

\| string (BigQuery, Databricks)<br /> varchar (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

\| `2024-10-22T17:00:00Z`

\| The time (UTC) the evaluation event was received in second precision. |
\| created\_time

\| timestamp

\| `2024-10-22T17:00:00.000Z`

\| The time (UTC) the evaluation event was created in millisecond precision. |
\| environment\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `671874fe99197c658ae2cbd2`

\| The client-side ID for the LaunchDarkly environment. |
\| export\_key (primary key)

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `ceec8d94-2a31-4981-9a20-1fb7f5cb44e3`

\| This 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](/sdk/features/events).

\| Column name

\| Type

\| Example

| Description |
| - |

\| ---

\| ---

\| --- |
\| event\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `671a6cd294bbf76b5dfdd870`

\| The ID of the event. |
\| kind

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `custom`

\| The kind of the event. Only custom metric events are available. |
\| context\_kind

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `user`

\| The kind of the context for the metric event. |
\| context\_key

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `example-user-key`

\| The key of the context for the metric event. |
\| context\_attributes

\| JSON (BigQuery)<br /> string (Databricks)<br /> variant (Snowflake)

\| `{ "attribute_name": "attribute_value" }`

\| The attributes of the context for the metric event. |
\| event\_key

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `order-placed`

\| The event key. |
\| event\_value (optional)

\| float

\| `3.1`

\| The event value. |
\| data (optional)

\| JSON (BigQuery)<br /> string (Databricks)<br /> variant (Snowflake)

\| `{ "some-key": "customer-provided-data" }`

\| Custom data attached to the event. |
\| received\_time

\| timestamp

\| `2024-10-22T17:00:00Z`

\| The time (UTC) the metric event was received in second precision. |
\| created\_time

\| timestamp

\| `2024-10-22T17:00:00.000Z`

\| The time (UTC) the metric event was created in millisecond precision. |
\| environment\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `671874fe99197c658ae2cbd2`

\| The client-side ID for the LaunchDarkly environment. |
\| export\_key (primary key)

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `16aa074e-d311-4bd8-90cc-2ea5f7924a8f`

\| This 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 name

\| Type

\| Example

| Description |
| - |

\| ---

\| ---

\| --- |
\| iteration\_id (primary key)

\| string (BigQuery, Databricks)<br /> varchar (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)<br /> varchar (Snowflake)

\| `4f045bb9-d853-4cfe-af06-299f96480119`

\| The ID of the experiment. |
\| experiment\_name

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `My sales volume experiment`

\| The name of the experiment. |
\| randomization\_unit

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `user`

\| The context kind chosen as the randomization unit for the experiment. |
\| started\_at

\| timestamp

\| `2024-10-22T15:00:00Z`

\| The start time (UTC) of the experiment. |
\| ended\_at (optional)

\| timestamp

\| `null`

\| The end time (UTC) of the experiment. |
\| updated\_at

\| timestamp

\| `2024-10-22T15:00:00Z`

\| The time (UTC) that this iteration or experiment was last updated. |
\| environment\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `671874fe99197c658ae2cbd2`

\| The 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 name

\| Type

\| Example

| Description |
| - |

\| ---

\| ---

\| --- |
\| arm\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `62c977b6-6b1d-4559-9326-7b2be677c30e`

\| The ID of the experiment arm. |
\| arm\_name

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `control`

\| The name of the experiment arm. |
\| experiment\_iteration\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `14e2dff3-cbf9-4ffc-b99e-88c83555f4c6`

\| The ID of the experiment iteration. |
\| flag\_variation\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `e4959af7-0481-4878-b9c3-a3075c1cf685`

\| The ID of the flag variation configured for the experiment arm. |
\| flag\_variation\_value

\| JSON (BigQuery)<br /> string (Databricks)<br /> variant (Snowflake)

\| `false`

\| The value of the flag variation. |
\| is\_arm\_baseline

\| boolean

\| `true`

\| Whether the experiment arm is the baseline. |
\| updated\_at

\| timestamp

\| `2024-10-22T15:00:00Z`

\| The time (UTC) that this experiment arm was last updated. |
\| environment\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `671874fe99197c658ae2cbd2`

\| The client-side ID for the LaunchDarkly environment. |
\| export\_key (primary key)

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `d1628066-49c7-45a9-ad7f-03339fc76245`

\| This 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 name

\| Type

\| Example

| Description |
| - |

\| ---

\| ---

\| --- |
\| variation\_id (primary key)

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `e4959af7-0481-4878-b9c3-a3075c1cf685`

\| The ID of the flag variation. |
\| variation\_name (optional)

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `control`

\| The name of the flag variation. |
\| variation\_value

\| JSON (BigQuery)<br /> string (Databricks)<br /> variant (Snowflake)

\| `false`

\| The value of the flag variation. |
\| flag\_key

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `flag-key-123bc`

\| The key of the feature flag. |
\| flag\_name

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `My boolean flag`

\| The name of the feature flag. |
\| updated\_at

\| timestamp

\| `2024-10-22T14:00:00Z`

\| The time (UTC) the flag or variation was last updated. |
\| environment\_id

\| string (BigQuery, Databricks)<br /> varchar (Snowflake)

\| `671874fe99197c658ae2cbd2`

\| The client-side ID for the LaunchDarkly environment. |

## Launch

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