Azure synapse external table parquet

sakuraime 2,316 Reputation points
2021-05-02T06:29:27.05+00:00

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

93087-image.png

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool

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,363 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-05-06T18:44:15.803+00:00

    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 - https://feedback.azure.com/forums/307516-azure-synapse-analytics
    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.