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, namefrom mongodbatlas_org;
select id, namefrom 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, namefrom mongodbatlas_orgwhere is_deleted;
select id, namefrom mongodbatlas_orgwhere is_deleted = 1;
Schema for mongodbatlas_org
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
id | text | = | Unique identifier for the organization. |
is_deleted | boolean | Flag indicating if the organization is deleted. | |
name | text | Name of the organization. | |
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