Joins in metabase

it is possible to create joins between the tables in metabase

if it is possible please provide the document, which helps to clear the issues

Thanks…

1 Like

Hi @vasuk1908
Yes, by making a Native Query, since it’s just like making a regular SQL query.
Currently not possible visually via Custom (Query Browser), but that will change in version 0.33 with the new Notebook-mode.

Where can I read more about 0.33? That “notebook-mode” is absolutely unknown to me, reading about it got me a bit excited here lol

This is a feature that would be really helpful.

By the way, you can link tables using foreign keys, so they show up like this:
image

In the admin side (editing data model, selecting the desired table, changing the column type, and selecting the desired target column on the target table):

Not sure if this is what you wanted, but, anyway, there it is.

@lucas.lima
I think the only official statement is in the blog post of the 0.32 release (at the bottom):
https://www.metabase.com/blog/0.32/index.html
But if you spend way too many hours with this project and follow all of the PR commits, then you’ll notice upcoming features - and then it helps if you visit the Metabase team and get an awesome preview from Tom :wink:
https://github.com/metabase/metabase/pull/9592
It’s a totally different way to browse data compared to the old Query Browser, so it’ll take a few minutes to get used to it, but it looks awesome and adds new features that wasn’t available before.

2 Likes