In this video Chris Seferlis gives a quick demonstration of connecting an external data source to my Synapse environment and the differences in performance between connecting as an external table or querying directly off of blob storage.

Then he goes into the difference in external table and how that differs from copying the data right into Synapse or using a CTAS statement.

In this video Chris Seferlis discusses some of the reasons you might want to choose Azure Data Factory over Azure Synapse Workspaces with Synapse Studio.

Even though many of the features overlap, there are still scenarios where I’d use ADF, and pass on the additional features of Synapse. Let me know your thoughts below, please like, comment, share and follow me on Twitter: @bizdataviz