How would I go about partitioning an Iceberg table on Month and Year From a Single Column

SQL
1

Is this possible within Starburst Galaxy?

2

Provided you are trying to partition on a column of type date, you would just specify the “month” in the partitioning field instead of having to specify both the “month” and “year”.

 partitioning = ARRAY['month(cc_open_date)']

This will result in the following partitions being generated within the object storage bucket:

image
image1032Ă—1160 92.8 KB

1 Like
3

Yes, partitioning your table with Starburst Galaxy is support. Further details can be found in the Great Lakes connectivity documentation and the format specific pages like the Iceberg table format page.