For Mongodb joins not supported

Is that issue still not resolved as i saw this request, requested in 2019.

Also if joins not possible in custom question, can we use joins in native query for MONGODB?

Hi @varnika

For reference for everybody else: - upvote by clicking :+1: on the first post

No, joins are not supported in the GUI. MongoDB didn't support this until somewhat recently, and joins in MongoDB are very different from other databases.
You would currently have to write the join queries yourself.

Hello Same here. I have no problem writing my queries for MongoDB. But somehow metabase have altered the values of my foreign key column. And this make it impossible to do join queries.

Example :
PRODUCTS : Colums Id : ABC123 Name : IPHONE
and ORDERS Column : ProductId : Value in Metabase "PRODUCTS_ABC123" Value in my mongodb : "ABC123"

How can i fix this ?


@satyam123 I don't understand your example. Doesn't look like a Native query.
You can make joins in Native query: Custom mongodb query in metabase