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

sakuraime 2,321 Reputation points
2021-05-05T07:12:32.797+00:00

actually it's happen on dedicated pool

93891-image.png

what's the correct syntax ?

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,417 questions
0 comments
Accepted answer
  1. Vaibhav Chaudhari 38,621 Reputation points
    2021-05-05T08:23:28.927+00:00

    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

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest