Work with MongoDB data
Once you've imported your MongoDB Atlas data into the platform, you can start analyzing and monitoring your MongoDB Atlas cost and usage. Data is tracked and reported on an hourly basis.
MongoDB Atlas API
The console interacts with the MongoDB Atlas APIs.
| API | Description |
|---|---|
| Authentication | Access token for MongoDB Atlas APIs. |
| Return all organizations | Returns all organizations to which the requesting Service Account or API Key has access. |
| Returns all invoices for one organization | Returns all invoices that MongoDB issued to the specified organization. This list includes all invoices regardless of invoice status. |
| Return one invoice for one organization | Returns one invoice that MongoDB issued to the specified organization. |
| Return one invoice as CSV for one organization | Returns one invoice in CSV format, which includes the Atlas region for each line item. |
The required permissions are granted when you create a service account for the DoiT connector.
MongoDB data in Cloud Analytics
You can get MongoDB data through dimensions and metrics. See below for the mapping between the DoiT and MongoDB terminologies.
In MongoDB Atlas, groups and projects are synonymous terms that refer to logical containers for clusters, teams, and settings. Atlas API endpoints exclusively use group in paths, while Atlas UI mainly uses Project. A group ID and a project ID are the same thing.
See MongoDB's official documentation for further explanation.
Basic metrics
DoiT term | MongoDB term | Description |
|---|---|---|
cost | cost | The billing data for MongoDB Atlas organizations using MongoDB Atlas Cost Explorer APIs. |
usage | usage | The usage data for MongoDB Atlas organizations using MongoDB Atlas Cost Explorer APIs. |
Standard dimensions
| DoiT Term | MongoDB Term | Description |
|---|---|---|
| Billing Account | organization.id | A unique identifier for a MongoDB Atlas organization. |
| Project/Account ID | lineItems.groupId | A unique identifier for a MongoDB Atlas project (also called group in the Atlas API terms). |
| Project/Account Name | lineItems.groupName | The human-readable name of the MongoDB Atlas project. |
| Resource, Resource ID | lineItems.groupId:lineItems.clusterName | The MongoDB cluster, scoped by project, so clusters with the same name in different projects aren't merged. Empty for charges not tied to a cluster (for example, support or organization-level line items). For data ingested before this change, Resource ID was the bare cluster name. |
| Location | Atlas invoice Region | The Atlas region display name for the line item, for example, N. Virginia or Frankfurt. Empty for charges that Atlas does not attribute to a specific region, such as support or organization-level line items. Line items on multi-region clusters may also have no Location when the region can't be determined unambiguously from the invoice. For data ingested before this change, this field will be blank until the rows are re-ingested or backfilled. |
| SKU, SKU ID | lineItems.sku | A human-readable description of MongoDB services used, for example, instance type, backup download, data transfer, or another service. Usually written in all caps, like ATLAS_AWS_INSTANCE_M80_LOW_CPU. |
| Service, Service ID | lineItems.sku | A high-level service category for SKUs, for example, Backup, Clusters, Data Transfer, Premium Features. |
| Cost Type | cost_type | The type of cost. Always Usage for MongoDB. |
| Unit | lineItems.unit | The unit of measure for the usage amount, for example, hours, server hours, GB, or GB days. |
System labels
All MongoDB Atlas resource tags are automatically pulled and available as system labels in Cloud Analytics. You can use these labels to organize and filter your data when building reports or allocations.
Each tag appears with the mongodb/ prefix followed by the tag key. For example, if you have a tag called environment, it appears as mongodb/environment.