Can we use polybase on azure sql database?

Abhishek Gaikwad 181 Reputation points
2020-08-27T07:59:10.38+00:00

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

Azure SQL Database
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 37,756 Reputation points
    2020-08-27T09:09:30.193+00:00

    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


1 additional answer

Sort by: Most helpful
  1. Jovan Popovic 81 Reputation points
    2020-12-10T20:07:04.24+00:00

    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:

    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