Creating a directory hierarchy structure in table stores

Question

Is it possible to create a directory similar to the structure in Azure tables?

I need to save some metadata in a tree similar to a structure.

For example, if I have 10 elements and each element contains some columns of metadata (there are some common columns for them [id, name, date created, author ...], but there may also be some columns in which one element can be but no other)

Can these elements be saved in a structural way?

Item1 |_____ Item2 |_____ Item3 |_____ ItemX 

Answer 1

You cannot embed the way you describe, but using Azure tables is optional. In the above example, I would set Item1 = Partition Key. Elements 2 → n will be a Row Key. Each row can have a unique schema, and each element will be part of the index, so the search will be very fast.

The row keys must be unique within the section, so if necessary, you can have a repeating pattern (it's hard to say from the description).

You can then get all the items associated with Item1 by querying PK or get a single item by specifying PK + RK.

Answer 2

no - Azure tables are not relational - read here . However, you can have several properties so that objects have properties that are not populated. If you have an Azure account, you can use Azure Storage Explorer to explore and test Azure tables.