Configure PolyBase connectivity

PolyBase enables your Analytics Platform System (APS) to process Transact-SQL queries that can read data from and write data to external data sources. The same queries that access external data can also include relation tables in your APS. This allows you to combine data from external sources with high-value relational data in your APS databases.

PolyBase logical

PolyBase on APS supports reading and writing to Hadoop (HDFS) file system and Azure Blob Storage. PolyBase also has the ability to push some computation to Hadoop nodes as mapreduce jobs to optimize the overall query performance. PolyBase on APS can operate on delimited text, ORC and Parquet files. See What is PolyBase for a full description and its capabilities.

Note

APS currently only supports standard general purpose v1 locally redundant (LRS) Azure Blob Storage.

Features and limitations

See features and limitation for a summary of PolyBase features available and known limitations on APS and other SQL Server products.

Note

The rest of the PolyBase related articles descibe how to configure PolyBase on APS 2016 (AU6) and later.

See Also