How to Create MongoDB Joins Using SQL
Learn how to write SQL join queries to generate MongoDB joins in the form of aggregation queries.
Archives
Using Aggregation and Regex in MongoDB to Reduce Data in a Collection
Learn how to use regex to transform an external data set to JSON or export it to CSV for later import, and run aggregation queries to reduce the data before creating a MongoDB collection.
Find slow queries in MongoDB with Query Profiler
Learn about the Query Profiler and the MongoDB Database Profiler: how you can collect profiling data to investigate and optimize query performance in MongoDB.
Check MongoDB Schema with Schema Explorer
Schema Explorer makes it easy to visualize data distributions, find schema anomalies, and generate schema documentation which can be exported as a Word or CSV file.
Query Code
Query Code is the automatic code generation feature that converts MongoDB, aggregation, and SQL queries to JavaScript (Node.js), Java (2.x and 3.x driver API), Python, C#, Ruby, and the mongo shell language.
Tree View
Tree View displays data in a hierarchical view, which can be expanded or collapsed as needed.
Table View
Table View is the spreadsheet view that supports advanced features like showing embedded fields, stepping into array-valued columns, and hiding columns – even when dealing with large datasets.
IntelliShell
IntelliShell is the built-in mongo shell interface with smart auto-completion of collection names, shell methods, document key names, operators, and field names.
A Practical Introduction to MongoDB Views
We introduce the idea of MongoDB views – what they are, why they’re useful, when to use them, and how they relate to data aggregations – and walk you through how to create a view in Studio 3T using a small practice database courtesy of the UK’s Met Office.
Collection Tab
The Collection Tab is the starting point for all data exploration and analysis in Studio 3T.
