The PARTITIONS view in INFORMATION_SCHEMA

Riding on the back of recent news that BigQuery table partition limit has just increased from 4k to 10k partitions, I wanted to talk a bit about the PARTITIONS view in INFORMATION_SCHEMA. I've previously posted about information schema views, but thi...