Feedback Edit

Set statement

  • Article
  • 2 minutes to read

The set statement is used to set a query option for the duration of the query. Query options control how a query executes and returns results. They can be Boolean flags (off by default), or have an integer value. A query may contain zero, one, or more set statements. Set statements affect only the tabular expression statements that trail them in the program order. Any two statements must be separated by a semicolon.

  • Query options can also be enabled programmatically by setting them in the ClientRequestProperties object. See here.

  • Query options are not formally a part of the Kusto language, and may be modified without being considered as a breaking language change.

Syntax

set OptionName [= OptionValue]

Example

set querytrace;
Events | take 100

This capability isn't supported in Azure Monitor