Table Storage

Azure Table Storage (api-version 2019-02-02) over the OData JSON wire format, served at https://127.0.0.1:10002/devstoreaccount1 and compatible with the aztables SDK and the az storage table / az storage entity commands. Table state is persisted under /data. See Configuration to change ports, addresses, and the data directory.

localaz serves every HTTP API over TLS. Trust the self-signed certificate it writes to <data>/tls/localaz.crt (./localaz-data/tls/localaz.crt with the Docker volume from Get Started); the examples below show how.

Supported operations

OperationREST surface
Query / Create / Delete TableGET / POST /{account}/Tables, DELETE /{account}/Tables('{name}')
Insert EntityPOST /{account}/{table}
Query EntitiesGET /{account}/{table}()
Get EntityGET /{account}/{table}(PartitionKey='{pk}',RowKey='{rk}')
Update (replace)PUT /{account}/{table}(...)
MergePATCH / MERGE /{account}/{table}(...)
Delete EntityDELETE /{account}/{table}(...)

Server-managed Timestamp and weak odata.etag, optimistic concurrency via If-Match, upsert, and the $filter (eq ne gt ge lt le, and/or, parentheses), $select, and $top query options are supported.

Not implemented: batch transactions, typed $filter literals and OData functions, continuation tokens, and Shared Key signature verification.

Azure CLI

Trust localaz’s certificate:

export SSL_CERT_FILE=./localaz-data/tls/localaz.crt
export REQUESTS_CA_BUNDLE="$SSL_CERT_FILE"

Generate a random storage key:

export AZURE_STORAGE_KEY="$(openssl rand -base64 64 | tr -d '\n')"

Configure the connection string and run the CLI:

export AZURE_STORAGE_CONNECTION_STRING="DefaultEndpointsProtocol=https;AccountName=devstoreaccount1;AccountKey=${AZURE_STORAGE_KEY};TableEndpoint=https://127.0.0.1:10002/devstoreaccount1;"

az storage table create --name people
az storage entity insert --table-name people --entity PartitionKey=team RowKey=alice Name=Alice
az storage entity show --table-name people --partition-key team --row-key alice
az storage entity query --table-name people --filter "PartitionKey eq 'team'"
az storage entity delete --table-name people --partition-key team --row-key alice

Go SDK

Trust localaz’s certificate:

export SSL_CERT_FILE=./localaz-data/tls/localaz.crt

Generate a random storage key:

export AZURE_STORAGE_KEY="$(openssl rand -base64 64 | tr -d '\n')"

package main

import (
	"context"
	"encoding/json"
	"fmt"
	"os"

	"github.com/Azure/azure-sdk-for-go/sdk/azcore/to"
	"github.com/Azure/azure-sdk-for-go/sdk/data/aztables"
)

func main() {
	ctx := context.Background()
	connStr := "DefaultEndpointsProtocol=https;AccountName=devstoreaccount1;" +
		"AccountKey=" + os.Getenv("AZURE_STORAGE_KEY") + ";" +
		"TableEndpoint=https://127.0.0.1:10002/devstoreaccount1;"
	svc, err := aztables.NewServiceClientFromConnectionString(connStr, nil)
	if err != nil {
		panic(err)
	}

	svc.CreateTable(ctx, "people", nil)
	table := svc.NewClient("people")

	entity, _ := json.Marshal(aztables.EDMEntity{
		Entity:     aztables.Entity{PartitionKey: "team", RowKey: "alice"},
		Properties: map[string]any{"Name": "Alice", "Count": 3},
	})
	table.AddEntity(ctx, entity, nil)

	resp, err := table.GetEntity(ctx, "team", "alice", nil)
	if err != nil {
		panic(err)
	}
	fmt.Println(string(resp.Value))

	pager := table.NewListEntitiesPager(&aztables.ListEntitiesOptions{
		Filter: to.Ptr("PartitionKey eq 'team'"),
	})
	for pager.More() {
		page, _ := pager.NextPage(ctx)
		fmt.Println(len(page.Entities))
	}

	table.DeleteEntity(ctx, "team", "alice", nil)
}