Is Elastic Query for Azure SQL still in PREVIEW

Question

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)

Answer 1

@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

Answer 2

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.