How can we improve SQL Managed Instance?

← SQL Managed Instance

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.

105 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Brian shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
need-feedback  ·  AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded  · 

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.

Show previous admin responses (1)

10 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Aleksandr Panchuk commented  ·   ·  Flag as inappropriate

    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.

  • Yang Jiayi commented  ·   ·  Flag as inappropriate

    Please implement it.There is a requirement to implement PolyBase in the matter of data platform.

  • Mark commented  ·   ·  Flag as inappropriate

    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

  • Christopher K. Fenwick commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

SQL Managed Instance

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice