Non-uniform integer partitioning in Google BigQuery
In BigQuery integer range partitioning, is it possible to create non-uniform partition intervals? The use case that I have is that the date column is an integer (20201231 for example). All current queries target this date format and cannot be changed so the partition has to be on this field. Integer partitioning for this works, but only for the yearly case, eg:
Best way to create half-yearly partitions in Google Big Query
Big Query supports partitioning a time-unit column based on daily, hourly, monthly or yearly granularity. However, I would like to partition based on half-yearly granularity which is not directly supported.
I am thinking of using the below query, to partition by half yearly granularity. This will put dates from 2016 to 2024 into the respective half yearly partitions.