CODEWITHSUNDEEP
azure-data-explorer
Ivan Glasenberg
Ivan Glasenberg

Reputation: 29995

Does extend operator support whitespace when specify a new column name?

When I want to generate a new column name with extend, and the new column name contains a white space, code like below:

requests 
| extend "users name" = ""
//other codes

then an error occurs: Query could not be parsed at '=' on line xxx. So the question is that can we use white space in the new column name with extend?

I also tried use single quote, still the same error.

Upvotes: 14

Views: 8564

Answers (1)

Avnera
Avnera

Reputation: 7618

You need to use the square brackets:

datatable(['a b']:string)["this works"]

See more: https://learn.microsoft.com/en-us/azure/kusto/query/schema-entities/entity-names

Upvotes: 24

Related Questions