Set statement

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

The set statement is used to set a request property for the duration of the query.

Request properties control how a query executes and returns results. They can be boolean flags, which are false 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.

Request properties aren't formally a part of the Kusto Query Language and may be modified without being considered as a breaking language change.

Syntax

set OptionName [= OptionValue]

Learn more about syntax conventions.

Parameters

Example

This query uses query_take_max_records to limit the number of records retrieved from the StormEvents table. (This is somewhat equivalent to using a | take 100 operator.)

set query_take_max_records=100;
StormEvents

Output

The table shows the first few results.