Configure smart caching in Lakehouse Turbo

Learn how to configure smart caching (replication) in Lakehouse Turbo.

Lakehouse Turbo is supported in as-application deployments of Exasol 2026.1 and later (including Exasol Personal) and in Exasol SaaS.

This article describes Lakehouse Turbo in an as-application deployment of Exasol. To learn how to use Lakehouse Turbo in Exasol SaaS, see Configure smart caching in Lakehouse Turbo (SaaS).

Prerequisites

Lakehouse Turbo must be connected to your data lakehouse. To learn more, see Get started with Lakehouse Turbo.

Configure replication

  1. In Exasol Admin, go to Lakehouse > Replication and select the catalog and schema to accelerate:

    select schema

  2. Click on the Disabled/Enabled switch to enable the schema, then select the tables you want to replicate.

    select tables

  3. Configure the cache retention Interval and caching Mode.

    The Interval is defined on the schema level. It defines the interval in seconds between two cache invalidations. If, for example, the interval is set to 60, the cache will be invalidated every minute.

    The Mode column defines the caching strategy on the table level.

    • INCREMENTAL (default) = The table is cached incrementally - only new, updated or removed data since the load is cached.

    • FULL LOAD = The table is truncated before caching. Afterwards, all available data is cached. This mode is recommended for data marts that are overwritten on a regular basis.

  4. To save the schema settings and start replication of the schema, click on Save.

Monitor caching status

The caching status of each table can be found in the tabular overview on schema level.

Example:

table caching status

Additionally, Lakehouse Turbo keeps track of all caching activities in the table exa_dlhc.replication_log. To view the caching activities sorted by execution time descending, execute the following query:

Copy 
SELECT * FROM exa_dlhc.replication_log
ORDER BY event_ts DESC;