To my mind, Compass is the most native way to work with your MongoDB data because it greatly improves productivity. To my mind, MongoDB and Mongo Compass work together like a charm. Voila! Now that you have a new collection named athletes and it is filled with the data, you can get a preview of all the documents, represented in Table/List View.Ĭheck out all the basic statistics about the total number of documents in the collection, total and average sizes of documents, indexes, and fields. So, import a traditional JSON array into MongoDB by running the following command in the CLI: mongoimport -db -collection athletes -type json -file athletes.json -jsonArray Taking into account that the documents in MongoDB are stored as JSON, we need to convert the CSV file to the JSON file.īefore creating a collection in the database, consider that MongoDB requires a special format of JSON data: ] We’ll try extracting any insights from it. To make this overview more exciting, I’ve decided to examine the Kaggle dataset, devoted to 120 years of Olympic history. Take a quick glance and move on to creating the collections - you can come back to assess the performance later. It illustrates what is happening in your cluster: what are the operations performed, network traffic analysis, connections and memory consumption. If you click the Performance tab, you’ll see the real-time server analytics. Here you can choose one of them, check their storage size, number of collections and indexes. In the center of the page, you’ll see the databases list. ![]() The left panel will remind you about recent connections - you can pick one of them to autofill the fields and start quickly. Here you need to specify all connection configurations: hostname, port, type of authentication, SSL, SSH Tunnel, etc. Once you run Compass, you’ll find yourself at the landing page. We’ll get acquainted with the main functionality and perform some of the basic exploratory analysis tasks. Let’s see how well Compass handles visualizing the data. You can download and install this application by following the steps from this guide. All versions run smoothly on Windows and Mac OS X. The tool is delivered in three versions - Community, Enterprise and Enterprise Read-Only. It comes with a rich collection of features: you can explore/edit/add/remove your data, build aggregation pipelines interactively, implement data validation and evaluate the performance of a particular collection or a database. One of the tools that help understand the underlying data stored in collections is MongoDB Compass - a GUI application which eliminates the need for connecting to the Mongo shell or learning the MongoDB query syntax. Since MongoDB has a flexible and not rigidly constrained schema, every developer or database administrator needs a powerful tool to work with the data efficiently and analyze it with ease.
0 Comments
Leave a Reply. |