Azure Synapse should support auto partition and very big partition numbers.
We have a big DW table for patient detail(>10 billions row). Each day this table has around ~5% update in rows, which always happens in group column [memberId]+[batchId]+[year] together. As the combination number could exceed 100K, if we can split table in such partition then bulk copy and partition switch in/out would be very useful for our case, unfortunately now the partition number limitation <15000 is so small and cannot apply in our case.
Continue on this ask, Synapse should support the feature of partition automatically on separate value for columns, as it's so annoying to define a 100K partition range!