project-rename operator
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Renames columns in the output table.
Syntax
T | project-rename NewColumnName = ExistingColumnName [, ...]
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string |
✔️ | The input tabular data. |
| NewColumnName | string |
✔️ | The new column name. |
| ExistingColumnName | string |
✔️ | The name of the existing column to rename. |
Returns
A table that has the columns in the same order as in an existing table, with columns renamed.
Example
If you have a table with columns a, b, and c, and you want to rename a to new_a and b to new_b while keeping the same order, the query would look like this:
print a='a', b='b', c='c'
| project-rename new_b=b, new_a=a
Output
| new_a | new_b | c |
|---|---|---|
| a | b | c |