query to specific partition in synapse?

ash b 1 Reputation point

In oracle, to query the particular partition we use following partition keyword i.e SELECT * FROM employees PARTITION (p1);
is there any similar command in azure synapse, to query the particular partition in partition table? Also how to identify in synapse query explained plan where it's using partition or not?

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,462 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HarithaMaddi-MSFT 10,136 Reputation points

    Hi @ash b ,

    Thanks for your patience. I got an update from product team that today we do not have provision to check partitions used in the query in Synapse and there is no plan in near future to implement the same. I would recommend you to create an idea in feedback forum which will be closely monitored by Synapse product team and will be considered for implementing in future releases.

    Please let us know for further queries and we will be glad to assist.


    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.