Table: mongodbatlas_org - Query MongoDB Atlas Organizations using SQL

MongoDB Atlas is a cloud database service for applications that work with data in a variety of formats, including structured, semi-structured, and polymorphic. It provides a scalable and secure way for businesses to manage their data. MongoDB Atlas Organizations are higher-level entities that allow for the management of multiple projects and their associated members, teams, and roles.

Table Usage Guide

The mongodbatlas_org table provides insights into the organizations within MongoDB Atlas. As a Database Administrator, explore organization-specific details through this table, including roles, users, and configuration settings. Utilize it to manage and monitor your organizations, such as understanding user permissions, role assignments, and the configuration of each organization.

Examples

Basic info

Explore the basic information of your MongoDB Atlas organizations by identifying their unique identifiers and names. This can be beneficial for managing and tracking your organizations in a more organized manner.

select
  id,
  name
from
  mongodbatlas_org;

select
  id,
  name
from
  mongodbatlas_org;

List deleted organizations

Discover the segments that have been removed from your MongoDB Atlas organizations. This is useful for auditing and understanding changes in your organizational structure.

select
  id,
  name
from
  mongodbatlas_org
where
  is_deleted;

select
  id,
  name
from
  mongodbatlas_org
where
  is_deleted = 1;

Schema for mongodbatlas_org

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
id	text	=	Unique identifier for the organization.
is_deleted	boolean		Flag indicating if the organization is deleted.
name	text		Name of the organization.
organization_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- mongodbatlas

You can pass the configuration to the command with the --config argument:

steampipe_export_mongodbatlas --config '<your_config>' mongodbatlas_org