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.
Brian
shared this idea
AdminSQL Database feature voting forum admins
(Product Owner, Microsoft Azure)
responded
As this is a very wide area to consider, need more customers to chime in on possible scenarios please in terms of Managed Instance and what other database systems? Thank you.
7 comments
-
Mark
commented
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 polybaseThis 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