Skip to main content

mongodb_collections

Creates, updates, deletes, gets or lists a mongodb_collections resource.

Overview

Namemongodb_collections
TypeResource
Idazure.cosmos_db.mongodb_collections

Fields

The following fields are returned by SELECT queries:

The MongoDB collection property was retrieved successfully.

NameDatatypeDescription
idstringThe unique resource identifier of the ARM resource.
namestringThe name of the ARM resource.
identityobjectIdentity for the resource.
locationstringThe location of the resource group to which the resource belongs.
propertiesobjectThe properties of an Azure Cosmos DB MongoDB collection
tagsobjectTags are a list of key-value pairs that describe the resource. These tags can be used in viewing and grouping this resource (across resource groups). A maximum of 15 tags can be provided for a resource. Each tag must have a key no greater than 128 characters and value no greater than 256 characters. For example, the default experience for a template type is set with "defaultExperience": "Cassandra". Current "defaultExperience" values also include "Table", "Graph", "DocumentDB", and "MongoDB".
typestringThe type of Azure resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, databaseName, collectionNameGets the MongoDB collection under an existing Azure Cosmos DB database account.
listselectsubscriptionId, resourceGroupName, accountName, databaseNameLists the MongoDB collection under an existing Azure Cosmos DB database account.
create_updateinsertsubscriptionId, resourceGroupName, accountName, databaseName, collectionName, data__propertiesCreate or update an Azure Cosmos DB MongoDB Collection
deletedeletesubscriptionId, resourceGroupName, accountName, databaseName, collectionNameDeletes an existing Azure Cosmos DB MongoDB Collection.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
accountNamestringCosmos DB database account name.
collectionNamestringCosmos DB collection name.
databaseNamestringCosmos DB database name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets the MongoDB collection under an existing Azure Cosmos DB database account.

SELECT
id,
name,
identity,
location,
properties,
tags,
type
FROM azure.cosmos_db.mongodb_collections
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND collectionName = '{{ collectionName }}' -- required
;

INSERT examples

Create or update an Azure Cosmos DB MongoDB Collection

INSERT INTO azure.cosmos_db.mongodb_collections (
data__properties,
data__location,
data__tags,
data__identity,
subscriptionId,
resourceGroupName,
accountName,
databaseName,
collectionName
)
SELECT
'{{ properties }}' /* required */,
'{{ location }}',
'{{ tags }}',
'{{ identity }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ databaseName }}',
'{{ collectionName }}'
RETURNING
id,
name,
identity,
location,
properties,
tags,
type
;

DELETE examples

Deletes an existing Azure Cosmos DB MongoDB Collection.

DELETE FROM azure.cosmos_db.mongodb_collections
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND databaseName = '{{ databaseName }}' --required
AND collectionName = '{{ collectionName }}' --required
;