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

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool
any example ?
I would like to know if dedicated pool external table to parquet also support partition pushdown ??

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool
any example ?
Hi @sakuraime,
Thanks for your query. We are reaching out to product team to check if this is a support feature for Azure Synapse dedicated pool or not and will get back to you as soon as we hear back from the team.
We appreciate your patience.
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.
Hi @sakuraime,
Just checking in to see if the above suggestion was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Thanks
5 people are following this question.