Forum Discussion
Helper IIICombine data in a table from two separate azure database
Hey utsavlexmark, I would explore -> https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview?view=azuresql
The elastic query feature (in preview) enables you to run a Transact-SQL (T-SQL) query that spans multiple databases in Azure SQL Database. It allows you to perform cross-database queries to access remote tables, and to connect Microsoft and third-party tools (Excel, Power BI, Tableau, etc.) to query across data tiers with multiple databases. Using this feature, you can scale out queries to large data tiers and visualize the results in business intelligence (BI) reports.
If this helped, please feel free to mark it as a solution and give a thumb up 👍
Super UserHey utsavlexmark, I would explore -> https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview?view=azuresql
The elastic query feature (in preview) enables you to run a Transact-SQL (T-SQL) query that spans multiple databases in Azure SQL Database. It allows you to perform cross-database queries to access remote tables, and to connect Microsoft and third-party tools (Excel, Power BI, Tableau, etc.) to query across data tiers with multiple databases. Using this feature, you can scale out queries to large data tiers and visualize the results in business intelligence (BI) reports.
If this helped, please feel free to mark it as a solution and give a thumb up 👍