In BigQuery, when you create a view on top of a partitioned table and then query that view with a filter on the partition column, BigQuery should intelligently use the partitioning information to optimize your query. This means that BigQuery will only scan the relevant partitions based on your filter condition, rather than scanning the entire table.
BigQuery will intelligently use the partition column filter in your query to select limited data. This is one of the key benefits of using partitioned tables in BigQuery, as it can significantly improve query performance for date-based filtering and partition pruning.