Is Elastic Query for Azure SQL still in PREVIEW

Nishant Lakhlani 5 Reputation points
2023-08-18T06:40:18.8866667+00:00

We have 2 DB within same Azure SQL Server and would like to use Elastic Query / Cross DB queries so that we can access tables present in DB1 from the Stored Procedures of DB2.

But our IT team has a mandate that any feature in PREVIEW should not be used for PROD env. and hence would like to that is the Cross DB queries i.e., Elastic Query still in PREVIEW as per the link https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview?view=azuresql it does still have PREVIEW in the title.

Also would like to know that can we use the Elastic Query if we have restrictions of Public Access (i.e., Only Private endpoints are allowed and Public Access is restricted as part of Enterprise Policy)

Azure SQL Database
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator
    2023-08-19T04:22:04.9733333+00:00

    Hey, As stated by Oury elastic query is still in preview mode and they do not support private end point. As currently both your database are on same server, SQL MI would be the best suit as you can cross query between databases and you can manage private end points.

    Was this answer helpful?

    0 comments
  2. Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator
    2023-08-18T17:28:37.95+00:00

    @Nishant Lakhlani Thank you for reaching out.

    Yes, elastic queries are available in Azure SQL and are still in preview. No ETA for GA. In SQL MI we do not support EQ.

    "Also, would like to know that can we use the Elastic Query if we have restrictions of Public Access (i.e., Only Private endpoints are allowed, and Public Access is restricted as part of Enterprise Policy)"

    Elastic queries do not support private endpoints.

    Hope that helps.

    Regards,

    Oury

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.