> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kameleoon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Using Snowflake as a destination

> Send Kameleoon experiment exposure events to Snowflake to centralize campaign results and analyze them alongside your existing data.

<Warning>
  The credentials must be provided using the **Key-Pair** authentication option, not the **Password** option.
</Warning>

## Activate Snowflake as a destination

Once you have [enabled the Snowflake integration for your project](./setting-up-snowflake), you can activate **Use Snowflake as a destination** to send the results of your Kameleoon campaigns to Snowflake.

To do so, follow these steps:

1. Within the selected project's configuration, you'll find a section labeled **Use Snowflake as a destination**. Click this section.

<Frame>
  ![](https://storage.googleapis.com/kameleoon-storage-documentation/user-manual/images/integrations/data-warehouses/snowflake/use-snowflake-as-a-destination/image-36.png)
</Frame>

2. Provide the Snowflake project ID associated with your Google Snowflake project.
3. Click **Validate** to save and apply your configuration settings.

## What "Use Snowflake as a Destination" does

Enabling **Use Snowflake as a destination** will send all Kameleoon experiment exposure events to Google Snowflake.

The events will be saved in the `KAMELEOON_EVENTS` schema of the `KAMELEOON` database you created with write access for the user you created for Kameleoon during [setup](./setting-up-snowflake), in a table called `kameleoon_experiment_event`.

The following is the table's SQL schema:

```sql theme={null}
CREATE TABLE  kameleoon_experiment_event (
     nonce  BIGINT  PRIMARY KEY, // unique identifier of the event
   timestamp  BIGINT, // timestamp in millis of the event
     visitor_code  VARCHAR(255), // Kameleoon visitor identifier
   custom_visitor_id  VARCHAR(255), // Visitor identifier used by your company
     experiment_id  BIGINT, // Kameleoon id of the experiment
     variation_id  BIGINT // Kameleoon id of the variation
 );
```

The `custom_visitor_id` is read from the [Cross Device Reconciliation custom data](../../../../developer-docs/cross-device-experimentation), if it has been set.