Some connectors separate from PolyBase services You can use both OPENROWSET and EXTERNAL TABLES to query data files in S3 compatible object storage. SQL Server 2022 (16.x) Preview adds new connector, S3-compatible object storage, using the S3 REST API. SQL Server 2022 PolyBase enhancements New to SQL Server 2022 (16.x) Preview Visit Data virtualization with Azure SQL Managed Instance to learn more. SQL Server Analytics Platform System (PDW) (PDW), hosted in the Analytics Platform System (APS)ĭata virtualization using PolyBase feature is available in preview for Azure SQL Managed Instance, scoped to querying external data stored in files in Azure Data Lake Storage (ADLS) Gen2 and Azure Blob Storage.SQL Server 2019 (15.x) and later versions (Windows and Linux).SQL Server 2016 (13.x) and later versions (Windows).PolyBase provides these same functionalities for the following SQL products from Microsoft: This data virtualization scenario is possible with the use of PolyBase connectors. This process minimizes the need for ETL processes for data movement. You can virtualize the external data through the SQL Server instance, so that it can be queried in place like any other table in SQL Server. PolyBase allows T-SQL queries to join the data from external sources to relational tables in an instance of SQL Server.Ī key use case for data virtualization with the PolyBase feature is to allow the data to stay in its original location and format. You can also use the generic ODBC connector to connect to additional providers using third-party ODBC drivers. PolyBase enables your SQL Server instance to query data with T-SQL directly from SQL Server, Oracle, Teradata, MongoDB, Hadoop clusters, Cosmos DB, and S3-compatible object storage without separately installing client connection software.

PolyBase is a data virtualization feature for SQL Server.

Sql server vdi api