We have a BigQuery table partitioned on date. In order to take advantage of the partition, we need to pass the literal dates (start and end) into the where clause. Passing something like fact_table.date between calendar.start_date and calendar.end_da...