Skip to main content

Using Snowflake as a destination

caution

The credentials must be provided using the Key-Pair authentication option, not the Password option.

Activate Snowflake as a destination​

Once you have enabled the Snowflake integration for your project, 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.

  1. Provide the Snowflake project ID associated with your Google Snowflake project.
  2. 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, in a table called kameleoon_experiment_event.

The following is the table's SQL schema:

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, if it has been set.