CODEWITHSUNDEEP
azure-data-explorer
Ritesh Varyani
Ritesh Varyani

Reputation: 41

Is there a way to query all tables for a value in Azure Data Explorer?

Is there a way to search for a keyword across all columns of all tables in Azure Data Explorer? I know "* has" syntax works for searching in all columns in a table but if I want to search for a keyword across all tables, how do I do it?

Upvotes: 2

Views: 12127

Answers (3)

Kevin
Kevin

Reputation: 18243

You can simply use search to look for text in all columns in all tables:

search "Kelce"

As stated, it's more efficient to specify tables (or columns) to search in:

search in (Ravens,Eagles,C*) "Kelce"

Upvotes: 1

Yilmaz Aydogdu
Yilmaz Aydogdu

Reputation: 21

You can try below option:

search in (_*_) "NPA*" or "CSA*"

Upvotes: 2

Yoni L.
Yoni L.

Reputation: 25895

from an efficiency standpoint, it's better, whenever possible, to scope your query only to the specific table(s) which is (are) relevant to your use case.

that said, you may want to look at the find operator: https://learn.microsoft.com/en-us/azure/kusto/query/findoperator

Upvotes: 4

Related Questions