Hello all, I am using the community edition of Metabase. I have 2 mongodb databases and need to do a join between the two. Wanted to know if the syntax below is correct, where DB02 is the 2nd DB and the first DB is setup in the Native script window from the dropdown at the top LHS. clientID is a field in DB01, Partner is the table in DB02, and username is the field in partner with whom the join needs to be made.
The query seems to go through but the match is not happening.
[
{
"$lookup": {
"from": "DB02.Partner",
"let": {
"let_clientId_55717": "$clientId"
},
"pipeline": [
{
"$match": {
"$expr": {
"$eq": [
"$$let_clientId_55717",
"Partner__username"
]
}
}
}
],
"as": "join_alias_Partner"
}
}, ...