Does sub-partitioning feature exist in Google Bigquery. From the docs it looks like it doesn't exist. Please let me know if anyone has used it. Thanks.
Referral doc-https://cloud.google.com/bigquery/docs/partitioned-tables
"Sub partitioning" isn't a feature, but you can create clustered tables. You can create partitioned + clustered tables that essentially give you a primary index (partition key) and secondary indices (cluster keys).
There is a great section in GCP docs that visualises how the data will be stored for a table that uses partitioning and clustering.