Azure / Azure/azure-cli

Az storage entity query unable to fetch all entries from table

Open
#14,075 6 comments 0 reactions 1 assignee Claimed by @Juliehzl View on GitHub
act-codegen-extensibility-squad CosmosDB Table customer-reported feature-request Service Attention Storage
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

**Description**
I am trying to use Az storage entity query to get entries from a cosmos db table. (following https://docs.microsoft.com/en-us/cli/azure/storage/entity?view=azure-cli-latest#az-storage-entity-query)

The table has about 100 entries, but even after removing all filters, it is able to fetch only ~30 of them.
This is how we are getting the rows -
$tb = (az storage entity query --table-name $TableName --connection-string ) | ConvertFrom-Json

For individual entries, we have observed this
```
{
"items": [
{
"Consortium": "xxxxxx",
"CreatedTime": "2019-09-06T09:34:07.551260+00:00",
"RowKey": "yyyyyy",
"PartitionKey": "zzzzzz-zzzzz-zz-zzzzz-zz",
"Tags": "{}",
"Timestamp": "2019-09-06T09:41:34.660306+00:00",
"etag": "W/\"datetime'2019-09-06T09%3A41%3A34.6603060Z'\""
}
],
"nextMarker": {}
}
```
When the filter is `Rowkey -eq 'yyyyyy'` above entry is not fetched, but it appears with filter `PartitionKey -eq 'zzzzzz-zzzzz-zz-zzzzz-zz'`

This is one of the entries that does not come when entire table is fetched.

**Expected behavior**
All entries should be fetched as it is possible to fetch <= 1000 entries in single run, without need of markers.

**Environment summary**
Install Method MSI
CLI version 2.2.0
Windows 10
powershell 7

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.