Is it possible to do cross-database T-SQL queries in Mode? I have tried doing something like
SELECT * FROM dbo.table1 t1 [server_name].database2.dbo.table2 t2 JOIN t1.uid = t2.uid
But I get an Invalid object name error with this syntax.
Hi Andrew , Mode does not currently support cross database joins. We have had requests for this feature so it is being considered. You can use Python Notebook to merge data from different queries that use different data sources though. Here is an example report that does this:Reply