Limit to the column size in azure table

Nishant picture Nishant · Jun 30, 2017 · Viewed 10.6k times · Source

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.

Answer

Amor picture Amor · Jun 30, 2017

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.