Cross-db queries

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.

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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:

    https://modeanalytics.com/modeanalytics/reports/c1adcc8b14d6/python

    Reply Like
  • Donna McGahan Thanks for the quick response. This is a pretty important feature for more than my most basic tasks, so I'll be looking forward to that in the future.

    Reply Like
  • I'll make sure we post something here if and when this feature becomes available.  Thanks!

    Reply Like
login to reply
Like Follow
  • Status Answered
  • 13 days agoLast active
  • 3Replies
  • 39Views
  • 2 Following

Create A New Discussion

Share your thoughts