Use Databricks as a destination

Stream Kameleoon experiment exposure events into Databricks to enable centralized analysis and reporting of campaign results.

Once you have enabled the Databricks integration for your project, you can activate Use Databricks as a destination to seamlessly send events to your Databricks account whenever one of your Kameleoon experiments exposes visitors.

Activate Databricks as a destination

To activate Databricks as a destination:

1. Click Use Databricks as a destination.
2. Databricks catalog: name of the Databricks “catalog” that contains the Kameleoon schema to write to (the top level folder).
3. Schema: Schema containing the tables this ingestion task queries from.

What “Use Databricks as a destination” does

Enabling Use Databricks as a destination streams all Kameleoon experiment exposure events into Databricks.

Kameleoon stores events in the kameleoon_events schema of your Databricks catalog, containing the tables this ingestion task queries from. This catalog is the one you set up during setup, with write access granted to the Kameleoon user. Kameleoon saves the data in a table named kameleoon_experiment_event.

The SQL schema of this table is the following:

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
 );

Kameleoon reads the custom_visitor_id from the Cross Device Reconciliation custom data, if you set it.

With campaign data stored in Databricks, you gain the ability to perform in-depth analysis and reporting. You can leverage Databricks’s querying capabilities to extract valuable insights from the collected data, helping you make data-driven decisions to optimize your campaigns and user experience.

By centralizing Kameleoon campaign results in Databricks, you contribute to the enrichment of your Databricks database, making it a comprehensive repository of user data that you can use for a variety of analytical and business intelligence purposes.