Table: mongodbatlas_team - Query MongoDB Atlas Teams using SQL

MongoDB Atlas Teams is a feature within MongoDB Atlas that allows you to manage user access and permissions. It provides a centralized way to group users and assign specific roles and privileges to them. MongoDB Atlas Teams helps you maintain security and governance by controlling user access to your MongoDB Atlas resources.

Table Usage Guide

The mongodbatlas_team table provides insights into Teams within MongoDB Atlas. As a Database Administrator, explore team-specific details through this table, including team IDs, names, and associated users. Utilize it to uncover information about teams, such as user access levels, the distribution of roles among team members, and the overall structure of teams within your MongoDB Atlas environment.

Important Notes

Needs Organization Owner access in the provided key pair.

Examples

Basic info

Explore which team IDs and names are available in your MongoDB Atlas environment. This can be useful for managing access and permissions within your database system.

select
  id,
  name
from
  mongodbatlas_team;

select
  id,
  name
from
  mongodbatlas_team;

List users in all teams

Identify all users across various teams to understand team composition and collaboration dynamics in your MongoDB Atlas environment.

select
  id,
  name,
  jsonb_array_elements(users) as user
from
  mongodbatlas_team;

select
  id,
  name,
  user.value as user
from
  mongodbatlas_team,
  json_each(users) as user;

Schema for mongodbatlas_team

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
id	text		Unique identifier for the team.
name	text		Name of the team.
org_id	text		Unique identifier of the organization for this team.
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.
users	jsonb		Users assigned to the team.

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_team