Join table equivalent in MongoDB

bradford_li · September 8, 2020, 10:55pm

Hello,

I am new to MongoDB so I am having a bit of trouble

In traditional relational databases, I would have a “join” table to create a one-to-many relationship which looks like this.

UUID | EMAIL

Pavel_Duchovny · September 9, 2020, 5:22am

Hi @bradford_li,

Joins consider an antipattern in MongoDB and should be avoided as possible by embading documents as subdocuments and performing several lookup queries .

If for any reason joining collections is a must you can use $lookup or $graphLookup to perform this aggregation

Pavel