Get total no of record in Azure table storage using az or powershell command

Question

Hi Team,

I want to get total no of record in Azure table storage using az or powershell command or through table storage api Please let me know if it's possible.

Actually we need to run this command/api on daily basis to get a count and generate report.

Thanks in advance.

Best Regards,
Jignesh

Answer 1

@Jignesh Vala Welcome to Microsoft Q&A forums.

Unfortunately, there is no way to return the count of records in Azure Tables.
You will need to fetch the records by partition and count them on the client side.

We will take your feedback and add it to our feature backlog. The product team will prioritize it for a future release.

----------

If an answer is helpful, please click on or upvote which might help other community members reading this thread.

Answer 2

I used this script for getting total number of records from Azure storage table:

function GetTable($connectionString, $tableName)
{
    $context = New-AzStorageContext -ConnectionString $connectionString
    $azureStorageTable = Get-AzStorageTable $tableName -Context $context
    $azureStorageTable.CloudTable
}

function GetTableCount($table)
{
 (Get-AzTableRow -table $table | measure).Count    
}

$connectionString = "..."
$table = GetTable $connectionString "MyTableName"
GetTableCount $table

Answer 3

I tried this script but this takes forever on a table with a big row count