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.

134 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    6 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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