Skip to main content

throughput_pool_accounts

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

Overview

Namethroughput_pool_accounts
TypeResource
Idazure.cosmos_db.throughput_pool_accounts

Fields

The following fields are returned by SELECT queries:

The Throughput Pool properties were retrieved successfully.

NameDatatypeDescription
propertiesobjectAn Azure Cosmos DB Global Database Account which is part of a Throughputpool.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, throughputPoolName, throughputPoolAccountNameRetrieves the properties of an existing Azure Cosmos DB Throughput Pool
listselectsubscriptionId, resourceGroupName, throughputPoolNameLists all the Azure Cosmos DB accounts available under the subscription.
createinsertsubscriptionId, resourceGroupName, throughputPoolName, throughputPoolAccountNameCreates or updates an Azure Cosmos DB ThroughputPool account. The "Update" method is preferred when performing updates on an account.
deletedeletesubscriptionId, resourceGroupName, throughputPoolName, throughputPoolAccountNameRemoves an existing Azure Cosmos DB database account from a throughput pool.

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
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.
throughputPoolAccountNamestringCosmos DB global database account in a Throughput Pool
throughputPoolNamestringCosmos DB Throughput Pool name.

SELECT examples

Retrieves the properties of an existing Azure Cosmos DB Throughput Pool

SELECT
properties
FROM azure.cosmos_db.throughput_pool_accounts
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND throughputPoolName = '{{ throughputPoolName }}' -- required
AND throughputPoolAccountName = '{{ throughputPoolAccountName }}' -- required
;

INSERT examples

Creates or updates an Azure Cosmos DB ThroughputPool account. The "Update" method is preferred when performing updates on an account.

INSERT INTO azure.cosmos_db.throughput_pool_accounts (
data__properties,
subscriptionId,
resourceGroupName,
throughputPoolName,
throughputPoolAccountName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ throughputPoolName }}',
'{{ throughputPoolAccountName }}'
RETURNING
properties
;

DELETE examples

Removes an existing Azure Cosmos DB database account from a throughput pool.

DELETE FROM azure.cosmos_db.throughput_pool_accounts
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND throughputPoolName = '{{ throughputPoolName }}' --required
AND throughputPoolAccountName = '{{ throughputPoolAccountName }}' --required
;