We have a table that has streaming data of a few hundreds of MBs of data coming in everyday. This table is partitioned on a timestamp column (let's say it's called timestamp_column) on DAY. A couple of questions on this -
- If I query the table on date(timestamp_column) is BQ smart enough to look through the partitions and query on the selected partition or does it scan the whole table?
- Our business layer is basically all done in Looker through views and models. In a model, there are some joins to create explores without using any filters. But we filter on date(timestamp_column). Does BQ apply the filter intelligently here?
Thank you so so much in advance!