Can anyone help me with the below question:
From the azure synapse documentation, I can find that the "Dedicated SQL pool" tables can be partitioned using a value range (Range partitioning).
For Example: PARTITION ( [OrderDateKey] RANGE RIGHT FOR VALUES
I would like to understand, is Range-Partitioning is the only partitioning strategy supported by Azure-Synapse? or is there any other way of partitioning the Synapse table??