OPENROWSET() for Synapse dedicated pools?

Anders Swanson 26 Reputation points
2020-12-02T20:41:50.74+00:00

Any plans to support open row set for dedicated pools?
Advantages:

  • More (and faster) parser options over External File Format such as row delimiter
  • Can auto-infer schema
  • More convenient to define the file format directly

More broadly, is it the plan to bring all serverless pool T-SQL functionality into the dedicated pools?

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,422 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Saurabh Sharma 23,751 Reputation points Microsoft Employee
    2020-12-04T00:06:15.723+00:00

    @Anders Swanson Thanks for using Microsoft Q&A.
    I will be sharing your feedback internally with the products team however I also encourage you to provide your feature idea on Synapse Uservoice so that community can upvote and the products team can plan it in future releases.

    Please let me know if you have any other questions. Thanks.

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.