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

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
Bergen
New Member

Kusto partitioning and sharding

I dont know where i should post my quetion so i hope this is the right place.

 

I have a table which contains data which is ingested out-of-order, if i understand correctly the IngestionTime is used for sharding and partitioning the data in the Kusto DB.

 

If my data is ingested out-of-order and has its own "ReceivedTime" column which is a datetime. And i want to do my time based queries on the "ReceivedTime" i understand that i should partition my table on the "ReceivedTime" to make it as fast as possible, is that correct? 

 

I read you should be able to do someting like this by doing a Query through the fabric KQL DB Query with code option or the Azure Data Explorer:

.alter-merge table ['MyTable'] policy partitioning = 
{
    "PartitionKeys": [
        {
            "ColumnName": "ReceivedTime",
            "Kind": "UniformRange",
            "Properties": {
                "Reference": "2024-01-01T00:00:00",
                "RangeSize": "12.00:00:00",
                "OverrideCreationTime": false
            }
        }
    ]
}

 

When i try running this query i get a Syntax error: A recognition error occurred.

 

Can someone please tell me if im correct in saying i should partition the data as it should greatly increase performance of my time based queries? If so how i should do it since i dont see the issue with my query? 

 

Just in case it helps someone else, I found my info on Partitioning policy - Kusto | Microsoft Learn 

0 REPLIES 0

Helpful resources

Announcements
May FBC25 Carousel

Fabric Monthly Update - May 2025

Check out the May 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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