Skip to main content

Using Snowflake as a source — pulling events for reporting

note

This integration is in beta. Some functionalities, such as the ability to process Snowflake metrics with our statistical engine, may be added before it reaches general availability.

Once you've activated Snowflake for a specific project, you can use it to create goals in Kameleoon. These goals are designed to use conversion data from your Snowflake database. Here's how to create a goal using Snowflake:

  1. In Kameleoon, click Configure > Goals.

  1. Click New goal.

  1. In the pop-in, provide the following details:
  • Name: Give your goal a descriptive name to identify its purpose.
  • Type: Select Data Warehouse Tracking.
  • Data Warehouse: Choose Snowflake.
  • Project: Select your desired projects. Only projects with Snowflake activated are listed.
  1. Click Next to proceed.
  2. In the next window, you must provide additional details:
  • Frequency: Define how often you want Kameleoon to update the goal data.
  • Snowflake project ID: Enter your Snowflake project ID to direct data to the correct location.
  • Region: Select the appropriate region from the list.
  • Query: Define the SQL query to retrieve the necessary data from Snowflake.
  1. Click Validate to save your goal configuration.

Query format​

The query must adhere to a specific format:

SELECT visitor_id, conversion_timestamp FROM your_events_table

Where visitor_id is the column representing the unique ID of your visitors, and conversion_timestamp is a column representing the exact time at which the conversion took place. In Snowflake, the conversion_timestamp column must be a Timestamp type column.

If you want to associate a revenue to each conversion, the query should adhere to an alternate format:

SELECT visitor_id, conversion_timestamp, revenue FROM your_events_table

Where revenue is a column containing the revenue for each conversion.

Using your Snowflake goal​

After activating Snowflake for a project, you can use it to create goals in Kameleoon and pull conversion data directly from your Snowflake database. Once a goal is created, you can add it to your Kameleoon campaigns. When configuring an experiment or personalization, you can select this goal in the Configuration tab to track and analyze conversions from Snowflake.

To learn how to set up a goal in an experiment, please refer to this article.