Microsoft.DocumentDB databaseAccounts/sqlDatabases/containers/storedProcedures 2019-08-01

The databaseAccounts/sqlDatabases/containers/storedProcedures resource type can be deployed to: Resource groups.

To learn about resource group deployments, see Bicep or ARM template.

Template format

To create a Microsoft.DocumentDB/databaseAccounts/sqlDatabases/containers/storedProcedures resource, add the following Bicep or JSON to your template.

resource symbolicname 'Microsoft.DocumentDB/databaseAccounts/sqlDatabases/containers/storedProcedures@2019-08-01' = {
  name: 'string'
  location: 'string'
  tags: {
    tagName1: 'tagValue1'
    tagName2: 'tagValue2'
  }
  parent: parentSymbolicName
  properties: {
    options: {}
    resource: {
      body: 'string'
      id: 'string'
    }
  }
}

Property values

databaseAccounts/sqlDatabases/containers/storedProcedures

Name Description Value
type The resource type

For Bicep, set this value in the resource declaration.
'Microsoft.DocumentDB/databaseAccounts/sqlDatabases/containers/storedProcedures'
apiVersion The resource api version

For Bicep, set this value in the resource declaration.
'2019-08-01'
name The resource name

See how to set names and types for child resources in Bicep or JSON ARM templates.
string (required)
location The location of the resource group to which the resource belongs. string
tags Tags are a list of key-value pairs that describe the resource. These tags can be used in viewing and grouping this resource (across resource groups). A maximum of 15 tags can be provided for a resource. Each tag must have a key no greater than 128 characters and value no greater than 256 characters. For example, the default experience for a template type is set with "defaultExperience": "Cassandra". Current "defaultExperience" values also include "Table", "Graph", "DocumentDB", and "MongoDB". Dictionary of tag names and values. See Tags in templates
parent In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource.

For more information, see Child resource outside parent resource.
parentSymbolicName
properties Properties to create and update Azure Cosmos DB storedProcedure. SqlStoredProcedureCreateUpdateProperties (required)

SqlStoredProcedureCreateUpdateProperties

Name Description Value
options CreateUpdateOptions are a list of key-value pairs that describe the resource. Supported keys are "If-Match", "If-None-Match", "Session-Token" and "Throughput" object (required)
resource Cosmos DB SQL storedProcedure resource object SqlStoredProcedureResource (required)

SqlStoredProcedureResource

Name Description Value
body Body of the Stored Procedure string
id Name of the Cosmos DB SQL storedProcedure string (required)

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
Create Azure Cosmos Core (SQL) API stored procedures

Deploy to Azure
This template creates an Azure Cosmos account for Core (SQL) API and a container with a stored procedure, trigger and user defined function.