Azure Table Storage

Azure Table Storage is a fully managed NoSQL database service that provides a highly scalable and cost-effective way to store structured data. It’s designed for simple data models and offers high availability and security.

Key Concepts

Here's a breakdown of the fundamental concepts:

• Tables: Containers that hold your data. You can have multiple tables in your Azure subscription.
• Rows: Represent individual records within a table. Each row has a unique identifier.
• Columns: Represent the attributes of each row. You can define columns with various data types, such as string, int, boolean, and geo.
• Partitions: A table can be divided into partitions, which are used to distribute data across multiple servers for increased scalability and performance.

Creating a Table

To create a table, you can use the Azure Portal, Azure CLI, or PowerShell.

Here's an example of creating a table using the Azure CLI:

az table create --name myTable --resource-group myResourceGroup

Working with Rows

Once you have a table, you can add rows and update them as needed.

You can use the Azure Portal, Azure CLI, or PowerShell to manage rows.

Example PowerShell script to add a row:

# Requires the Az PowerShell module
# Install: Install-Module -Name Az -AllowUnsafeInstall -Force
# Connect: Connect-AzAccount
# Import the Table module
Import-Module Az.DataLake.Table

# Create a new TableRow object
$row = New-AzTableRow -PartitionId "00000000-0000-0000-0000-000000000000" -Name "firstName" -Value "John"
$row | New-AzTableRowOperation

$row = New-AzTableRow -PartitionId "00000000-0000-0000-0000-000000000000" -Name "lastName" -Value "Doe"
$row | New-AzTableRowOperation