Use Azure CLI to create an Azure Cosmos DB for Table account and table with autoscale

APPLIES TO: Table

The script in this article creates an Azure Cosmos DB for Table account and table with autoscale.

• If you don't have an Azure trail subscription, create a trial subscription before you begin.

• This script requires Azure CLI version 2.12.1 or later.

  Note

  Before you can use Azure CLI in Microsoft Azure operated by 21Vianet, please run az cloud set -n AzureChinaCloud first to change the cloud environment. If you want to switch back to Azure Public Cloud, run az cloud set -n AzureCloud again.

  You can use az account set to sign in with a different subscription, replacing <subscriptionId> with your Azure subscription ID.

  subscription="<subscriptionId>" # add subscription here
  
  az account set -s $subscription # ...or use 'az login'
  

  • If you prefer, you can install Azure CLI to run the script locally. Run az version to find the Azure CLI version and dependent libraries that are installed, and run az upgrade if you need to upgrade. If prompted, install Azure CLI extensions. If you're running Windows or macOS, consider running Azure CLI in a Docker container.

    If you're using a local installation, sign in to Azure by running az login and following the prompts. For other sign-in options, see Sign in with the Azure CLI.

Run the following script to create an Azure resource group, an Azure Cosmos DB for Table account, and API for Table table with autoscale capability. The resources might take a while to create.

# Create a Table API table with autoscale

# Variable block
let "randomIdentifier=$RANDOM*$RANDOM"
location="chinaeast2"
resourceGroup="msdocs-cosmosdb-rg-$randomIdentifier"
tag="autoscale-table-cosmosdb"
account="msdocs-account-cosmos-$randomIdentifier" #needs to be lower case
table="msdocs-table-cosmos-$randomIdentifier"
maxThroughput=1000 #minimum = 1000

# Create a resource group
echo "Creating $resourceGroup in $location..."
az group create --name $resourceGroup --location "$location" --tags $tag

# Create a Cosmos account for Table API
echo "Creating $account"
az cosmosdb create --name $account --resource-group $resourceGroup --capabilities EnableTable --default-consistency-level Eventual --locations regionName="$location" failoverPriority=0 isZoneRedundant=False

# Create a Table API Table with autoscale
echo "Create $table with $maxThroughput"
az cosmosdb table create --account-name $account --resource-group $resourceGroup --name $table --max-throughput $maxThroughput
# </FullScript>

# echo "Deleting all resources"
# az group delete --name $resourceGroup -y

This script uses the following commands:

• az group create creates a resource group to store all resources.
• az cosmosdb create with --capabilities EnableTable creates an Azure Cosmos DB account for API for Table.
• az cosmosdb table create with --max-throughput 1000 creates an Azure Cosmos DB for Table table with autoscale capabilities.

If you no longer need the resources you created, use the az group delete command to delete the resource group and all resources it contains. These resources include the Azure Cosmos DB account and table. The resources might take a while to delete.

az group delete --name $resourceGroup

• Azure Cosmos DB CLI documentation
• Throughput (RU/s) operations with Azure CLI for a table for Azure Cosmos DB for Table