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
Can we use polybase on azure sql database?
@abhishek6555 Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.
And If you have further questions or issues please let us know.
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
@VaibhavChaudhari is this still valid statement? "In Azure SQL database, you can create external table to point to other Azure SQL Databases but not to files in Azure storage" ?
Thanks,
Sri
Azure SQL currently doesn't support Polybase. You can check what features are supported in this article: https://docs.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://docs.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
6 people are following this question.
