Hello, I have a BigQuery table with a very large amount of data. We partitioned the table using a hash column generated from another column, to keep queries cheaper.
However, users don’t know they need to filter on the hash-based partition field, so they only filter on the original column. This causes the queries to scan the full table.
Is it possible, using the toolkit, to automatically add a secondary filter on the partition column whenever a filter is applied to the original source column?