az cosmosdb sql

Note

This command group has commands that are defined in both Azure CLI and at least one extension. Install each extension to benefit from its extended capabilities. Learn more about extensions.

Manage SQL resources of Azure Cosmos DB account.

Commands

Name Description Type Status
az cosmosdb sql container

Manage Azure Cosmos DB SQL containers.

Core and Extension GA
az cosmosdb sql container create

Create an SQL container under an Azure Cosmos DB SQL database.

Core GA
az cosmosdb sql container create (cosmosdb-preview extension)

Create an SQL container under an Azure Cosmos DB SQL database.

Extension GA
az cosmosdb sql container delete

Delete the SQL container under an Azure Cosmos DB SQL database.

Core GA
az cosmosdb sql container exists

Checks if an Azure Cosmos DB SQL container exists.

Core GA
az cosmosdb sql container list

List the SQL containers under an Azure Cosmos DB SQL database.

Core GA
az cosmosdb sql container merge

Merges the partitions of a sql container.

Extension Preview
az cosmosdb sql container redistribute-partition-throughput

Redistributes the partition throughput of a sql container.

Extension Preview
az cosmosdb sql container restore

Restore a deleted sql container within the same account.

Core GA
az cosmosdb sql container restore (cosmosdb-preview extension)

Restore a deleted sql container within the same account.

Extension Preview
az cosmosdb sql container retrieve-partition-throughput

Retrieve the partition throughput of a sql container.

Extension Preview
az cosmosdb sql container show

Show the details of a SQL container under an Azure Cosmos DB SQL database.

Core GA
az cosmosdb sql container throughput

Manage throughput of SQL container under an Azure Cosmos DB account.

Core GA
az cosmosdb sql container throughput migrate

Migrate the throughput of the SQL container between autoscale and manually provisioned.

Core GA
az cosmosdb sql container throughput show

Get the throughput of the SQL container under an Azure Cosmos DB SQL database.

Core GA
az cosmosdb sql container throughput update

Update the throughput of the SQL container under an Azure Cosmos DB SQL database.

Core GA
az cosmosdb sql container update

Update an SQL container under an Azure Cosmos DB SQL database.

Core GA
az cosmosdb sql container update (cosmosdb-preview extension)

Update an SQL container under an Azure Cosmos DB SQL database.

Extension GA
az cosmosdb sql database

Manage Azure Cosmos DB SQL databases.

Core and Extension GA
az cosmosdb sql database create

Create an SQL database under an Azure Cosmos DB account.

Core GA
az cosmosdb sql database delete

Delete the SQL database under an Azure Cosmos DB account.

Core GA
az cosmosdb sql database exists

Checks if an Azure Cosmos DB SQL database exists.

Core GA
az cosmosdb sql database list

List the SQL databases under an Azure Cosmos DB account.

Core GA
az cosmosdb sql database merge

Merge the partitions of a sql database.

Extension Preview
az cosmosdb sql database restore

Restore a deleted sql database within the same account.

Core GA
az cosmosdb sql database restore (cosmosdb-preview extension)

Restore a deleted sql database within the same account.

Extension Preview
az cosmosdb sql database show

Show the details of a SQL database under an Azure Cosmos DB account.

Core GA
az cosmosdb sql database throughput

Manage throughput of SQL database under an Azure Cosmos DB account.

Core GA
az cosmosdb sql database throughput migrate

Migrate the throughput of the SQL database between autoscale and manually provisioned.

Core GA
az cosmosdb sql database throughput show

Get the throughput of the SQL database under an Azure Cosmos DB account.

Core GA
az cosmosdb sql database throughput update

Update the throughput of the SQL database under an Azure Cosmos DB account.

Core GA
az cosmosdb sql restorable-container

Manage different versions of sql containers that are restorable in a database of a Azure Cosmos DB account.

Core and Extension GA
az cosmosdb sql restorable-container list

List all the versions of all the sql containers that were created / modified / deleted in the given database and restorable account.

