az cosmosdb sql stored-procedure
Manage Azure Cosmos DB SQL stored procedures.
Commands
az cosmosdb sql stored-procedure create |
Create an SQL stored procedure under an Azure Cosmos DB SQL container. |
az cosmosdb sql stored-procedure delete |
Delete the SQL stored procedure under an Azure Cosmos DB SQL container. |
az cosmosdb sql stored-procedure list |
List the SQL stored procedures under an Azure Cosmos DB SQL container. |
az cosmosdb sql stored-procedure show |
Show the details of a SQL stored procedure under an Azure Cosmos DB SQL container. |
az cosmosdb sql stored-procedure update |
Creates or Updates an Azure Cosmos DB SQL stored procedure. |
az cosmosdb sql stored-procedure create
Create an SQL stored procedure under an Azure Cosmos DB SQL container.
az cosmosdb sql stored-procedure create --account-name
--body
--container-name
--database-name
--name
--resource-group
[--subscription]
Examples
Create an Azure Cosmos DB SQL stored procedure.
az cosmosdb sql stored-procedure create -g MyResourceGroup -a MyAccount -d MyDatabase -c MyContainer -n MyStoredProcedure -b StoredProcedureBody
Required Parameters
Cosmosdb account name.
StoredProcedure body, you can enter it as a string or as a file, e.g., --body @sprocbody-file.json.
Container name.
Database name.
StoredProcedure name.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Optional Parameters
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
az cosmosdb sql stored-procedure delete
Delete the SQL stored procedure under an Azure Cosmos DB SQL container.
az cosmosdb sql stored-procedure delete --account-name
--container-name
--database-name
--name
--resource-group
[--subscription]
[--yes]
Required Parameters
Cosmosdb account name.
Container name.
Database name.
StoredProcedure name.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Optional Parameters
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Do not prompt for confirmation.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
az cosmosdb sql stored-procedure list
List the SQL stored procedures under an Azure Cosmos DB SQL container.
az cosmosdb sql stored-procedure list --account-name
--container-name
--database-name
--resource-group
[--query-examples]
[--subscription]
Required Parameters
Cosmosdb account name.
Container name.
Database name.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Optional Parameters
Recommend JMESPath string for you. You can copy one of the query and paste it after --query parameter within double quotation marks to see the results. You can add one or more positional keywords so that we can give suggestions based on these key words.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
az cosmosdb sql stored-procedure show
Show the details of a SQL stored procedure under an Azure Cosmos DB SQL container.
az cosmosdb sql stored-procedure show --account-name
--container-name
--database-name
--name
--resource-group
[--query-examples]
[--subscription]
Required Parameters
Cosmosdb account name.
Container name.
Database name.
StoredProcedure name.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Optional Parameters
Recommend JMESPath string for you. You can copy one of the query and paste it after --query parameter within double quotation marks to see the results. You can add one or more positional keywords so that we can give suggestions based on these key words.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
az cosmosdb sql stored-procedure update
Creates or Updates an Azure Cosmos DB SQL stored procedure.
az cosmosdb sql stored-procedure update --account-name
--body
--container-name
--database-name
--name
--resource-group
[--subscription]
Required Parameters
Cosmosdb account name.
StoredProcedure body, you can enter it as a string or as a file, e.g., --body @sprocbody-file.json.
Container name.
Database name.
StoredProcedure name.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Optional Parameters
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.