as question, would you please advise?

In the context of Azure SQL Database and the concept of "Elastic Query," the term "Three and Four-part names" refers to the naming conventions used for referencing objects (tables, views, etc.) across different databases in a federated database system. Three-Part Name: A three-part name includes the name of the database, the schema, and the object name - for example DatabaseName.dbo.Employee Four-Part Name: A four-part name extends the three-part name by including the server or data warehouse name - for example ServerName.DatabaseName.dbo.Employee In Elastic Query, which is part of Azure SQL Database, you can use three and four-part names to query data across multiple databases within the same logical server or even across different logical servers. This is achieved by setting up an elastic database query with the necessary credentials and configurations. hth Marcin

What does "Three and Four-part names? mean in "Elastic Query?

Accepted answer

Marcin Policht 16,420 Reputation points MVP

2024-02-18T15:14:50.6133333+00:00
In the context of Azure SQL Database and the concept of "Elastic Query," the term "Three and Four-part names" refers to the naming conventions used for referencing objects (tables, views, etc.) across different databases in a federated database system.

Three-Part Name: A three-part name includes the name of the database, the schema, and the object name - for example DatabaseName.dbo.Employee

Four-Part Name: A four-part name extends the three-part name by including the server or data warehouse name - for example ServerName.DatabaseName.dbo.Employee

In Elastic Query, which is part of Azure SQL Database, you can use three and four-part names to query data across multiple databases within the same logical server or even across different logical servers. This is achieved by setting up an elastic database query with the necessary credentials and configurations.

hth
Marcin
Please sign in to rate this answer.

1 person found this answer helpful.
anand 225 Reputation points

2024-02-18T15:56:32.4033333+00:00

Hi Ho Ming Tam,

this query execution does not complete.

(1) Please elaborate what happens when "this query execution does not complete". DO you get an error? If so then we need to get the exact full error.

(2) Please confirm that you execute the query while connected the right database. It might be related to the executing the query while connected to a different database which is why using three parts names works while two parts names do not find the object

Execute the following query and confirm that you are in the dbone database:

select DB_NAME()

If you do not get dbone then this is the issue If you do not get dbone then this is the issueYes, 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.

Ho Ming Tam 45 Reputation points

2024-02-18T15:57:35.9466667+00:00

Thank you so much 😊

AmaranS 3,260 Reputation points Microsoft Vendor

2024-02-18T16:10:19.7566667+00:00

Hi Ho Ming Tam, We're pleased to hear that your concern has been resolved. Should you encounter any further issues, please feel free to contact us. We're here to assist you. Thank you.
Sign in to comment

Share via

What does "Three and Four-part names? mean in "Elastic Query?

0 additional answers