Lookup Stage

Introduction

$lookup is MongoDB's left-outer join. It pulls matching documents from another collection into an array field on the current pipeline.

Syntax reference

{ $lookup: {
  from: "users",
  localField: "userId",
  foreignField: "_id",
  as: "user"
}}

Best practices

• Index the foreignField.
• Limit lookup output with a sub-pipeline.