Core GA
az cosmosdb sql restorable-container list (cosmosdb-preview extension)

List all the versions of all the sql containers that were created / modified / deleted in the given database and restorable account.

Extension Preview
az cosmosdb sql restorable-database

Manage different versions of sql databases that are restorable in a Azure Cosmos DB account.

Core GA
az cosmosdb sql restorable-database list

List all the versions of all the sql databases that were created / modified / deleted in the given restorable account.

Core GA
az cosmosdb sql restorable-resource

Manage the databases and its containers that can be restored in the given account at the given timesamp and region.

Core GA
az cosmosdb sql restorable-resource list

List all the databases and its containers that can be restored in the given account at the given timesamp and region.

Core GA
az cosmosdb sql retrieve-latest-backup-time

Retrieves latest restorable timestamp for the given sql container in given region.

Core GA
az cosmosdb sql role

Manage Azure Cosmos DB SQL role resources.

Core GA
az cosmosdb sql role assignment

Manage Azure Cosmos DB SQL role assignments.

Core GA
az cosmosdb sql role assignment create

Create a SQL role assignment under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role assignment delete

Delete a SQL role assignment under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role assignment exists

Check if an Azure Cosmos DB role assignment exists.

Core GA
az cosmosdb sql role assignment list

List all SQL role assignments under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role assignment show

Show the properties of a SQL role assignment under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role assignment update

Update a SQL role assignment under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role assignment wait

Poll on a SQL role assignment until a specific condition is met.

Core GA
az cosmosdb sql role definition

Manage Azure Cosmos DB SQL role definitions.

Core GA
az cosmosdb sql role definition create

Create a SQL role definition under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role definition delete

Delete a SQL role definition under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role definition exists

Check if an Azure Cosmos DB role definition exists.

Core GA
az cosmosdb sql role definition list

List all SQL role definitions under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role definition show

Show the properties of a SQL role definition under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role definition update

Update a SQL role definition under an Azure Cosmos DB account.

Core GA
az cosmosdb sql role definition wait

Poll on a SQL role definition until a specific condition is met.

Core GA
az cosmosdb sql stored-procedure

Manage Azure Cosmos DB SQL stored procedures.

Core GA
az cosmosdb sql stored-procedure create

Create an SQL stored procedure under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql stored-procedure delete

Delete the SQL stored procedure under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql stored-procedure list

List the SQL stored procedures under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql stored-procedure show

Show the details of a SQL stored procedure under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql stored-procedure update

Creates or Updates an Azure Cosmos DB SQL stored procedure.

Core GA
az cosmosdb sql trigger

Manage Azure Cosmos DB SQL triggers.

Core GA
az cosmosdb sql trigger create

Create an SQL trigger under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql trigger delete

Delete the SQL trigger under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql trigger list

List the SQL triggers under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql trigger show

Show the details of a SQL trigger under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql trigger update

Updates an Azure Cosmos DB SQL trigger.

Core GA
az cosmosdb sql user-defined-function

Manage Azure Cosmos DB SQL user defined functions.

Core GA
az cosmosdb sql user-defined-function create

Create an SQL user defined function under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql user-defined-function delete

Delete the SQL user defined function under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql user-defined-function list

List the SQL user defined functions under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql user-defined-function show

Show the details of a SQL user defined function under an Azure Cosmos DB SQL container.

Core GA
az cosmosdb sql user-defined-function update

Creates or Updates an Azure Cosmos DB SQL user defined function.

Core GA

az cosmosdb sql retrieve-latest-backup-time

Retrieves latest restorable timestamp for the given sql container in given region.

az cosmosdb sql retrieve-latest-backup-time --account-name
                                            --container-name
                                            --database-name
                                            --location
                                            --resource-group

Required Parameters

--account-name -a

Name of the CosmosDB database account.

--container-name -c

Name of the CosmosDB Sql container name.

--database-name -d

Name of the CosmosDB Sql database name.

--location -l

Location of the account.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.