Join between MySQL schemas

Get Help
1

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?

2

I’d create a new schema that only includes views of the other schemas.

1 Like
3

Hmmmmm! That hadn’t cross my mind, going to work that out! Thanks!

4

The other advantage is that you can clear all the clutter and not have to wade through all the rubbish.

1 Like