How do I view Json schema of a collection?

Kumaresan_Vasagam · 2024-08-06T06:04:26.341Z

hi - I wanted to view the JSON schema associated with a collection. I poked around the documentation and tried ``sqlGetSchema` command, but I get an error “Command not found”. I did set up roles and assigned the role to my user profile in Atlas. Interestingly enough, I could not find this command in Mongo 7.0 documentation . Is this command deprecated? How do I view a JSON schema?

Screenshot 2024-08-05 at 12.44.46 PM2160×684 55.9 KB

Screenshot 2024-08-05 at 12.45.08 PM2160×1174 391 KB

Jack_Woehr · 2024-08-06T19:16:30.438Z

Easy hack in mongosh …

use mydb
db.myCollection.find().pretty()

Jack_Woehr · 2024-08-06T19:18:01.702Z

Of course best would be if when you create a collection you also create validation, then you have a permanent record.

Kumaresan_Vasagam · 2024-08-08T05:36:43.282Z

Thank you for the response. But the query you posted returns the JSON documents. What I want to see is the Json Schema validator I attached with this DB. Regardless of when I attach a json schema validator with the collection (at the time of creation or afterwards), I am not able to view the schema validator on Atlas.

Jack_Woehr · 2024-08-08T14:30:05.022Z

You can see the validator in Compass.

system · 2024-08-13T14:30:59.338Z

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.