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
    • Blog
    • Community
    • Testimonials
    • Whitepapers
    • Reports
  • Contact us
    • Contact
    • Sales Support
    • Feedback and Support
    • Careers
    • About Us
  • Store
    • Buy Now
    • Preferred Resellers
    • Team Pricing
  • Download
  • My 3T
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
  • Import and Export
  • Studio 3T SQL Import or Migration? #STUDIO3T_AMA
  • What’s New in Studio 3T 2021.10 | Value Search, Better Task Scheduling and Import Data Masking

Tags

2022 academy aggregation AMA atlas Certification christmas community connections culture date tags events export features hackolade import intellishell In Use JSON knowledge base migration modelling mongodb mongoodb mongosh My 3T productivity query regex releases schema security SQL Studio 3T tasks time series 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
  • Reference
  • 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
  • White Papers
  • Testimonials
  • Discounts

Company

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

© 2023 3T Software Labs Ltd. All rights reserved.

  • Privacy Policy
  • Cookie settings
  • Impressum

We value your privacy

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data.

By clicking “Accept all”, you consent to the storage of cookies and the processing of personal data for these purposes, including any transfers to third countries. By clicking on “Decline all”, you do not give your consent and we will only store cookies that are necessary for our website. You can customize the cookies we store on your device or change your selection at any time - thus also revoking your consent with effect for the future - under “Manage Cookies”, or “Cookie Settings” at the bottom of the page. You can find further information in our Privacy Policy.
Accept all
Decline all
Manage cookies
✕

Privacy Preference Center

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data. Please choose for which purposes you wish to give us your consent and store your preferences by clicking on “Accept selected”. You can find further information in our Privacy Policy.

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.

Google Analytics

Google Ads

Bing Ads

Facebook

LinkedIn

Quora

Hotjar

Reddit

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.

HubSpot

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