Skip to main content
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. For more complex queries you can adhere to this format by formulating a sub-query as such: 
SELECT visitor_id, conversion_timestamp, revenue FROM ( {your_original_query} ) AS subquery
Your query will run every hour in your Snowflake warehouse, with an added WITH clause that filters by timestamps. Keep in mind that although conversions are collected hourly, they are only merged into your experiment results once per day.

​
Run your query before ingestion

Before saving your ingestion task, you can test your query directly in Kameleoon. Testing allows you to:
  • Verify the connection in real time.
  • Confirm your credentials and access rights are correct, which helps detect issues immediately, without having to wait for the first data import.
  • Validate your data’s structure and accessibility.
You can run a simple query to ensure Kameleoon can access the right databases and tables. You can also download a small sample of the dataset to confirm that the schema, permissions, and contents match your expectations.

​
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.