project-keep operator

Learn how to use the project-keep operator to select columns from the input to keep in the output.

Select what columns from the input to keep in the output. Only the columns that are specified as arguments will be shown in the result. The other columns are excluded.

Syntax

T | project-keep ColumnNameOrPattern [, …]

Parameters

NameTypeRequiredDescription
Tstring✔️The tabular input from which to keep columns.
ColumnNameOrPatternstring✔️One or more column names or column wildcard-patterns to be kept in the output.

Returns

A table with columns that were named as arguments. Contains same number of rows as the input table.

Example

This query returns columns from the ConferenceSessions table that contain the word “session”.

ConferenceSessions
| project-keep session*

Output

The output table shows only the first 10 results.

sessionidsession_titlesession_typesession_location
COM64Focus Group: Azure Data ExplorerFocus GroupOnline
COM65Focus Group: Azure Data ExplorerFocus GroupOnline
COM08Ask the Team: Azure Data ExplorerAsk the TeamOnline
COM137Focus Group: Built-In Dashboard and Smart Auto Scaling Capabilities in Azure Data ExplorerFocus GroupOnline
CON-PRT157Roundtable: Monitoring and managing your Azure Data Explorer deploymentsRoundtableOnline
CON-PRT103Roundtable: Advanced Kusto query language topicsRoundtableOnline
CON-PRT157Roundtable: Monitoring and managing your Azure Data Explorer deploymentsRoundtableOnline
CON-PRT103Roundtable: Advanced Kusto query language topicsRoundtableOnline
CON-PRT130Roundtable: Data exploration and visualization with Azure Data ExplorerRoundtableOnline
CON-PRT130Roundtable: Data exploration and visualization with Azure Data ExplorerRoundtableOnline
…………

Related content