Partitioning tables in Microsoft Fabric warehouse

Anonymous — Wed, 13 Nov 2024 12:49:06 GMT

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.

Re: Partitioning tables in Microsoft Fabric warehouse

AndyDDC — Wed, 13 Nov 2024 20:25:42 GMT

Hi Anonymous 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 Learn

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

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

topic Re: Partitioning tables in Microsoft Fabric warehouse in Data Warehouse

Partitioning tables in Microsoft Fabric warehouse

Re: Partitioning tables in Microsoft Fabric warehouse