Table Existence
Query
//Checking to see if a table (or tables) exist or not
let hasNonEmptyTable = (T:string, T2:string)
{
toscalar(
union isfuzzy=true
( table(T) | take 1 | count as Count ),
( table(T2) | take 1 | count as Count),
(print Count=0)
| summarize sum(Count)
) > 1
};
let TableName = 'AzureActivity';
let TableName2 = 'SecurityEvent';
print IsPresent=iif(hasNonEmptyTable(TableName,TableName2 ), "present", "not present")Explanation
The query is checking if two tables, "AzureActivity" and "SecurityEvent", exist and are not empty. It returns whether the tables are present or not.