I have two databases on one server. Is there a way to associate a foreign key in db1.table1 with the primary key in db2.table2?
Currently (0.32.9) Metabase doesn’t allow association/connections/queries across databases. You would need to consolidate your databases in a single source.
Go and upvote by clicking on the first post:
You could access the multiple databases as one:
Or depending on the size/complexity of the data needed you can combine disparate data sources using something like PrestoDB. That has its own pros and cons, but PrestoDB will be faster than linked databases at least in SQL Server 2016.
The cons are mostly that you’ll have to refer to their SQL reference and you’ll want to do a bit of reading to take advantage of it.