m dynamic parameters
1 TopicHow to force filtering on at least one criterion when querying ADX data in direct query mode
We have two (or more) filters that can limit the amount of data scanned from a large table. How can we enforce a selection on at least one criterion so to avoid open queries that can drain the cluster resources? Using a KQL function and M dynamic parameters, we can prevent the query from running2.6KViews0likes0Comments