Is it possible to cluster by Ingestion Time a BQ table partitioned by Ingestion Time?

Question

We currently use a BQ table partitioned by day on a column date1 and clustered by the same date column date1. This enables us to optimize our costs. However, we would like to use the tables partitioned by ingestion time instead but I haven't found if it was possible to also cluster by _PARTITIONTIME.

Does anyone know if we can do such thing in BigQuery ?

Thanks for your help

Answer 1

From a recent release, BigQuery clustering is independent of the partitioning. Therefore, there is no limitation with (or without) ingestion time partitioning. I did a test and it worked great