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

Is this possible within Starburst Galaxy?

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:

1 Like

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.