Using Snowflake as a destination - Kameleoon Documentation

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:

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

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

What “Use Snowflake as a Destination” does

Enabling Use Snowflake as a destination will send Kameleoon selected Kameleoon events to 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. Three event types are supported, each stored in its own table. Experiment exposure events are stored in kameleoon_experiment_event:

sqlCREATE 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
);
Conversion events are stored in kameleoon_conversion_event:
sqlCREATE TABLE kameleoon_conversion_event (
    nonce                   BIGINT PRIMARY KEY,  -- unique identifier of the event
    timestamp               BIGINT,              -- timestamp in millis of the event
    visitor_code            VARCHAR,             -- Kameleoon visitor identifier
    custom_visitor_id       VARCHAR,             -- visitor identifier used by your company
    goal_id                 BIGINT,              -- Kameleoon id of the goal
    revenue                 FLOAT,               -- revenue associated with the conversion
    negative                BOOLEAN,             -- negative set to true means that this event cancels a previous conversion
    metadata_id_to_values   OBJECT               -- map of goal metadata IDs to the set of values taken by that metadata
);
Custom data events are stored in kameleoon_custom_data_event:
sqlCREATE TABLE kameleoon_custom_data_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
    index                   BIGINT,              -- index of the custom data
    count_by_value          OBJECT,              -- map of values taken by this custom dats to their occurrence counts
    overwrite               BOOLEAN,             -- whether the value overwrites previous data within the session
    mapping_identifier      BOOLEAN              -- whether the index uses a mapping identifier
);

The custom_visitor_id field is populated from the Cross Device Reconciliation custom data, if it has been set. Experiment exposure events are enabled by default. Conversion and custom data event collection are a new feature that should be considered subject to change and are not configurable via the UI and must be activated by contacting the Kameleoon support team.

​Activate Snowflake as a destination

​What “Use Snowflake as a Destination” does

Activate Snowflake as a destination

What “Use Snowflake as a Destination” does