Skip to content
Studio 3T - The professional GUI, IDE and client for MongoDB
  • Tools
    • Aggregation Editor
    • IntelliShell
    • Visual Query Builder
    • Export Wizard
    • Import Wizard
    • Query Code
    • SQL Query
    • Connect
    • Schema Explorer
    • Compare
    • SQL ⇔ MongoDB Migration
    • Data Masking
    • Task Scheduler
    • Reschema
    • More Tools and Features
  • Solutions
  • Resources
    • Knowledge Base
    • MongoDB Tutorials & Courses
    • Tool/Feature Documentation
    • Reports
    • Case Studies
    • Whitepapers
    • Blog
    • Testimonials
    • Community
  • Contact us
    • Contact
    • Sales Support
    • Feedback and Support
    • Career
    • About Us
  • Store
    • Buy Now
    • Preferred Resellers
    • Team Pricing
  • My License
  • Download
search

What’s New in Studio 3T 2022.1 – SQL Connection Import/Export, MongoDB-AWS authentication

Posted on: 27/01/2022 (last updated: 09/02/2022) by DJ Walker-Morgan

Update 2022.1.1: We resolved a late-breaking issue with session restore and the Visual Query Builder.

Studio 3T 2022.1 is the January release of Studio 3T and we’ve been working on some carefully selected features. First up, the SQL Connection Manager is coming to the fore with its own menu item and export and import capabilities. Then there’s MONGODB-AWS authentication support, a feature for MongoDB Atlas users who log into their clusters using IAM roles. We’ve also added in a new operator in the Visual Query Builder, made Connection Groups exportable and made the Operations Pane more informative. So, here’s the full rundown:

Headline features in Studio 3T 2022.1

SQL Connections are now available for exporting and importing using the SQL Connection Manager. The SQL Connection Manager is also more visible with a Manage SQL Connections option available in the File menu. Previously you could only get to it through the SQL Import/Export and Migration tools.

Exporting SQL Connections with Studio 3T 2022.1
Exporting SQL Connections with Studio 3T 2022.1

AWS IAM credentials are now available for use by MongoDB Atlas users. The connections authentication tab includes a new authentication mechanism, MONGODB-AWS that supports AWS IAM credentials. The option allows you to enter an AWS access key ID and a secret access key for a MongoDB enabled IAM role. Refer to the Atlas IAM documentation on how to configure IAM roles that work with MongoDB.

Visual Query Builder now supports the $slice operator in projections. This lets you project a specific number of elements from an array into your results.

Other Improvements in Studio 3T 2022.1

Operations Pane is now more informative with the operations tree now including timestamps and extra log information.

Connection Groups in the Connection Manager are now saveable when exporting and restorable when importing so you can keep your carefully curated connections in their folders.

Query Bar in the Collections Tab has improved Keyboard and mouse selection. The text fields now have more precise and useful word selection boundaries to help users edit more precisely.

User Shoutouts

We’d like to thank the users of Studio 3T who have yet again been invaluable to making Studio 3T better for them and everyone else. 

For Studio 3T 2022.1, those thanks go to Shmuel Witman who suggested including groups in Connection Import and Export, Rand Nix who reported the problems with doubles and decimals in SQL migration and to Wernfried Domscheit who offered us ideas about enhancing the autocomplete experience.

Also Improved in Studio 3T 2022.1

Auto-completion will now automatically closes when it is not needed.

Aggregation Editor now starts up faster.

Migration to SQL can now use placeholders when migrating to files, generating unique, timestamped names for files.

Fixed

Custom Column Order now persists nested objects and restores natural order correctly.

Migration from SQL now correctly imports floating point numbers as MongoDB’s NumberDecimal type.

Visual Query Builder now correctly represents $elemMatch queries.

Collection Tab had an issue where the document count would report as 1. And now it doesn’t.

For the full history of changes in Studio 3T, see the change log.

Download Studio 3T

