When this feature was announced in 2018, I wrote:
<sarcasm> It’s like linked servers, but since they don’t perform well, we need to scale out across containers. </sarcasm>
I just didn’t get it, and I continued:
I like that Microsoft is making a risky bet, planting a flag where nobody else is, saying, “We’re going to be at the center of the new modern data warehouse.” What they’re proposing is hard work – we all know first-hand the terrible performance and security complexities of running linked server queries, and this is next-level-harder. It’s going to take a lot of development