Share via

Can we use polybase on azure sql database?

Abhishek Gaikwad 196 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
Answer accepted by question author
  1. Vaibhav Chaudhari 38,996 Reputation points Volunteer Moderator
    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

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jovan Popovic 86 Reputation points Microsoft Employee
    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

    2 people found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.