Ingestion-time partitioning in BigQuery

Have you ever used ingestion-time partitioning in BigQuery? It's a separate type of partitioning that distributes rows into partitions based on the time they land in BQ. Once such a table is defined, you can query the pseudocolumns PARTITIONDATE and ...