CODEWITHSUNDEEP
azure-data-explorerkql
empz
empz

Reputation: 11788

How to combine a control command with a parameterized query in Kusto?

According to this doc page the result of a control command can be used in a query by using $command_results.

Now, how to achieve that when the query makes use of query_parameters?

.show tables;
declare query_parameters(_rootPath:string = "root")
$command_results
| where Folder startswith _rootPath

This throws

400 - "General_BadRequest: Request is invalid and cannot be executed.
Syntax error: Query could not be parsed: SYN0002: A recognition error occurred. [line:position=3:0]

Upvotes: 0

Views: 1364

Answers (1)

Yoni L.
Yoni L.

Reputation: 25895

you're missing a semicolon (;) after declare query_parameters(_rootPath:string = "root")

Upvotes: 3

Related Questions