I’ve read this http://discourse.metabase.com/t/use-data-from-two-databases-in-one-question/337
but it is not exactly what I need. I have two different databases, but they are actually the same, but different schemas, just because I can’t connect to MySQL DBs without specifying a schema. Therefore, I can use those different schemas using the native queries, by typing schema.table or another_schema.another_table, but I’m unable to use the foreign_key functionality in the Data Model tab.
I have an Oracle database conected, and there I’m able to use different schemas to do joins and other stuff, since I don’t have to specify a single one when connecting to it. Is this a technical barrier which can’t be traspassed, or is there some kind of workaround?