Enable Polybase on SQL Managed Instance
Please enable Polybase on SQL Managed Instance. This will allow us to integrate data from our other IoT Analytic environments (Databrick, and Snowflake) with our corporate data warehouse (SQL MI). Polybase will improve data availability between systems by setting up external tables over Azure Storage Blobs that are shared between systems.
We are exploring product improvement opportunities in an area of combined relational and non-relational data querying including integration with data lakes and data virtualization from Azure SQL database/Managed Instance to data stored in various formats.
We are seeking for the customers interested in these new functionalities to participate in the survey below and help us improve our customer experience and product functionalities in Azure SQL DB/MI. If that’s you we are looking for, please fill out this survey: https://aka.ms/sqldbmi-datalake-integration.
Aleksandr Panchuk commented
We need to call WEB API or Azure App Functions directly from Managed Instance.
The possible scenario is:
1) Create External data source to Blob Storage or Cosmos DB.
2) Create External Table
3) Save data to external table
4) Call App Function by trigger on Blob Storage or Cosmos DB.
SQL Managed Instance is useful information..
Yang Jiayi commented
Please implement it.There is a requirement to implement PolyBase in the matter of data platform.
Possible Scenarios in some of our Project:
Injest JSON or CSV files to Azure Blob Storage
Then read files into Azure SQL Managed Instance via polybase
This could replace the staging area in data warehouse scenarios
Anthony Genovese commented
Connect to SQL Server first, then Azure SQL and other PASS, then other Azure things like data lake
Sune Boesgaard Krog-Meyer commented
Polybase support for Data lake Gen2 with delimited files would be very useful.
Christopher K. Fenwick commented
We have data in oracle, sybase, and azure sql db, our main warehouse is in SQL Server on prem. Polybase would make the data easily accessible to our analysts without having them log in to multiple systems and export data.
Troy Holland commented
We would like to load a Data Lake Gen2 with parquet files, then use PolyBase within Managed Instance to read this data.
S M Atiqur Rahman commented
We want to use Azure Blob as our cold storage area. While we can use bulk load to copy data from blob to Azure Managed Instance, but we just want to reference the data from blob without making any copy.
hemanth konduru commented
100 Likes.. Microsoft , Please enable Polybase on SQL Managed Instance