Querying data from particular partition in Azure synapse

Vijay Sampath (Trianz) 66 Reputation points
2021-07-30T01:21:59.03+00:00

I would like to query the data in a particular partition in Azure Synapse. Is it possible to do so? what is the best way to do it?

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

1 answer

Sort by: Most helpful
  1. Ronen Ariely 15,096 Reputation points
    2021-08-01T10:46:41.013+00:00

    Hi

    dedicated SQL pool does not use Partitioning functions and schemes as they are used in SQL Server. The partitioning is configured in the table configuration (CREATE/ ALTER). This make the question more interesting since we cannot based on the Partitioning functions for the filtering in the SELECT query.

    With that being said, you still have (or can find) the configuration of the table DDL and using the CREATE TABLE statement you know what is the partitioning rule.

    Next you simply write a query which uses the same filter using WHERE condition