Running a Mongo DB Query using Redash

MongoDB is a document database, which means it stores data in JSON like documents

Redash is an open source tool for teams to query, visualize and collaborate. Redash supports SQL, NoSQL, Big Data and API data sources - query your data from different sources to answer complex questions. In this write up, we will use Redash tool to query our NO SQL DB- Mongo DB.

Here are the steps on how to use Redash tool to query the DB

Steps:

  1. Get access to Redash requesting your team

  2. Login to Redash using your credentials

  3. Select the Data source from drop down


  1. You will see list of DB Tables under the selected data source






2.


2.
  1. Write a Query in JSON format and click Execute Button. Remember, No-SQL DB always use JSON format as the data is stored as files.

Eg:

You should see the records 

Note/ QA Tip: The results from API can be validated in the Mongo DB here

Comments