After having looked at the plethora of new data sources available to us with PolyBase V2, we will change our focus in this chapter to look at how PolyBase works for ETL in Azure Synapse Analytics. We will start with an overview of the PolyBase surface area and see how Azure Synapse Analytics muddies the waters with respect to functionality. Next, we will create a new Azure Synapse Analytics database. Then, we will use PolyBase to read data from Azure Blob Storage into Azure Synapse Analytics and look at a couple tips for speeding up data loads. After that, we will dive into some of the ...
Get PolyBase Revealed: Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
