https://medium.com/@raigonjolly/looker-bigquery-external-table-partition-pruning-using-pdt-and-dynamic-sql-1b7cc18bcb41