SQL Server Big Data Clusters: Data Virtualization, Data Lake, and AI Platform

© Benjamin Weissman and Enrico van de Laar 2020

B. Weissman, E. van de LaarSQL Server Big Data Clusters https://doi.org/10.1007/978-1-4842-5985-6_5

5. Querying Big Data Clusters Through T-SQL

Benjamin Weissman¹  and Enrico van de Laar²

(1)

Nurnberg, Germany

(2)

Drachten, The Netherlands

 

Now that we have some data to play with, let’s look at how we can process and query that data through the multiple options provided through Azure Data Studio.

External Tables

Querying a Big Data Cluster using T-SQL happens through external tables , a concept that was introduced in SQL Server 2016 with the first appearance of PolyBase.

We will start to query our Big Data Cluster by adding some external tables to our new empty database BDC_Empty which originally resides in ...