How to save huge byte array into azure table storage?

Question

I have tableEntity that contains byte[] property

[StorageTableName("TestTable")]
public class TestTableEntity : TableEntity
{
    public byte[] Data { get; set; }
}

In this property I want to put some file converted into bytes (if it is incorrect - please suggest another solution).

var table = tableStorage.Table<TestTableEntity>();
await table.CreateIfNotExistsAsync();

var entity = new TestTableEntity 
{
    Data = data, //byte[]
    PartitionKey = partitionKey, //date
    RowKey = schemaName// string
};

await table.InsertOrUpdateAsync(entity);

At step of insert I get error

The remote server returned an error: (413) The request body is too large and exceeds the maximum permissible limit..

Cause array is really huge.

Is there any ways how to resolve this?

Chunk your uploads... possibly store them in the table as the chunks too so it is easier to retrieve them — Michael Coxon, Aug 15 '17 at 16:09
@MichaelCoxon, any link how to do this? Something like here https://stackoverflow.com/a/18170921/3917754 — demo, Aug 15 '17 at 16:20

Chirag Rupani · Accepted Answer · 2017-08-15T16:28:38.127

6

In Azure table storage, maximum storage capacity of entity is about 1 MB (Azure Storage Scalability and Performance Targets).

Check if data exceeds the specified limit, in that case you might need to store data in the Azure Blob and add reference to it in the table or directly using it.

edited Aug 15 '17 at 16:28

answered Aug 15 '17 at 16:21

Chirag Rupani

1,675
1
17
37

1

Also, [the maximum size of a byte array column is only 64k](https://learn.microsoft.com/en-us/rest/api/storageservices/understanding-the-table-service-data-model). – Stephen Cleary Aug 15 '17 at 17:11

How to save huge byte array into azure table storage?

1 Answers1