Aggregate Awareness with filter only fields?

I have a big partitioned table which I want to add aggregate awareness to. However, it uses a filter only field for date filtering, which means that it can not be put into the list of dimensions. As such, the rollup table is only used when the filter value is an exact match, and not to subsets of the date range.

Is there a way to work around this? The reason why it has a filter only field in the first place is that we needed to force some filtering to use the partitioning of the BigQuery table to prevent TB sized queries from occurring.

0 0 84
0 REPLIES 0
Top Labels in this Space
Top Solution Authors