Partitioning tables in Microsoft Fabric warehouse

[supriyapandey19]

Hi,

Is it possible to partition tables in Microsoft Fabric Warehouse? If yes, how to create partitions on a table in Fabric Warehouse and how to verify those.

If not, is it mentioned anywhere in microsoft documentation that partitions do not exist in Fabric Warehouse.

Any workarounds, references would be appreciated.

Thanks.

[AndyDDC]

Hi @supriyapandey19 no partitioning isn't currently suppported.  The following link shows in the "Limitations" section.

Tables in data warehousing - Microsoft Fabric | Microsoft Learn

The roadmap doesn't have anything on at the moment around partitioning: What's new and planned for Synapse Data Warehouse in Microsoft Fabric - Microsoft Fabric | Microsoft...

You can vote on the partitioning table idea here to bump it up the list Microsoft Idea

-------------------------------------------------------------------------------------

If my reply has been useful then please consider providing kudos (thumbs up)

and mark as the solution for other community member to find

-------------------------------------------------------------------------------------