Last Updated: 2024-01-18


When setting up a MongoDB catalog in Starburst Galaxy, the type of access available varies based on your deployment configuration. If your MongoDB instance is a single node or has replica sets within the same cloud provider region, Starburst Galaxy supports both read and write access. However, if your MongoDB instance has replica sets spanning multiple cloud provider regions, the Galaxy catalog only supports read-only access.

In the case of a MongoDB Atlas federated database instance, the Starburst Galaxy catalog provides read-only access. It's important to note that Starburst Galaxy also supports tables where all rows adhere to the same schema.

Scope of tutorial

In this tutorial, you will learn how to configure a MongoDB catalog in Starburst Galaxy.

Learning objectives

Once you've completed this tutorial, you will be able to:


About Starburst tutorials

Starburst tutorials are designed to get you up and running quickly by providing bite-sized, hands-on educational resources. Each tutorial explores a single feature or topic through a series of guided, step-by-step instructions.

As you navigate through the tutorial you should follow along using your own Starburst Galaxy account. This will help consolidate the learning process by mixing theory and practice.


Now it's time to pivot over to Starburst Galaxy to begin the process of connecting your MongoDB datasource.

Starburst Galaxy separates users by role. Configuring a new catalog will require access to a role with appropriate privileges. Today, you'll be using the accountadmin role.

This is a quick step, but an important one.

Step 1: Sign into Starburst Galaxy

Sign into Starburst Galaxy in the usual way. If you have not already set up an account, you can do that here.

Step 2: Set your role

Your current role is listed in the top right-hand corner of the screen.


The steps below will show you how to start the process of configuring a new catalog.

Step 1: Create a new catalog

Step 2: Select MongoDB

Starburst Galaxy allows the creation of catalogs for a number of different data sources.

Step 3: Input cloud provider, name, and description

MongoDB works with all three major cloud providers: AWS, Azure, and GCP. You will need to select which one you want to use for this catalog.

Additionally, the catalog needs both a name and description.

When you connect Starburst Galaxy to a new datasource, it is necessary to undergo an authentication process. This helps ensure that you are connecting the right data source and that you have the appropriate permissions.

Step 1: Choose the connection type

Now it's time to choose a connection type. There are three options:

Step 2: Enter MongoDB connection details

Next, you need to connect Starburst Galaxy to MongoDB. To do this, you're going to enter details from your MongoDB account to create the connection.


Every new catalog connection includes a test before you connect it. This helps to ensure that you have input the correct credentials and allows you to quickly fix any problems before actually connecting.

Step 1: Test and Connect

You're almost there! Time to test the connection and then complete the process of creating your new MongoDB catalog.


Starburst Galaxy allows you to configure your catalog in a number of ways regarding access controls. The most important of these involves granting write access or restricting the catalog to read-only access.

Take some time to consider whether you require write access, or whether read-only access will be sufficient.

Step 1: Select read access

Select the appropriate read access for your situation.


The catalog is now created, but you are not able to use it until you add it to a cluster. Clusters can include many catalogs. You can either add the new MongoDB catalog to an existing cluster, or do this at a later stage.

Step 1: Add catalog to cluster or skip

You can add a catalog to a cluster at any time.

Tutorial complete

Congratulations! You have reached the end of this tutorial, and the end of this stage of your journey.

You're all set! Now you can query the data in your MongoDB datasource.

Continuous learning

At Starburst, we believe in continuous learning. This tutorial provides the foundation for further training available on this platform, and you can return to it as many times as you like. Future tutorials will make use of the concepts used here.

Next steps

Starburst has lots of other tutorials to help you get up and running quickly. Each one breaks down an individual problem and guides you to a solution using a step-by-step approach to learning.

Tutorials available

Visit the Tutorials section to view the full list of tutorials and keep moving forward on your journey!

Start Free with
Starburst Galaxy

Up to $500 in usage credits included

  • Query your data lake fast with Starburst's best-in-class MPP SQL query engine
  • Get up and running in less than 5 minutes
  • Easily deploy clusters in AWS, Azure and Google Cloud
For more deployment options:
Download Starburst Enterprise

Please fill in all required fields and ensure you are using a valid email address.