Looker Bigquery External Table Partition Pruning date filter using PDT and Dynamic SQL

Question

Problem and solution

We have case were bigquery external table need to be used and we use GS as storage and have access data through Bigquery external mentioning those partitions , we use looker for dashboard on this which needs to be fast and achieve partition pruning

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

We have case were bigquery external table need to be used and we use GS as storage and have access data through Bigquery external mentioning those partitions , we use looker for dashboard on this which needs to be fast and achieve partition pruning