Skip to main content

throughput_pools

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

Overview

Namethroughput_pools
TypeResource
Idazure.cosmos_db.throughput_pools

Fields

The following fields are returned by SELECT queries:

The Throughput Pool properties were retrieved successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectProperties to update Azure Cosmos DB throughput pool.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, throughputPoolNameRetrieves the properties of an existing Azure Cosmos DB Throughput Pool
list_by_resource_groupselectsubscriptionId, resourceGroupNameList all the ThroughputPools in a given resource group.
listselectsubscriptionIdLists all the Azure Cosmos DB Throughput Pools available under the subscription.
create_or_updateinsertsubscriptionId, resourceGroupName, throughputPoolNameCreates or updates an Azure Cosmos DB ThroughputPool account. The "Update" method is preferred when performing updates on an account.
updateupdatesubscriptionId, resourceGroupName, throughputPoolNameUpdates the properties of an existing Azure Cosmos DB Throughput Pool.
deletedeletesubscriptionId, resourceGroupName, throughputPoolNameDeletes an existing Azure Cosmos DB 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.
throughputPoolNamestringCosmos DB Throughput Pool name.

SELECT examples

Retrieves the properties of an existing Azure Cosmos DB Throughput Pool

SELECT
location,
properties,
tags
FROM azure.cosmos_db.throughput_pools
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND throughputPoolName = '{{ throughputPoolName }}' -- 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_pools (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
throughputPoolName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ throughputPoolName }}'
RETURNING
location,
properties,
tags
;

UPDATE examples

Updates the properties of an existing Azure Cosmos DB Throughput Pool.

UPDATE azure.cosmos_db.throughput_pools
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND throughputPoolName = '{{ throughputPoolName }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

Deletes an existing Azure Cosmos DB Throughput Pool.

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