Auto-update in the app, or start your free 30-day trial today:

Try Studio 3T 2022.1.1

How helpful was this article?
This article was hideous
This article was bad
This article was ok
This article was good
This article was great
Thank you for your feedback!

About The Author

DJ Walker-Morgan

Dj has been around since Commodore had Pets and Apples grew everywhere. With a background in Unix and development, he's been around the technology business writing code or writing content ever since.

Related articles

  • What’s New in Studio 3T 2020.7 | Export Documents from Table View to CSV, Edit find() Queries During Export & More
  • What’s New in Studio 3T 2022.4 – Date Tags, Smarter Columns, Saving SQL Mappings
  • MongoDB Monitoring, Auditing & Authentication: 3 Steps to Secure Your Database
  • Import and Export
  • What’s New in Studio 3T 2022.2 – Apple Silicon Support, Find Options, and $setWindowFields

Tags

academy aggregation AMA atlas community connections date tags export features hackolade import intellishell JSON knowledge base migration modelling mongodb mongoodb productivity query regex releases schema security SQL Studio 3T tasks tips updates webinar windows

Browse by MongoDB topic

  • Connecting to MongoDB
  • Database Administration & Security
  • Getting Started with MongoDB
  • Getting Started with Studio 3T
  • Import/Export
  • Job Automation & Scheduling
  • MongoDB Aggregation Framework
  • MongoDB/Studio 3T Workshops
  • Performance
  • Query & CRUD Operations
  • Schema
  • Studio 3T Licensing
  • Support and other resources
  • Working with MongoDB & SQL
  • Working with MongoDB Atlas

Studio 3T

MongoDB Enterprise Certified Technology PartnerSince 2014, 3T has been helping thousands of MongoDB developers and administrators with their everyday jobs by providing the finest MongoDB tools on the market. We guarantee the best compatibility with current and legacy releases of MongoDB, continue to deliver new features with every new software release, and provide high quality support.

Find us on FacebookFind us on TwitterFind us on YouTubeFind us on LinkedIn

Education

  • Free MongoDB Tutorials
  • Connect to MongoDB
  • Connect to MongoDB Atlas
  • Import Data to MongoDB
  • Export MongoDB Data
  • Build Aggregation Queries
  • Query MongoDB with SQL
  • Migrate from SQL to MongoDB

Resources

  • Feedback and Support
  • Sales Support
  • Knowledge Base
  • FAQ
  • Reports
  • Case Studies
  • White Papers
  • Testimonials
  • Discounts

Company

  • About Us
  • Blog
  • Careers
  • Legal
  • Press
  • Privacy Policy
  • EULA

© 2022 3T Software Labs GmbH. All rights reserved.

  • Privacy Policy
  • Cookie settings
  • Impressum
When you click "Accept", you are agreeing to cookies being on your device. They may improve site navigation, site usage analysis, or the relevance of messages. It is up to you which cookies are enabled. Read our Privacy Policy.
Manage cookies
Accept
✕

Privacy Preference Center

A cookie is a small file of letters and numbers that is downloaded on to your computer when you visit a website. Cookies are used by many websites and can do a number of things, eg remembering your preferences, recording what you have put in your shopping basket, and counting the number of people looking at a website. In the form below you can choose which cookies, except for essential cookies, to allow or disable.

Accept all cookies

Manage consent preferences

Essential cookies are strictly necessary to provide an online service such as our website or a service on our website which you have requested. The website or service will not work without them.

Performance cookies allow us to collect information such as number of visits and sources of traffic. This information is used in aggregate form to help us understand how our websites are being used, allowing us to improve both our website’s performance and your experience.

Functional cookies collect information about your preferences and choices and make using the website a lot easier and more relevant. Without these cookies, some of the site functionality may not work as intended.

Social media cookies are cookies used to share user behaviour information with a third-party social media platform. They may consequently effect how social media sites present you with information in the future.

Accept selected