Azure Data Tables is a NoSQL data storage service that can be accessed from anywhere in the world via authenticated calls using HTTP or HTTPS. Tables scales as needed to support the amount of data inserted, and allows for the storing of data with non-complex accessing. The Azure Tables client can be used to access Azure Storage or Cosmos accounts.

Source code | API reference documentation

Getting started

The Azure Tables SDK can access an Azure Storage or CosmosDB account.

Prerequisites

You must have an Azure subscription and either
- an Azure Storage account or
- an Azure Cosmos Account.

Create account

To create a new Storage account, you can use Azure Portal, Azure PowerShell, or Azure CLI:
To create a new Cosmos storage account, you can use the Azure CLI or Azure Portal.

Create the client

The Azure Tables library allows you to interact with two types of resources:

the tables in your account
the entities within those tables. Interaction with these resources starts with an instance of a client. To create a client object, you will need the account's table service endpoint URL and a credential that allows you to access the account. The endpoint can be found on the page for your storage account in the [Azure Portal][azure_portal_account_url] under the "Access Keys" section or by running the following Azure CLI command:

# Log in to Azure CLI first, this opens a browser window
az login
# Get the table service URL for the account
az storage account show -n mystorageaccount -g MyResourceGroup --query "primaryEndpoints.table"

Key concepts

Common uses of the table service include:

Storing TBs of structured data capable of serving web scale applications
Storing datasets that do not require complex joins, foreign keys, or stored procedures and can be de-normalized for fast access
Quickly querying data using a clustered index
Accessing data using the OData protocol filter expressions

The following components make up the Azure Tables Service:

The account
A table within the account, which contains a set of entities
An entity within a table, as a dictionary

The Azure Tables client library for C++ allows you to interact with each of these components through the use of a dedicated client object.

Clients

Two different clients are provided to interact with the various components of the Table Service:

**TableClient** -
- Interacts with a specific table (which need not exist yet).
- Create, delete, query, and upsert entities within the specified table.
- Create or delete the specified table itself.
**TableServiceClient** -
- Get and set account settings
- Query tables within the account.

Entities

Entities are similar to rows. An entity has a **PartitionKey**, a **RowKey**, and a set of properties. A property is a name value pair, similar to a column. Every entity in a table does not need to have the same properties.

Examples

The following sections provide several code snippets covering some of the most common Table tasks, including:

Creating and deleting a table

In order to Create/Delete a table we need to create a TablesClient first.

#include <azure/data/tables.hpp>
...
using namespace Azure::Data::Tables;
const std::string TableName = "sample1";
...
auto tableClient = TableClient::CreateFromConnectionString(..., TableName);
tableClient.Create();

In order to Delete a table we need to call the delete method on the previously created client.

tableClient.Delete();

Manipulating entities

In order to Create/Update/Merge/Delete entities we need to create a TablesClient first.

#include <azure/data/tables.hpp>
...
using namespace Azure::Data::Tables;
const std::string TableName = "sample1";
...
auto tableClient = TableClient::CreateFromConnectionString(..., TableName);
tableClient.Create();

Then we initialize and populate an entity.

// init new entity
 Models::TableEntity entity;
 entity.PartitionKey = "P1";
 entity.RowKey = "R1";
 entity.Properties["Name"] = "Azure";
 entity.Properties["Product"] = "Tables";

To create the entity on the server we call the CreateEntity method on the table client.

tableClient.CreateEntity(entity);

To update the entity, assume we made some changes to the entity, we call the UpdateEntity method on the table client.

tableClient.UpdateEntity(entity);

To merge the entity, assume we made some changes to the entity, we call the MergeEntity method on the table client.

tableClient.MergeEntity(entity);

To delete the entity, we call the DeleteEntity method on the table client.

tableClient.DeleteEntity(entity);

Table Service Operations

In order to get the service properties we need to create a TableServiceClient first.

#include <azure/data/tables.hpp>
...
using namespace Azure::Data::Tables;
...
auto tableServiceClient = TableServiceClient::CreateFromConnectionString(...);

To get the service properties we call the GetProperties method on the table service client.

auto properties = tableServiceClient.GetProperties();

To list the tables in the account we call the ListTables method on the table service client.

auto tables = tableServiceClient.ListTables();

To get the statistics of the account we call the GetStatistics method on the table service client.

auto statistics = tableServiceClient.GetStatistics();

Contributing

See the C++ Contributing Guide for details on building, testing, and contributing to these libraries.

See the Storage Testing Guide for how to set up storage resources running unit tests.

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit cla.microsoft.com.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.