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.

With the Amazon Redshift integration, you can streamline data retrieval for targeted campaigns and personalized user experiences. Key benefits:
  • Enables accurate data collection, improving audience targeting for campaigns customized to meet specific audience needs and preferences.
  • Configure Data Ingestion Tasks to extract data from Redshift efficiently.
Data warehouse integrations are available as a premium add-on for our Web Experimentation and Feature Experimentation module. For more information, please contact your Customer Success Manager.
Once you have enabled the Amazon Redshift integration for your project, you can activate Use Amazon Redshift as a source to access and use data stored in Amazon Redshift within your Kameleoon campaigns. Activating Use Amazon Redshift as a source lets you harness the power of Amazon Redshift’s data by configuring Data Ingestion Tasks. These tasks regularly retrieve specific data from Amazon Redshift based on your defined SQL queries and frequencies. The data collected through these tasks can then be used as targeting conditions in your Kameleoon campaigns.
  1. Activate the Feature: In the selected project’s configuration, check the checkbox labeled Use Amazon Redshift as a source.
  2. Create Data Ingestion Tasks: With the feature activated, you can create Data Ingestion Tasks. These tasks regularly retrieve specific data from Amazon Redshift based on your defined SQL queries and frequencies. To create a new Data Ingestion Task, click Add new task.
  3. Validate: After providing the required information for the Data Ingestion Task, click Confirm to create the task. You can create additional tasks by repeating the steps of naming the task, defining the SQL query, and setting the frequency. Once you’ve configured your tasks, click Validate to save and apply your configuration settings.
  4. Create a custom data: Now that you’ve created your Data Ingestion Task, our servers will start collecting data based on the frequency you configured by executing the query on your Amazon Redshift instance. To start using the collected data, you must create a custom data.
  5. Create a segment: The last step to target users based on the collected data is creating a segment based on your custom data.

​
Data Ingestion Tasks

Data Ingestion Tasks are essential components of the Amazon Redshift integration within Kameleoon. Data collected by Data Ingestion Tasks can be utilized as targeting conditions within your Kameleoon campaigns.

​
Creating a Data Ingestion Task

To create a Data Ingestion Task:
  1. Click Add new task.
  2. Complete the form:
    • Name (Required): Give your task a unique and descriptive name to identify its purpose.
    • Redshift cluster type (Required): Specify if your Redshift cluster is provisioned or serverless. If you choose “provisioned”, you will be asked to provide your cluster identifier. If you choose “serverless”, you will be asked to provide your cluster’s namespace and workgroup.
    • Redshift AWS region (Required): Your Redshift cluster’s region code. You can find this in your AWS console. Example: us-west-2.
    • Database (Required): Name of the Redshift database containing the data you are ingesting.
    • Frequency (Required): Specify how often you want the task to run and retrieve data from BigQuery (for example, per day).
    • Query (Required): Provide the SQL query that retrieves the audience from your Amazon Redshift database. The query must follow this specific format: SELECT visitor_id, attribute_1, .. attribute_N FROM your_events_table.
    • attribute_ fields: These are optional and can be used for advanced targeting scenarios. Learn more about these advanced use cases here.
    • visitor_id: This column represents your visitors’ unique identifier.
Column names can only contain letters, numbers, and underscores (_). They cannot start with a number.Columns must appear in the exact order specified (visitor_id followed by optional attributes) for the integration to function correctly.
  1. Once you’ve provided the information, click Confirm to create the Data Ingestion Task.

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

​
Updating a Data Ingestion Task

To update a Data Ingestion Task:
  1. Select the Task: Select a Data Ingestion Task from the dropdown menu.
  2. Edit Task details: Modify the fields you want to update, such as the task’s name, frequency, Amazon Redshift project ID, region, or query.
  3. Confirm changes: Click Confirm to save the changes to the Data Ingestion Task.

​
Deleting a Data Ingestion Task

To delete a Data Ingestion Task:
  1. Select the Task: Select a Data Ingestion Task from the dropdown menu.
  2. Initiate deletion: Click Delete ingestion task.
  3. Confirm deletion: Click Confirm to delete the selected Data Ingestion Task.
Once you have created your Data Ingestion Task, the Kameleoon platform will start polling your warehouse, and the data will be available right away for targeting your users in Kameleoon campaigns. You can use the polled data using our Activation API for web experiments and our SDKs for feature experimentation.

​
Targeting your imported audiences

Learn how to target your warehouse audiences