Skip to content

data-policies.md

Latest commit

 

History

History
57 lines (35 loc) · 3.33 KB

data-policies.md

File metadata and controls

57 lines (35 loc) · 3.33 KB
title Change Data Policies in Real-Time Intelligence
description Learn how to change the retention and caching policies in Real-Time Intelligence.
ms.reviewer tzgitlin
ms.topic how-to
ms.date 03/22/2026
ms.subservice rti-eventhouse
ms.search.form product-kusto

Change data policies

In this article, you learn how to change the Data retention policy and the Caching policy in your KQL database.

Prerequisites

Data retention policy

The retention policy controls the mechanism that automatically removes data from tables or materialized views. It's useful to remove data that continuously flows into a table, and whose relevance is age-based. For example, the policy can be used for a table that holds diagnostics events that might become uninteresting after two weeks. The default data retention policy is 3,650 days, with a maximum of 36,500 days.

For more information, see Retention policy.

  1. To change the data retention policy, browse to your KQL database and select Manage > Data policies.

    :::image type="content" source="media/data-policies/data-policies.png" alt-text="Screenshot showing the manage tab in a KQL database." :::

  2. Under Retention, either select the toggle to set the retention period to Unlimited, or enter a time period and select Done. By default, your data is stored for 3,650 days.

    :::image type="content" source="media/data-policies/retention-policy.png" alt-text="Screenshot of data retention policy pane with default value.":::

    [!NOTE] The minimum retention period is one day. The maximum retention period is 36,500 days.

Caching policy

The caching policy controls which data gets cached and stored on the local SSD. When data is available in the hot cache, query performance improves, but storage costs also rise. In Real-Time Intelligence, you can turn on a caching policy for KQL databases. After you enable caching, you can specify how long data stays in the hot cache.

For more information, see Caching policy.

  1. To change the caching policy, go to your KQL database and select Manage > Data policies.

    :::image type="content" source="media/data-policies/data-policies.png" alt-text="Screenshot showing the manage tab in a KQL database." :::

  2. Under Caching, select the toggle to set the caching period to Unlimited, or enter a time period and select Done. By default, your data is cached for 3,650 days.

    :::image type="content" source="media/data-policies/caching-policy.png" alt-text="Screenshot of caching policy pane with default value.":::

    [!NOTE] The time period you set for the caching policy must be lower than or equal to the data retention time period.

Related content