Azure synapse external table parquet

sakuraime 2,321 Reputation points

I would like to know if dedicated pool external table to parquet also support partition pushdown ??


any example ?

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

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee

    Hi @sakuraime ,

    Sorry for the delay in response.

    I have a confirmation from product team that the Synapse SQL (dedicated pool) does not support predicate pushdown today. Only Synapse SQL Serverless is supported at the moment.

    I would encourage you to please log a feature request in Azure Synapse Analytics user voice forum -
    All the feedback shared in this forum are actively monitored and reviewed by Synapse Analytics engineering team. Also please do share the feedback link here once it is posted, so that other users with similar idea can up-vote and comment on your suggestion to help increase the priority of feature request.

    Hope this info helps.


    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.