I know we can use aggregations on sharded clusters. But is it possible to use $lookup and $graphLookup joins on sharded clusters?
Yes, you can. Condition is $lookup stage require running on the database’s primary shard and only on
Let me know if you need more details.
Thank you. To clarify,
You can use $lookup on a sharded cluster (db must be on primary shard).
You cannot use $lookup on a sharded COLLECTION.