| title | description | author | ms.service | ms.subservice | ms.topic | ms.date | ms.author |
|---|---|---|---|---|---|---|---|
Introduction to the Azure Cosmos DB Table API |
Learn how you can use Azure Cosmos DB to store and query massive volumes of key-value data with low latency by using the Azure Tables API. |
SnehaGunda |
cosmos-db |
cosmosdb-table |
overview |
11/25/2020 |
sngun |
[!INCLUDEappliesto-table-api]
Azure Cosmos DB provides the Table API for applications that are written for Azure Table storage and that need premium capabilities like:
- Turnkey global distribution.
- Dedicated throughput worldwide.
- Single-digit millisecond latencies at the 99th percentile.
- Guaranteed high availability.
- Automatic secondary indexing.
Applications written for Azure Table storage can migrate to Azure Cosmos DB by using the Table API with no code changes and take advantage of premium capabilities. The Table API has client SDKs available for .NET, Java, Python, and Node.js.
Note
The serverless capacity mode is now available on Azure Cosmos DB's Table API.
Important
The .NET Framework SDK Microsoft.Azure.CosmosDB.Table is in maintenance mode and it will be deprecated soon. Please upgrade to the new .NET Standard library Microsoft.Azure.Cosmos.Table to continue to get the latest features supported by the Table API.
If you currently use Azure Table Storage, you gain the following benefits by moving to the Azure Cosmos DB Table API:
| Feature | Azure Table storage | Azure Cosmos DB Table API |
|---|---|---|
| Latency | Fast, but no upper bounds on latency. | Single-digit millisecond latency for reads and writes, backed with <10 ms latency for reads and writes at the 99th percentile, at any scale, anywhere in the world. |
| Throughput | Variable throughput model. Tables have a scalability limit of 20,000 operations/s. | Highly scalable with dedicated reserved throughput per table that's backed by SLAs. Accounts have no upper limit on throughput and support >10 million operations/s per table. |
| Global distribution | Single region with one optional readable secondary read region for high availability. | Turnkey global distribution from one to any number of regions. Support for automatic and manual failovers at any time, anywhere in the world. Multiple write regions to let any region accept write operations. |
| Indexing | Only primary index on PartitionKey and RowKey. No secondary indexes. | Automatic and complete indexing on all properties by default, with no index management. |
| Query | Query execution uses index for primary key, and scans otherwise. | Queries can take advantage of automatic indexing on properties for fast query times. |
| Consistency | Strong within primary region. Eventual within secondary region. | Five well-defined consistency levels to trade off availability, latency, throughput, and consistency based on your application needs. |
| Pricing | Storage-optimized. | Throughput-optimized. |
| SLAs | 99.9% to 99.99% availability, depending on the replication strategy. | 99.999% read availability, 99.99% write availability on a single-region account and 99.999% write availability on multi-region accounts. Comprehensive SLAs covering availability, latency, throughput and consistency. |
Create an Azure Cosmos DB account in the Azure portal. Then get started with our Quick Start for Table API by using .NET.
Important
If you created a Table API account during the preview, please create a new Table API account to work with the generally available Table API SDKs.
Here are a few pointers to get you started:
- Build a .NET application by using the Table API
- Develop with the Table API in .NET
- Query table data by using the Table API
- Learn how to set up Azure Cosmos DB global distribution by using the Table API
- Azure Cosmos DB Table .NET Standard SDK
- Azure Cosmos DB Table .NET SDK
- Azure Cosmos DB Table Java SDK
- Azure Cosmos DB Table Node.js SDK
- Azure Cosmos DB Table SDK for Python