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.

tt ads