Restorable Sql Containers - List

Reference

Service:: Cosmos DB Resource Provider

API Version:: 2024-11-15

Show the event feed of all mutations done on all the Azure Cosmos DB SQL containers under a specific database. This helps in scenario where container was accidentally deleted. This API requires 'Microsoft.DocumentDB/locations/restorableDatabaseAccounts/.../read' permission

GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.DocumentDB/locations/{location}/restorableDatabaseAccounts/{instanceId}/restorableSqlContainers?api-version=2024-11-15

With optional parameters:

GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.DocumentDB/locations/{location}/restorableDatabaseAccounts/{instanceId}/restorableSqlContainers?api-version=2024-11-15&restorableSqlDatabaseRid={restorableSqlDatabaseRid}&startTime={startTime}&endTime={endTime}

URI Parameters

Name	In	Required	Type	Description
instanceId	path	True	string	The instanceId GUID of a restorable database account.
location	path	True	string	Cosmos DB region, with spaces between words and each word capitalized.
subscriptionId	path	True	string	The ID of the target subscription.
api-version	query	True	string	The API version to use for this operation.
endTime	query		string	Restorable Sql containers event feed end time.
restorableSqlDatabaseRid	query		string	The resource ID of the SQL database.
startTime	query		string	Restorable Sql containers event feed start time.

Responses

Name	Type	Description
200 OK	RestorableSqlContainersListResult	The operation completed successfully.
Other Status Codes	CloudError	Error response describing why the operation failed.

Security

azure_auth

Azure Active Directory OAuth2 Flow

Type: oauth2
Flow: implicit
Authorization URL: https://login.microsoftonline.com/common/oauth2/authorize

Scopes

Name	Description
user_impersonation	Impersonate your user account

Examples

CosmosDBRestorableSqlContainerList

Sample request

GET https://management.azure.com/subscriptions/subid/providers/Microsoft.DocumentDB/locations/WestUS/restorableDatabaseAccounts/98a570f2-63db-4117-91f0-366327b7b353/restorableSqlContainers?api-version=2024-11-15&restorableSqlDatabaseRid=3fu-hg==

from azure.identity import DefaultAzureCredential

from azure.mgmt.cosmosdb import CosmosDBManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-cosmosdb
# USAGE
    python cosmos_db_restorable_sql_container_list.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = CosmosDBManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="subid",
    )

    response = client.restorable_sql_containers.list(
        location="WestUS",
        instance_id="98a570f2-63db-4117-91f0-366327b7b353",
    )
    for item in response:
        print(item)


# x-ms-original-file: specification/cosmos-db/resource-manager/Microsoft.DocumentDB/stable/2024-11-15/examples/CosmosDBRestorableSqlContainerList.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

package armcosmos_test

import (
	"context"
	"log"

	"github.com/Azure/azure-sdk-for-go/sdk/azcore/to"
	"github.com/Azure/azure-sdk-for-go/sdk/azidentity"
	"github.com/Azure/azure-sdk-for-go/sdk/resourcemanager/cosmos/armcosmos/v3"
)

