Working with Azure SQL Data Warehouse( Part 1) - Loading data using Polybase

By for February 1, 2016

2515 views
210 downloads

Language

Report Abuse
Loading a CSV dataset into Azure SQL Data Warehouse using Polybase and Python APIs.
This notebook demonstrates how to load a CSV file that is in a blob into Azure SQL Data Warehouse using Polybase, Azure storage APIs and PYODBC in Python to load the data into a table in Azure SQL Data Warehouse. The dataset used is a subset of [NYC Taxi data](http://www.andresmh.com/nyctaxitrips/) that is available on a Public Azure Storage blob as a CSV file. The data is moved into a private blob and from there we use Polybase, to reference the private blob as an external table and load data into a table within the SQL Data Warehouse.

Preview