How can we improve Microsoft Azure SQL Data Warehouse ?

Cross Database Querying

Enable elastic query for SQL DW - this would allow cross database query in SQL DataWarehouse.

168 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Bogdan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

10 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Josep commented  ·   ·  Flag as inappropriate

    Great to know that you're looking into it. Is there a rough estimated time when it will be available? Is in a month? In half a year? In 2020? It would be great to know it for planning...

  • Anonymous commented  ·   ·  Flag as inappropriate

    I'd also love support for the sp_execute_remote procedure that is already available for Sql Database. This would enable us to implement a logging framework for our Sql Data Warehouse stored procedures in a Sql Database.

  • Alex Hieng commented  ·   ·  Flag as inappropriate

    This would definitely solve link server limitations and allow ETL developers to source data directly from source system using Azure DB as the DB of choice.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is must needed feature to cross query the Azure SQL databases from Azure Data Warehouses. Currently this is a limitation which increases development efforts to build additional data pipelines.

  • Anonymous commented  ·   ·  Flag as inappropriate

    When a PaaS Sql Database is added to the same server where a SQL Data Warehouse is located, allow three part table references and eliminate the need to create data sources and external tables. For data security, use AAD integrated and leverage existing security constructs. This should allow security to be set in one place and allow cross database queries that use the actual end user account. Then End User query activity would be captured in Audit tables.

  • Kiran Siddineni commented  ·   ·  Flag as inappropriate

    This feature is a blocker to all traditional DW environments to move to Azure SQL DW as most of datawarehouse design will use multi sourcesystems in their ETL staging DB. Please can you let us know when this is expected to be released to Azure SQL DW?

  • Mark Webb commented  ·   ·  Flag as inappropriate

    While I am commenting without yet knowing the intended database design, we have found multiple analytic scenarios that need to couple more than one data transaction/fact domain with another such as Invoice data domain with Inventory data domain

Feedback and Knowledge Base