Cross Database Querying
Enable elastic query for SQL DW - this would allow cross database query in SQL DataWarehouse.
We are looking into this capability for a future release.
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...
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
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.
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.
Team, let us know on when can we expect this feature?
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.
This would take away a lot of headache
Kiran Siddineni commented
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?
Steve Catmull commented
Hopefully this includes the USE <database> statement too.
Mark Webb commented
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