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 👍
Hi utsavlexmark ,
Thank you MattiaFratello for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you.
Hi utsavlexmark ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.