Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II

What is KQL db in fabric generally used for storing, is it historical data or only streaming data?



I wanted to understand if usually end users utilize KQL db in fabric for storing historical data as well or only streaming data. 

What is usual retention period commonly followed for KQL db as the default is unlimited.



Thanks in advance.

Community Support
Community Support

Hi @supriyapandey19 ,


The KQL database in Microsoft Fabric is primarily used to store and analyze real-time analytics data. It is a fully managed Kusto engine that allows queries to be executed on data using KQL (Kusto Query Language). You can use the KQL database to store historical data and process streaming data as needed.


Regarding the retention period, while you mentioned it as unlimited, it's important to note that the default data retention policy is actually set to 36,500 days, which for most practical purposes, can be considered as 'unlimited'. However, this is configurable, and users can adjust the retention period based on their specific needs. Refer: Change data policies in Real-Time Analytics - Microsoft Fabric | Microsoft Learn


If you're considering storing historical data and need guidance on how to ingest it into a KQL database, the Tutorial on getting historical data might be of interest.

For exploring data with KQL and SQL, including example queries, the Explore your data with KQL and SQL tutorial can provide valuable insights.


Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Helpful resources


Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors