I am designing a data warehouse using Azure Databases (not Azure Data Warehouse though),
I have 2 databases: the main data warehouse and a staging database. As in a traditional ETL process, the raw data is stored in the staging, then transformed and finally loaded to the data warehouse/data marts.
Since it is Azure SQL, cross database queries don't work and the only workaround I know is using external data sources and external tables, which is pretty problematic.
Can you recommend the best solution to access both databases at the same time? My ideal solution would be cross database queries like in SQL Server on premise.