question

sakuraime avatar image
1 Vote"
sakuraime asked SamaraSoucy-MSFT answered

Openrowset for Azure synapse dedicated pool

Openrowset seems not allow in dedicated pool?

93161-image.png


azure-synapse-analytics
image.png (20.9 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

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered

You are correct that this is not supported in dedicated pools. Instead, use CREATE EXTERNAL FILE FORMAT to access external files. We share questions like this from the forums to the product teams, but if this is a feature you would like to see in dedicated pools, I would also suggest adding or upvoting the feature on Uservoice.


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.