@jesse @arikfr -

Could you pleas help or share some links where I can learn how to write queries for mongo db for redash… it’s look like the redash some JSON queries for mongo db.

Was tried to googling but no luck.

Redash translates the JSON into a db.collection.find and db.collection.aggregate API calls. You can see more information here: https://redash.io/help/data-sources/querying/mongodb.

here you can write where query like this -:

{
“collection”:“student”,

  "query": {
	"roll_no" : "110011"
}

}

There’s complete examples in our documentation for MongoDB here.