Forum Discussion
Kusto Query Limits
- Anonymous2 years ago
Hi DennesTorres
Yes there are ways to deal with this with commands https://learn.microsoft.com/en-us/azure/data-explorer/kusto/concepts/query-limits#limit-on-result-set-size-result-truncation.
You can try like this:set notruncation;
MyTable | take 1000000
Even in Fabric, KQL DB automatically makes the data available in OneLake in delta format. - 2 years ago
Hi,
I think it worked.
It resulted in an error on the UI, but I believe it will work in othe places.Meanwhile I discovered the pipelien COPY activity ignores the Kusto query limit automatically, without the need of this set.
On the other hand, the dataflows gen 2 are tied with kusto limit, probably they will need this set.
Thank you!
Dennes
Data export and continuous exports are available in Eventhouse (Kusto) exactly the same as in ADX and more, with data landing in Delta/Parquet in the lake as the eventhouse is part of the lake.