// Generated from example definition: https://github.com/Azure/azure-rest-api-specs/blob/ded6306d00ae294c24211e5069c1f56b15ba8ef5/specification/cosmos-db/resource-manager/Microsoft.DocumentDB/stable/2024-11-15/examples/CosmosDBRestorableSqlContainerList.json
func ExampleRestorableSQLContainersClient_NewListPager() {
	cred, err := azidentity.NewDefaultAzureCredential(nil)
	if err != nil {
		log.Fatalf("failed to obtain a credential: %v", err)
	}
	ctx := context.Background()
	clientFactory, err := armcosmos.NewClientFactory("<subscription-id>", cred, nil)
	if err != nil {
		log.Fatalf("failed to create client: %v", err)
	}
	pager := clientFactory.NewRestorableSQLContainersClient().NewListPager("WestUS", "98a570f2-63db-4117-91f0-366327b7b353", &armcosmos.RestorableSQLContainersClientListOptions{RestorableSQLDatabaseRid: to.Ptr("3fu-hg=="),
		StartTime: nil,
		EndTime:   nil,
	})
	for pager.More() {
		page, err := pager.NextPage(ctx)
		if err != nil {
			log.Fatalf("failed to advance page: %v", err)
		}
		for _, v := range page.Value {
			// You could use page here. We use blank identifier for just demo purposes.
			_ = v
		}
		// If the HTTP response code is 200 as defined in example definition, your page structure would look as follows. Please pay attention that all the values in the output are fake values for just demo purposes.
		// page.RestorableSQLContainersListResult = armcosmos.RestorableSQLContainersListResult{
		// 	Value: []*armcosmos.RestorableSQLContainerGetResult{
		// 		{
		// 			Name: to.Ptr("79609a98-3394-41f8-911f-cfab0c075c86"),
		// 			Type: to.Ptr("Microsoft.DocumentDB/locations/restorableDatabaseAccounts/restorableSqlContainers"),
		// 			ID: to.Ptr("/subscriptions/subid/providers/Microsoft.DocumentDb/locations/westus/restorableDatabaseAccounts/98a570f2-63db-4117-91f0-366327b7b353/restorableSqlContainers/79609a98-3394-41f8-911f-cfab0c075c86"),
		// 			Properties: &armcosmos.RestorableSQLContainerProperties{
		// 				Resource: &armcosmos.RestorableSQLContainerPropertiesResource{
		// 					Rid: to.Ptr("zAyAPQAAAA=="),
		// 					CanUndelete: to.Ptr("invalid"),
		// 					Container: &armcosmos.RestorableSQLContainerPropertiesResourceContainer{
		// 						Etag: to.Ptr("\"00003e00-0000-0700-0000-5f85338a0000\""),
		// 						Rid: to.Ptr("V18LoLrv-qA="),
		// 						ConflictResolutionPolicy: &armcosmos.ConflictResolutionPolicy{
		// 							ConflictResolutionPath: to.Ptr("/_ts"),
		// 							ConflictResolutionProcedure: to.Ptr(""),
		// 							Mode: to.Ptr(armcosmos.ConflictResolutionModeLastWriterWins),
		// 						},
		// 						ID: to.Ptr("Container1"),
		// 						IndexingPolicy: &armcosmos.IndexingPolicy{
		// 							Automatic: to.Ptr(true),
		// 							ExcludedPaths: []*armcosmos.ExcludedPath{
		// 								{
		// 									Path: to.Ptr("/\"_etag\"/?"),
		// 							}},
		// 							IncludedPaths: []*armcosmos.IncludedPath{
		// 								{
		// 									Path: to.Ptr("/*"),
		// 								},
		// 								{
		// 									Path: to.Ptr("/\"_ts\"/?"),
		// 							}},
		// 							IndexingMode: to.Ptr(armcosmos.IndexingModeConsistent),
		// 						},
		// 						Self: to.Ptr("dbs/V18LoA==/colls/V18LoLrv-qA=/"),
		// 					},
		// 					EventTimestamp: to.Ptr("2020-10-13T04:56:42Z"),
		// 					OperationType: to.Ptr(armcosmos.OperationTypeCreate),
		// 					OwnerID: to.Ptr("Container1"),
		// 					OwnerResourceID: to.Ptr("V18LoLrv-qA="),
		// 				},
		// 			},
		// 		},
		// 		{
		// 			Name: to.Ptr("e85298a1-c631-4726-825e-a7ca092e9098"),
		// 			Type: to.Ptr("Microsoft.DocumentDB/locations/restorableDatabaseAccounts/restorableSqlContainers"),
		// 			ID: to.Ptr("/subscriptions/subid/providers/Microsoft.DocumentDb/locations/westus/restorableDatabaseAccounts/98a570f2-63db-4117-91f0-366327b7b353/restorableSqlContainers/e85298a1-c631-4726-825e-a7ca092e9098"),
		// 			Properties: &armcosmos.RestorableSQLContainerProperties{
		// 				Resource: &armcosmos.RestorableSQLContainerPropertiesResource{
		// 					Rid: to.Ptr("PrArcgAAAA=="),
		// 					CanUndelete: to.Ptr("invalid"),
		// 					Container: &armcosmos.RestorableSQLContainerPropertiesResourceContainer{
		// 						Etag: to.Ptr("\"00004400-0000-0700-0000-5f85351f0000\""),
		// 						Rid: to.Ptr("V18LoLrv-qA="),
		// 						ConflictResolutionPolicy: &armcosmos.ConflictResolutionPolicy{
		// 							ConflictResolutionPath: to.Ptr("/_ts"),
		// 							ConflictResolutionProcedure: to.Ptr(""),
		// 							Mode: to.Ptr(armcosmos.ConflictResolutionModeLastWriterWins),
		// 						},
		// 						DefaultTTL: to.Ptr[int32](12345),
		// 						ID: to.Ptr("Container1"),
		// 						IndexingPolicy: &armcosmos.IndexingPolicy{
		// 							Automatic: to.Ptr(true),
		// 							ExcludedPaths: []*armcosmos.ExcludedPath{
		// 								{
		// 									Path: to.Ptr("/\"_etag\"/?"),
		// 							}},
		// 							IncludedPaths: []*armcosmos.IncludedPath{
		// 								{
		// 									Path: to.Ptr("/*"),
		// 								},
		// 								{
		// 									Path: to.Ptr("/\"_ts\"/?"),
		// 							}},
		// 							IndexingMode: to.Ptr(armcosmos.IndexingModeConsistent),
		// 						},
		// 						Self: to.Ptr("dbs/V18LoA==/colls/V18LoLrv-qA=/"),
		// 					},
		// 					EventTimestamp: to.Ptr("2020-10-13T05:03:27Z"),
		// 					OperationType: to.Ptr(armcosmos.OperationTypeReplace),
		// 					OwnerID: to.Ptr("Container1"),
		// 					OwnerResourceID: to.Ptr("V18LoLrv-qA="),
		// 				},
		// 			},
		// 	}},
		// }
	}
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:: 200

{
  "value": [
    {
      "id": "/subscriptions/subid/providers/Microsoft.DocumentDb/locations/westus/restorableDatabaseAccounts/98a570f2-63db-4117-91f0-366327b7b353/restorableSqlContainers/79609a98-3394-41f8-911f-cfab0c075c86",
      "type": "Microsoft.DocumentDB/locations/restorableDatabaseAccounts/restorableSqlContainers",
      "name": "79609a98-3394-41f8-911f-cfab0c075c86",
      "properties": {
        "resource": {
          "_rid": "zAyAPQAAAA==",
          "eventTimestamp": "2020-10-13T04:56:42Z",
          "ownerId": "Container1",
          "ownerResourceId": "V18LoLrv-qA=",
          "operationType": "Create",
          "canUndelete": "invalid",
          "container": {
            "id": "Container1",
            "indexingPolicy": {
              "indexingMode": "consistent",
              "automatic": true,
              "includedPaths": [
                {
                  "path": "/*"
                },
                {
                  "path": "/\"_ts\"/?"
                }
              ],
              "excludedPaths": [
                {
                  "path": "/\"_etag\"/?"
                }
              ]
            },
            "conflictResolutionPolicy": {
              "mode": "LastWriterWins",
              "conflictResolutionPath": "/_ts",
              "conflictResolutionProcedure": ""
            },
            "_rid": "V18LoLrv-qA=",
            "_self": "dbs/V18LoA==/colls/V18LoLrv-qA=/",
            "_etag": "\"00003e00-0000-0700-0000-5f85338a0000\""
          }
        }
      }
    },
    {
      "id": "/subscriptions/subid/providers/Microsoft.DocumentDb/locations/westus/restorableDatabaseAccounts/98a570f2-63db-4117-91f0-366327b7b353/restorableSqlContainers/e85298a1-c631-4726-825e-a7ca092e9098",
      "type": "Microsoft.DocumentDB/locations/restorableDatabaseAccounts/restorableSqlContainers",
      "name": "e85298a1-c631-4726-825e-a7ca092e9098",
      "properties": {
        "resource": {
          "_rid": "PrArcgAAAA==",
          "eventTimestamp": "2020-10-13T05:03:27Z",
          "ownerId": "Container1",
          "ownerResourceId": "V18LoLrv-qA=",
          "operationType": "Replace",
          "canUndelete": "invalid",
          "container": {
            "id": "Container1",
            "indexingPolicy": {
              "indexingMode": "consistent",
              "automatic": true,
              "includedPaths": [
                {
                  "path": "/*"
                },
                {
                  "path": "/\"_ts\"/?"
                }
              ],
              "excludedPaths": [
                {
                  "path": "/\"_etag\"/?"
                }
              ]
            },
            "defaultTtl": 12345,
            "conflictResolutionPolicy": {
              "mode": "LastWriterWins",
              "conflictResolutionPath": "/_ts",
              "conflictResolutionProcedure": ""
            },
            "_rid": "V18LoLrv-qA=",
            "_self": "dbs/V18LoA==/colls/V18LoLrv-qA=/",
            "_etag": "\"00004400-0000-0700-0000-5f85351f0000\""
          }
        }
      }
    }
  ]
}

Definitions

Name	Description
ClientEncryptionIncludedPath	.
ClientEncryptionPolicy	Cosmos DB client encryption policy.
CloudError	An error response from the service.
CompositePath
CompositePathSortOrder	Sort order for composite paths.
ComputedProperty	The definition of a computed property
ConflictResolutionMode	Indicates the conflict resolution mode.
ConflictResolutionPolicy	The conflict resolution policy for the container.
Container	Cosmos DB SQL container resource object
ContainerPartitionKey	The configuration of the partition key to be used for partitioning data into multiple partitions
CreateMode	Enum to indicate the mode of account creation.
DataType	The datatype for which the indexing behavior is applied to.
DistanceFunction	The distance function to use for distance calculation in between vectors.
ErrorResponse	Error Response.
ExcludedPath
IncludedPath	The paths that are included in indexing
Indexes	The indexes for the path.
IndexingMode	Indicates the indexing mode.
IndexingPolicy	Cosmos DB indexing policy
IndexKind	Indicates the type of index.
OperationType	Enum to indicate the operation type of the event.
PartitionKind	Indicates the kind of algorithm used for partitioning. For MultiHash, multiple partition keys (upto three maximum) are supported for container create
Resource	The resource of an Azure Cosmos DB SQL container event
ResourceRestoreParameters	Parameters to indicate the information about the restore.
RestorableSqlContainerGetResult	An Azure Cosmos DB SQL container event
RestorableSqlContainersListResult	The List operation response, that contains the SQL container events and their properties.
SpatialSpec
SpatialType	Indicates the spatial type of index.
UniqueKey	The unique key on that enforces uniqueness constraint on documents in the collection in the Azure Cosmos DB service.
UniqueKeyPolicy	The unique key policy configuration for specifying uniqueness constraints on documents in the collection in the Azure Cosmos DB service.
VectorDataType	Indicates the data type of vector.
VectorEmbedding	Represents a vector embedding. A vector embedding is used to define a vector field in the documents.
VectorEmbeddingPolicy	Cosmos DB Vector Embedding Policy
VectorIndex
VectorIndexType	The index type of the vector. Currently, flat, diskANN, and quantizedFlat are supported.

ClientEncryptionIncludedPath

Name	Type	Description
clientEncryptionKeyId	string	The identifier of the Client Encryption Key to be used to encrypt the path.
encryptionAlgorithm	string	The encryption algorithm which will be used. Eg - AEAD_AES_256_CBC_HMAC_SHA256.
encryptionType	string	The type of encryption to be performed. Eg - Deterministic, Randomized.
path	string	Path that needs to be encrypted.

ClientEncryptionPolicy

Cosmos DB client encryption policy.

Name	Type	Description
includedPaths	ClientEncryptionIncludedPath[]	Paths of the item that need encryption along with path-specific settings.
policyFormatVersion	integer	Version of the client encryption policy definition. Supported versions are 1 and 2. Version 2 supports id and partition key path encryption.

CloudError

An error response from the service.

Name	Type	Description
error	ErrorResponse	Error Response.

CompositePath

Name	Type	Description
order	CompositePathSortOrder	Sort order for composite paths.
path	string	The path for which the indexing behavior applies to. Index paths typically start with root and end with wildcard (/path/*)

CompositePathSortOrder

Sort order for composite paths.

Name	Type	Description
ascending	string
descending	string

ComputedProperty

The definition of a computed property

Name	Type	Description
name	string	The name of a computed property, for example - "cp_lowerName"
query	string	The query that evaluates the value for computed property, for example - "SELECT VALUE LOWER(c.name) FROM c"

ConflictResolutionMode

Indicates the conflict resolution mode.

Name	Type	Description
Custom	string
LastWriterWins	string

ConflictResolutionPolicy

The conflict resolution policy for the container.

Name	Type	Default value	Description
conflictResolutionPath	string		The conflict resolution path in the case of LastWriterWins mode.
conflictResolutionProcedure	string		The procedure to resolve conflicts in the case of custom mode.
mode	ConflictResolutionMode	LastWriterWins	Indicates the conflict resolution mode.

Container

Cosmos DB SQL container resource object

Name	Type	Default value	Description
_etag	string		A system generated property representing the resource etag required for optimistic concurrency control.
_rid	string		A system generated property. A unique identifier.
_self	string		A system generated property that specifies the addressable path of the container resource.
_ts	number		A system generated property that denotes the last updated timestamp of the resource.
analyticalStorageTtl	integer		Analytical TTL.
clientEncryptionPolicy	ClientEncryptionPolicy		The client encryption policy for the container.
computedProperties	ComputedProperty[]		List of computed properties
conflictResolutionPolicy	ConflictResolutionPolicy		The conflict resolution policy for the container.
createMode	CreateMode	Default	Enum to indicate the mode of resource creation.
defaultTtl	integer		Default time to live
id	string		Name of the Cosmos DB SQL container
indexingPolicy	IndexingPolicy		The configuration of the indexing policy. By default, the indexing is automatic for all document paths within the container
partitionKey	ContainerPartitionKey		The configuration of the partition key to be used for partitioning data into multiple partitions
restoreParameters	ResourceRestoreParameters		Parameters to indicate the information about the restore
uniqueKeyPolicy	UniqueKeyPolicy		The unique key policy configuration for specifying uniqueness constraints on documents in the collection in the Azure Cosmos DB service.
vectorEmbeddingPolicy	VectorEmbeddingPolicy		The vector embedding policy for the container.

ContainerPartitionKey

The configuration of the partition key to be used for partitioning data into multiple partitions

Name	Type	Default value	Description
kind	PartitionKind	Hash	Indicates the kind of algorithm used for partitioning. For MultiHash, multiple partition keys (upto three maximum) are supported for container create
paths	string[]		List of paths using which data within the container can be partitioned
systemKey	boolean		Indicates if the container is using a system generated partition key
version	integer		Indicates the version of the partition key definition

CreateMode

Enum to indicate the mode of account creation.

Name	Type	Description
Default	string
Restore	string

DataType

The datatype for which the indexing behavior is applied to.

Name	Type	Description
LineString	string
MultiPolygon	string
Number	string
Point	string
Polygon	string
String	string

DistanceFunction

The distance function to use for distance calculation in between vectors.

Name	Type	Description
cosine	string
dotproduct	string
euclidean	string

ErrorResponse

Error Response.

Name	Type	Description
code	string	Error code.
message	string	Error message indicating why the operation failed.

ExcludedPath

Name	Type	Description
path	string	The path for which the indexing behavior applies to. Index paths typically start with root and end with wildcard (/path/*)

IncludedPath

The paths that are included in indexing

Name	Type	Description
indexes	Indexes[]	List of indexes for this path
path	string	The path for which the indexing behavior applies to. Index paths typically start with root and end with wildcard (/path/*)

Indexes

The indexes for the path.

Name	Type	Default value	Description
dataType	DataType	String	The datatype for which the indexing behavior is applied to.
kind	IndexKind	Hash	Indicates the type of index.
precision	integer		The precision of the index. -1 is maximum precision.

IndexingMode

Indicates the indexing mode.

Name	Type	Description
consistent	string
lazy	string
none	string

IndexingPolicy

Cosmos DB indexing policy

Name	Type	Default value	Description
automatic	boolean		Indicates if the indexing policy is automatic
compositeIndexes	CompositePath[]		List of composite path list
excludedPaths	ExcludedPath[]		List of paths to exclude from indexing
includedPaths	IncludedPath[]		List of paths to include in the indexing
indexingMode	IndexingMode	consistent	Indicates the indexing mode.
spatialIndexes	SpatialSpec[]		List of spatial specifics
vectorIndexes	VectorIndex[]		List of paths to include in the vector indexing

IndexKind

Indicates the type of index.

Name	Type	Description
Hash	string
Range	string
Spatial	string

OperationType

Enum to indicate the operation type of the event.

Name	Type	Description
Create	string
Delete	string
Recreate	string
Replace	string
SystemOperation	string

PartitionKind

Indicates the kind of algorithm used for partitioning. For MultiHash, multiple partition keys (upto three maximum) are supported for container create

Name	Type	Description
Hash	string
MultiHash	string
Range	string

Resource

The resource of an Azure Cosmos DB SQL container event

Name	Type	Description
_rid	string	A system generated property. A unique identifier.
canUndelete	string	A state of this container to identify if this container is restorable in same account.
canUndeleteReason	string	The reason why this container can not be restored in same account.
container	Container	Cosmos DB SQL container resource object
eventTimestamp	string	The when this container event happened.
operationType	OperationType	The operation type of this container event.
ownerId	string	The name of this SQL container.
ownerResourceId	string	The resource ID of this SQL container.

ResourceRestoreParameters

Parameters to indicate the information about the restore.

Name	Type	Description
restoreSource	string	The id of the restorable database account from which the restore has to be initiated. For example: /subscriptions/{subscriptionId}/providers/Microsoft.DocumentDB/locations/{location}/restorableDatabaseAccounts/{restorableDatabaseAccountName}
restoreTimestampInUtc	string	Time to which the account has to be restored (ISO-8601 format).
restoreWithTtlDisabled	boolean	Specifies whether the restored account will have Time-To-Live disabled upon the successful restore.

RestorableSqlContainerGetResult

An Azure Cosmos DB SQL container event

Name	Type	Description
id	string	The unique resource Identifier of the ARM resource.
name	string	The name of the ARM resource.
properties.resource	Resource	The resource of an Azure Cosmos DB SQL container event
type	string	The type of Azure resource.