Loading Data into Azure SQL DW using Polybase | Data Exposed

Loading Data into Azure SQL DW using Polybase | Data Exposed

Avatar

Another short but awesome all-demo video! In this week's episode Casey Karst, a PM in the SQL Server team, is back in the studio to show how to use Polybase to load data into Azure SQL Data Warehouse. Casey spends the first few minutes explaining Azure SQL Data Warehouse is, the importance of data for data warehousing, and the challenges for getting data into a data warehouse. Casey then discusses why Polybase for a data loading tool, including reading data in parallel and massive scaleout, thus the preferred way of loading data into a data warehouse. Casey briefly explains why Polybase is a better choice over SSIS and other options for using Polybase to load in a DW. What's cool is that Polybase, as Casey explains, can use both Azure Blob Store and Azure Data Lake Store as data source.At the [04:25] mark Casey spends the remaining 13 minutes of the who walking us through this exact demo end-to-end, from creating the external data source all the way through to loadi

Comments

Avatar