In Looker Studio, I need to connect a BigQuery table but limit the data retrieved to records matching a specific column condition (e.g. column_x = ‘value’). I know it is possible to filter graphs.
But the objective is to apply this restriction at the data source level, so that every query generated by Looker Studio only scans the relevant subset of the dataset, rather than filtering results after the full table is queried.
Is there a recommended way to implement data source filter that ensures queries sent to BigQuery are optimized and process only the necessary partitions?