Thanks for the feedback. To help us further evaluate the ask, kindly comment more on under which scenario you want to extract data out from SQL DW.John Cantrell commented
To test ADF copy data performance, we moved less than 100GB from one ASDW to another, both running at DWU1000c. Export to blob step took 1hr 4 minutes. Import from blob to ASDW took 4 minutes. Polybase at both ends would have improved performance by up to 90%.
Also there are data science/ml scenarios where I may want to copy filtered subsets of warehouse data out to blob to further manipulate and ingest with other tools that are too chatty or client based that I do not want connecting directly to the warehouse.
891 votesunplanned · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
Not planned at this time. Will keep this item open for future review.John Cantrell commented
Especially now that Hyperscale is going to be available, this would be a very useful feature. Hyperscale would make a superior data mart platform, but only if it could be loaded quickly enough.
1 voteJohn Cantrell shared this idea ·