Skip to main content

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.

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.