Synapse DW (dedicated sql pools) : How to Automatically Create Monthly Partitions in an Incremental Load Table?

Hi all,

We have a table where we plan to create partitions based on a month_year column (YYYYMM). This table follows an insert-only incremental load approach.

I need help figuring out how to automatically create a new partition when data for the next month is inserted.

Daily Inserts: ~2 million records

Total Records: ~500 million

What would be the best approach to achieve this? Any recommendations on partitioning strategies or automation would be greatly appreciated.