Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Bigquery Partitioning with Looker front end

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! 

0 2 250
2 REPLIES 2