Forum Discussion
Cross-Database Queries Don't Work As Documented
The Microsoft documents at these two links both indicate that cross-database queries should be supported by the Fabric SQL Database Preview, through 3-part identifiers. However when I try this in pra...
Hi KyleChamberlin , NandanHegde is correct, you can use the SQL Analytics endpoint to cross-query the 2 databases as an option. SQL Analytics endpoint reflect the replicated/mirrored data from SQL operational/transactional data in OneLake which is stored in delta-parquet format and is read-only. We have received feedback and is in our backlog to assess and evaluate cross-database query using SQL operational endpoint that points to the underlying transactional database from the Fabric database query editor