MongoDB Compass – Missing a Schema Section

While working on SQL Server Comprehensive Database Performance Health Check, with a client who uses many different SQL and NoSQL databases. During the consultation engagement, we ended up a very interesting query which actually runs faster on MongoDB and slows on SQL Server. I asked him to show me a Schema for the table in MongoDB, which inspired me to write this blog post on MongoDB Compass – Missing a Schema Section.

MongoDB Compass - Missing a Schema Section mongodbcompass-800x265

MongoDB Compass

If you are using MongoDB, I am very confident that you are familiar that there are two primary tools to interact with MongoDB: 1) MongoDB Compass – Graphical interface and 2) MongoDB Shell – Command Prompt.

Solarwinds

As I requested my client to show me a Schema of a MongoDB table, he opened the most popular tool MongoDB Compass and to his surprise, there was a no TAB for Schema. The DBA was really confused and frustrated as every single time he was able to use the Schema Tab which was missing at this point in time.

MongoDB Compass - Missing a Schema Section mongodbcompass0

After a while, he realized that while in a rush, instead of MongoDB Compass, he had opened MongoDB Compass Community, which has limited features. He eventually opened MongoDB Compass and was able to find the Schema tab and we were able to look at the necessary schema. After figuring out the Schema of the table, I was able to help him to improve his SQL Server query, which eventually ran faster on SQL Server. I will write a detail blog post in the future.

MongoDB Compass - Missing a Schema Section mongodbcompass1

Summary – Missing a Schema Section

If you ever find Schema and Validation Tab missing in your MongoDB Compass, it is quite possible that instead of MongoDB Compass, you have opened MongoDB Compass Community which has limited features. You can download MongoDB Compass from this link.

Learning

Here are some of the relevant blog posts on MongoDB.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Solarwinds
, ,
Previous Post
SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
Next Post
State of Database Monitoring 2020 – Need Your Opinion

Related Posts

Leave a Reply

Menu