question

sakuraime avatar image
0 Votes"
sakuraime asked sakuraime commented

what's the correct syntax for openrowset on Azure synapse dedicated pool

actually it's happen on dedicated pool

93891-image.png




what's the correct syntax ?

azure-synapse-analytics
image.png (54.0 KiB)
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.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered sakuraime commented

Right now, openrowset for synapse dedicated pool is not supported so you might have to try creating external data source, format and table.

Consider upvoting below feature as well -

https://feedback.azure.com/forums/307516-azure-synapse-analytics/suggestions/42118774-openrowset-for-dedicated-pools


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

· 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.

oh... actually openrow set is a cool features.

0 Votes 0 ·