sql_container_partition_merges
Creates, updates, deletes, gets or lists a sql_container_partition_merges resource.
Overview
| Name | sql_container_partition_merges |
| Type | Resource |
| Id | azure.cosmos_db.sql_container_partition_merges |
Fields
The following fields are returned by SELECT queries:
- list
The SQL container merge operation was completed successfully.
| Name | Datatype | Description |
|---|---|---|
physicalPartitionStorageInfoCollection | array | List of physical partitions and their properties. |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | subscriptionId, resourceGroupName, accountName, databaseName, containerName | Merges 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.
| Name | Datatype | Description |
|---|---|---|
accountName | string | Cosmos DB database account name. |
containerName | string | Cosmos DB container name. |
databaseName | string | Cosmos DB database name. |
resourceGroupName | string | The name of the resource group. The name is case insensitive. |
subscriptionId | string | The ID of the target subscription. |
SELECT examples
- list
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
;