Can we use polybase on azure sql database?

Question

Can we use polybase on Azure database. Using polybase can we connect to azure storage file, oracle server has external table from azure sql database

Answer 1

In Azure SQL database, you can create external table to point to other Azure SQL Databases but not to files in Azure storage

You can use On-premise SQL or Azure synapse server (Azure SQL DW Server) which has the polybase support.

See the polybase availability table - polybase-versioned-feature-summary

There is a feedback raised that you can upvote. Lot of users have been demanding this feature -
17376250-polybase-support-for-azure-sql-database

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Azure SQL currently doesn't support Polybase. You can check what features are supported in this article: https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison

The only workarounds are:

• Use OPENROWSET function that reads file form Azure Blob Storage: https://learn.microsoft.com/en-us/archive/blogs/sqlserverstorageengine/loading-files-from-azure-blob-storage-into-azure-sql-database
• Use External table with TYPE=RDBMS to read Azure Data Lake files using Synapse SQL: https://devblogs.microsoft.com/azure-sql/read-azure-storage-files-using-synapse-sql-external-tables/
• Use linked server (Azure SQL managed instance only) to read Azure Data Lake files using Synapse SQL: https://devblogs.microsoft.com/azure-sql/linked-server-to-synapse-sql-to-implement-polybase-like-scenarios-in-managed-instance/

If nothing of these features fits your scenario vote for Polybase support on Azure feedback site: https://feedback.azure.com/forums/217321-sql-database/suggestions/17376250-polybase-support-for-azure-sql-database