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.
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.
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