question

sakuraime avatar image
0 Votes"
sakuraime asked KranthiPakala-MSFT commented

Azure synapse external table parquet

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

93087-image.png




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


any example ?

azure-synapse-analytics
image.png (42.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·