turbot/mongodbatlas
steampipe plugin install mongodbatlas

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
idtext=Unique identifier for the organization.
is_deletedbooleanFlag indicating if the organization is deleted.
nametextName of the organization.
organization_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the organization.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle 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