''where' operator: Failed to resolve column or scalar expression named '<column name>'

Getting error 'where' operator: Failed to resolve column or scalar expression named 'AgeofOldestMissingRequiredUpdate' while running heartbeat query from Azure portal

azureazure-data-explorerkqlheartbeat


Solution 1:[1]

'where' operator: Failed to resolve column or scalar expression named 'column name'

This error can be the result of a number of different scenarios. You haven't posted your query, but I achieved the same error with a query like

MyTable
| Project Column1, Column2
| where Column3 == "Value"
| Take 100

In my case there was a 2nd error:

The name '<column>' does not refer to any known column, table, variable or function.

MyTables structure did indeed contain the column!

MyTable
|- Column1
|- Column2
|- Column3

Solution

I updated my query so that the project clause contained the column named in the where clause:

MyTable
| Project Column1, Column2, Column3
| where Column3 == "Value"
| Take 100

Then I could run my query successfully. :-)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions