Fabric SQL Databases cross reference

Hi nilendraFabric ,

yes I tried and it doesn't work, but now I'm clearing my head on this.

For what I see, when you use the logical database name you are always referring to the SQL endpoint. Also, the only objects of the SQL database visible through the SQL endpoint are the tables: my logging.LogLevel view is defined in the database and I don't see it in the Views folder of the SQL endpoint, but I can create the same view in the Sql endpoint so that in a way solves the problem.

Anyway you cannot reference the SQL endpoint from its database counterpart: if I run the query

SELECT * FROM DB1.logging.LogLevel; 

in the database DB1 I get the same reference error. If I run it from the SQL endpoint of another database, it works.

So, in conclusion, cross-database reference is (currently?) only for SQL endpoint as stated in the docs, that's why I asked whether it will be supported in the future. We'll see.