We're seeing these type of queries (field filter values' scans) at different times even though we've chosen these to run once a day during 5am IST. These queries starts our serverless Databricks warehouse compute (even multiple clusters at times) - leading to higher costs.
We'd wanna either completely stop these queries and do it manually as needed, or more control on when to run it (say weekly/monthly once).
Can anyone please help me understand how to achieve this?
why "SELECT 1" queries get triggered and how to disable these completely? @Luiggi if you could guide please, this is leading to higher compute costs for us