If you cannot find the data type you need then type in the data type you wish to cast the column as. Upon changing a column's data type the SQL that is generated is executed. If there is an error, it is displayed in the preview section as shown below, this was triggered by attempting to cast _KLEENE_EXTRACT_DATE to a data type of float.

Kleene.ai supports integration with over 600+ data sources, including popular CRM systems, ERPs, marketing platforms, financial software, e-commerce platforms, databases, and more. Plus, if we don’t already have a connector available, we will build it for you free of charge.

The simplest way to manage snapshots is by using a full-append load strategy. This involves appending new records to the existing dataset often by selecting the "Append" insert and "Full" load options in the relevant kleene connector. You will find that _kleene_extract_date fields will indicate the separation between record loads.

Our SQL console is an integrated development environment (IDE) within the Kleene application. It enables you to execute SQL queries on objects within your data warehouse. It is feature rich with contextual auto-complete, formatting and a wide range of shortcuts.

2024年11月29日 · From managing your customer acquisition and retention, to product optimisation; Kleene can help

2025年2月27日 · Explore the power of Kleene.ai, the decision intelligence platform built for the future of data analysis.

Below are the scopes you will definitely need to make requests to the available Kleene extracts:

WITH cleaned_orders AS ( SELECT date, customer_id, amount FROM raw_orders WHERE status != 'cancelled' ), daily_totals AS ( SELECT date, COUNT(*) as order_count, SUM(amount) as total_amount FROM cleaned_orders GROUP BY date ), customer_metrics AS ( SELECT customer_id, COUNT(*) as frequency, AVG(amount) as avg_order FROM cleaned_orders GROUP BY customer_id ) SELECT d.*, c.frequency, c.avg_order ...

After signing up to Kleene, Customer Success will initially set up an account and your designated Admin will need to set up the Warehouse and Filestore. Your Admin will need to configure the Warehouse and Filestore separately, full documentation on how to do this for the different configurations can...

Here are some frequently asked questions and common issues that may occur in the Kleene app, and some simple steps that you can take to try to resolve.