What is Partition Switching in Synapse? What is the use of Partition Switching?

Neetu Neetu 61 Reputation points
2022-12-08T10:30:01.97+00:00

I can't understand what is partition switching and what is the use of partition switching. Any one can expalin with general scenario. I will appriciate them. Thank You in advance

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,393 questions
Azure Dedicated Host
Azure Dedicated Host
An Azure service that provides a dedicated physical server to host Azure virtual machines for Windows and Linux.
48 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashleigh Watson 1 Reputation point
    2022-12-08T10:58:49.58+00:00

    Hi;

    Partition switching can be used to quickly remove or replace a section of a table.

    The process moves entire partitions between tables almost instantly. It is extremely fast because it is a metadata-only operation that updates the location of the data, no data is physically moved.