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 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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for