Loading Data into Azure SQL DW using Polybase | Data Exposed

This post has been republished via RSS; it originally appeared at: Channel 9.

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 loading data into a Azure SQL DW! Very fast, and VERY awesome! 

Great demo and great video, and we definitely look forward to having Casey back to talk more about Polybase!

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.