Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredJoin 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
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
User | Count |
---|---|
81 | |
45 | |
16 | |
11 | |
7 |
User | Count |
---|---|
92 | |
88 | |
27 | |
8 | |
8 |