Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Limit to the column size in azure table

Though official site of azure table talks about limitation of other entities, I never read anything on column data size limitation. While few non official blog talks about max size of 64KB. Is this the case or there is no limitation on the size of a column only limited by row size of 1MB.

like image 574
Nishant Avatar asked Jun 30 '17 06:06

Nishant


People also ask

Is Azure table storage scalable?

The scalability limit for accessing tables is up to 20,000 entities (1 KB each) per second for an account.


1 Answers

Is this the case or there is no limitation on the size of a column only limited by row size of 1MB.

We can find the limitation of property is 64KB from following official document.

Understanding the Table Service Data Model

  1. The combined size of all data in an entity's properties cannot exceed 1 MB.
  2. The partition key may be a string value up to 1 KB in size.
  3. The row key is a string value that may be up to 1 KB in size.
  4. For property types. If the type of the property is byte array, An array of bytes up to 64 KB in size. If the type of property is string, String values may be up to 64 KB in size.
like image 84
Amor Avatar answered Oct 03 '22 12:10

Amor