Skip to main content

sql_container_partition_merges

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

Overview

Namesql_container_partition_merges
TypeResource
Idazure.cosmos_db.sql_container_partition_merges

Fields

The following fields are returned by SELECT queries:

The SQL container merge operation was completed successfully.

NameDatatypeDescription
physicalPartitionStorageInfoCollectionarrayList of physical partitions and their properties.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectsubscriptionId, resourceGroupName, accountName, databaseName, containerNameMerges the partitions of a SQL Container

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.
containerNamestringCosmos DB container name.
databaseNamestringCosmos DB database name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Merges the partitions of a SQL Container

SELECT
physicalPartitionStorageInfoCollection
FROM azure.cosmos_db.sql_container_partition_merges
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND containerName = '{{ containerName }}' -- required
;