Working With DynamoDB Columns/Attributes

Published on December 24th, 2021

Still using AWS console to work with DynamoDB? 🙈

Time to 10x your DynamoDB productivity with Dynobase [learn more]

Amazon DynamoDB is a NoSQL database service that supports both key-value and document data structures. As a non-relational database, there is no such concept as a "column" in DynamoDB. Instead, DynamoDB consists of tables, items, and attributes.

DynamoDB Attributes - What You Need To Know

The main difference compared to a "column" based database is that each item in a DynamoDB table can have a different number of attributes.

In addition, DynamoDB supports several data types for attributes.

Scalar Types (string, number, binary, Boolean, and null)
Document Types (JSON)
Set Types (number set, string set, and binary set)

These attributes could hold either a single value or an object having up to 32 levels of nested child attributes. I hope now you have a good understanding of the DynamoDB data structure.

Therefore, let's look at how to work with DynamoDB attributes in detail.

Working with DynamoDB Attributes

In order to add attributes, you need to first create a table. You can use AWS Console, AWS CLI, AWS SDK, or the DynamoDB Table Creation feature in Dynobase.

Suppose there is a Book table having the key attributes:

Partition key - BookAuthor
Sort key - BookTitle

You must first define the partition key and sort key pair since it's mandatory upon table creation. The below screenshot shows how to create the Book table using _Operation Builder_ in Dynobase.

DynamoDB Create Table Attributes

DynamoDB Add Attribute To All Items

This is somewhat similar to adding a column in a SQL database. However, you don't have a direct way of adding an attribute to all the items in DynamoDB. Therefore you need to Scan the items to get their keys and update each item to add the attribute. Let's look at adding createdDate attribute to all the items.

void AddAttributeToAllItems() {
    //DynamoDB Client Object
    AmazonDynamoDB dynamoDBClinet = AmazonDynamoDBClientBuilder
        .standard()
        .withRegion(Regions.AP_SOUTH_1)
        .withCredentials(new AWSStaticCredentialsProvider(
            new BasicAWSCredentials("ACCESS_KEY", "SECRET_KEY")))
        .build();

    ScanRequest scanRequest = new ScanRequest()
        .withTableName("Book");

    ScanResult result = dynamoDBClinet.scan(scanRequest);

    for (Map < String, AttributeValue > item: result.getItems()) {
        Books book = new Books();
        book.setBookAuthor(item.get("BookAuthor").getS());

        UpdateItemResult uresult = dynamoDBClinet.updateItem(new UpdateItemRequest().withTableName("Book")
            .withReturnValues(ReturnValue.ALL_NEW)
            .addKeyEntry("BookAuthor", new AttributeValue().withS(item.get("BookAuthor").getS()))
            .addAttributeUpdatesEntry("createdDate", new AttributeValueUpdate().withValue(new AttributeValue().withS("Yes")).withAction(AttributeAction.PUT)));
    }
}void AddAttributeToAllItems() {
    //DynamoDB Client Object
    AmazonDynamoDB dynamoDBClinet = AmazonDynamoDBClientBuilder
        .standard()
        .withRegion(Regions.AP_SOUTH_1)
        .withCredentials(new AWSStaticCredentialsProvider(
            new BasicAWSCredentials("ACCESS_KEY", "SECRET_KEY")))
        .build();

    ScanRequest scanRequest = new ScanRequest()
        .withTableName("Book");

    ScanResult result = dynamoDBClinet.scan(scanRequest);

    for (Map < String, AttributeValue > item: result.getItems()) {
        Books book = new Books();
        book.setBookAuthor(item.get("BookAuthor").getS());

        UpdateItemResult uresult = dynamoDBClinet.updateItem(new UpdateItemRequest().withTableName("Book")
            .withReturnValues(ReturnValue.ALL_NEW)
            .addKeyEntry("BookAuthor", new AttributeValue().withS(item.get("BookAuthor").getS()))
            .addAttributeUpdatesEntry("createdDate", new AttributeValueUpdate().withValue(new AttributeValue().withS("Yes")).withAction(AttributeAction.PUT)));
    }
}

Besides, if you are dealing with a large table, it's important to scan the table page-wise and add the attribute to each item.

DynamoDB Add Attribute to Existing Item

Now let's look at adding attributes to individual items. First, you need to know the primary key and the sort key of the item. Then you can run an update expression to add the attribute. I'm going to add the attribute isSold only to a selected item.

void AddAttributeToAItem()(AmazonDynamoDBClient dynamoDBClinet, String tableName,String val,String key, String keyVal){

    Map<String, AttributeValue> itemKey = new HashMap();
    key.put(key, new AttributeValue().withS(keyVal));
  
    Map<String, AttributeValueUpdate> attributeUpdates = new HashMap<String, AttributeValueUpdate>();
    AttributeValueUpdate update = new AttributeValueUpdate().withAction(AttributeAction.PUT).withValue(new AttributeValue().withS(val));
    attributeUpdates.put("isSold", update);

    UpdateItemRequest updateItemRequest = new UpdateItemRequest().withTableName(tableName).withKey(itemKey).withAttributeUpdates(attributeUpdates);
    dynamoDBClinet.updateItem(updateItemRequest);
}void AddAttributeToAItem()(AmazonDynamoDBClient dynamoDBClinet, String tableName,String val,String key, String keyVal){

    Map<String, AttributeValue> itemKey = new HashMap();
    key.put(key, new AttributeValue().withS(keyVal));
  
    Map<String, AttributeValueUpdate> attributeUpdates = new HashMap<String, AttributeValueUpdate>();
    AttributeValueUpdate update = new AttributeValueUpdate().withAction(AttributeAction.PUT).withValue(new AttributeValue().withS(val));
    attributeUpdates.put("isSold", update);

    UpdateItemRequest updateItemRequest = new UpdateItemRequest().withTableName(tableName).withKey(itemKey).withAttributeUpdates(attributeUpdates);
    dynamoDBClinet.updateItem(updateItemRequest);
}

DynamoDB Rename Attributes

You may think this is similar to renaming a column in a SQL database. However, in DynamoDB, you can not directly rename an existing attribute. First, you need to add a new attribute for each of the entries and remove all the values for the existing attribute.

Let's look at how we can rename isSold to userPurchased.

/* 
Any primary key attributes cannot be updated using UpdateItem. Instead, delete the item and then use PutItem to create a new item with new attributes.*/

/* refer DynamoDB Add Attribute to Existing Item and DynamoDB Remove Attributes from an Existing Item to rename attribute*//* 
Any primary key attributes cannot be updated using UpdateItem. Instead, delete the item and then use PutItem to create a new item with new attributes.*/

/* refer DynamoDB Add Attribute to Existing Item and DynamoDB Remove Attributes from an Existing Item to rename attribute*/

DynamoDB Remove Attributes from an Existing Item

You can use the REMOVE clause in an update expression to delete an attribute from an item. Nothing happens even if trying to delete an attribute that does not exist.

Let's look at removing the userPurcahased attribute from an item.

void DeleteAttribute()(AmazonDynamoDBClient dynamoDBClinet, String tableName, String key, String keyVal)
{
    Map<String, AttributeValue> itemKey = new HashMap();
    itemKey.put(key, new AttributeValue().withS(keyVal));
    Map<String, AttributeValueUpdate> attributeUpdates = new HashMap<String, AttributeValueUpdate>();

    AttributeValueUpdate avu = new AttributeValueUpdate(null, "DELETE");

    attributeUpdates.put("userPurcahased", avu);
    UpdateItemRequest updateItemRequest = new UpdateItemRequest(tableName, itemKey, attributeUpdates);
    dynamoDBClinet.updateItem(updateItemRequest);
}void DeleteAttribute()(AmazonDynamoDBClient dynamoDBClinet, String tableName, String key, String keyVal)
{
    Map<String, AttributeValue> itemKey = new HashMap();
    itemKey.put(key, new AttributeValue().withS(keyVal));
    Map<String, AttributeValueUpdate> attributeUpdates = new HashMap<String, AttributeValueUpdate>();

    AttributeValueUpdate avu = new AttributeValueUpdate(null, "DELETE");

    attributeUpdates.put("userPurcahased", avu);
    UpdateItemRequest updateItemRequest = new UpdateItemRequest(tableName, itemKey, attributeUpdates);
    dynamoDBClinet.updateItem(updateItemRequest);
}

DynamoDB Remove Attribute From All Items

To give a SQL analogy, this is like removing a column from DynamoDB. You can do this by running a scan and looping through the update expression for each item. Let's remove userPurchased attribute from all the items.

void AddAttributeToAllItems(String tableName,String key){
//DynamoDB Client Object
AmazonDynamoDB dynamoDBClinet = AmazonDynamoDBClientBuilder
    .standard()
    .withRegion(Regions.AP_SOUTH_1)
    .withCredentials(new AWSStaticCredentialsProvider(
    new BasicAWSCredentials("ACCESS_KEY","SECRET_KEY")))
    .build();


   ScanRequest scanRequest = new ScanRequest()
    .withTableName(tableName);

   ScanResult result = dynamoDBClinet.scan(scanRequest);
   for (Map<String, AttributeValue> item : result.getItems()){
  
   Map<String, AttributeValue> itemKey = new HashMap();
          itemKey.put(key, new  AttributeValue().withS(item.get(key).getS()));

   Map<String, AttributeValueUpdate> attributeUpdates = new HashMap<String, AttributeValueUpdate>();
      
   AttributeValueUpdate avu = new AttributeValueUpdate(null, "DELETE");
      
   attributeUpdates.put("userPurcahased", avu);
          UpdateItemRequest updateItemRequest = new UpdateItemRequest(tableName, itemKey, attributeUpdates);
          dynamoDBClinet.updateItem(updateItemRequest);       
   }
}void AddAttributeToAllItems(String tableName,String key){
//DynamoDB Client Object
AmazonDynamoDB dynamoDBClinet = AmazonDynamoDBClientBuilder
    .standard()
    .withRegion(Regions.AP_SOUTH_1)
    .withCredentials(new AWSStaticCredentialsProvider(
    new BasicAWSCredentials("ACCESS_KEY","SECRET_KEY")))
    .build();


   ScanRequest scanRequest = new ScanRequest()
    .withTableName(tableName);

   ScanResult result = dynamoDBClinet.scan(scanRequest);
   for (Map<String, AttributeValue> item : result.getItems()){
  
   Map<String, AttributeValue> itemKey = new HashMap();
          itemKey.put(key, new  AttributeValue().withS(item.get(key).getS()));

   Map<String, AttributeValueUpdate> attributeUpdates = new HashMap<String, AttributeValueUpdate>();
      
   AttributeValueUpdate avu = new AttributeValueUpdate(null, "DELETE");
      
   attributeUpdates.put("userPurcahased", avu);
          UpdateItemRequest updateItemRequest = new UpdateItemRequest(tableName, itemKey, attributeUpdates);
          dynamoDBClinet.updateItem(updateItemRequest);       
   }
}

DynamoDB Query Attribute

When retrieving items from DynamoDB, you can use the query operation. If the table contains only the partition key, you can use it to query items in the table. Otherwise, you need to know the partition key and the values to compare against the sort key.

DynamoDB Query Attribute

You can use the filter option in Dynobase for fast filtration at development time.

DynamoDB Filter Items

DynamoDB Query Two Attributes

The below code shows how to query attributes in DynamoDB using Java. The Book table consists of BookAuthor (partition key) and BookTitle (sort key) attributes.

void Query(){
    Map<String, AttributeValue> eav = new HashMap<String, AttributeValue>();
    eav.put(":v1",new AttributeValue().withS("Daniel Chidiac"));
    eav.put(":v2", new AttributeValue().withS("Who says you can't you do"));

    DynamoDBQueryExpression<Book> queryExpression = new DynamoDBQueryExpression<Book>()
            .withKeyConditionExpression("BookAuthor = :v1 and BookTitle= :v2")
            .withExpressionAttributeValues(eav);
    List<Book> books = dynamoDBMapper.query(Book.class,queryExpression);
}void Query(){
    Map<String, AttributeValue> eav = new HashMap<String, AttributeValue>();
    eav.put(":v1",new AttributeValue().withS("Daniel Chidiac"));
    eav.put(":v2", new AttributeValue().withS("Who says you can't you do"));

    DynamoDBQueryExpression<Book> queryExpression = new DynamoDBQueryExpression<Book>()
            .withKeyConditionExpression("BookAuthor = :v1 and BookTitle= :v2")
            .withExpressionAttributeValues(eav);
    List<Book> books = dynamoDBMapper.query(Book.class,queryExpression);
}

If you need to query items based on non-key attributes, you can still perform it using the scan operation. However, it is expensive and slow compared to the query operation as it has to compare against all the items in a table.

DynamoDB Query Nested Attributes

As you have seen, in DynamoDB, you can query based on the primary key, sort key, or use the keys in LSI or GSI. Since key condition expressions for the query are limited, you cannot query by nested attributes.

DynamoDB Scan Return All Attributes

DynamoDB Scan All Attributes

DynamoDB scan method will scan through the entire table and returns all of the table's data attributes for each item. A single Scan request can only retrieve 1 MB of data at a time.

The below code shows how to scan the table and return all the attributes for each item in DynamoDB using Java. The name of the table to scan is specified in the ScanRequest instance.

void Scan(){
   AmazonDynamoDB client = AmazonDynamoDBClientBuilder.standard().build();

   ScanRequest scanRequest = new ScanRequest()
    .withTableName("Book");

   ScanResult result = client.scan(scanRequest);
   for (Map<String, AttributeValue> item : result.getItems()){
    printItem(item);
   }
}void Scan(){
   AmazonDynamoDB client = AmazonDynamoDBClientBuilder.standard().build();

   ScanRequest scanRequest = new ScanRequest()
    .withTableName("Book");

   ScanResult result = client.scan(scanRequest);
   for (Map<String, AttributeValue> item : result.getItems()){
    printItem(item);
   }
}

DynamoDB List Attributes

In DynamoDB, there is no direct way to get the list of attributes in a table. The only possible way is to query the items and list down the attributes.

FAQ

Does DynamoDB have attributes/columns?

There is no such thing as a "column" in DynamoDB as it's not a relational database. DynamoDB is a key-value NoSQL database with items and attributes.

How many attributes/columns can DynamoDB have?

As there are no columns in DynamoDB, You can add a new item with a new attribute. An item can have one or more attributes. The maximum number of attributes per item must be 400KB.

What are the types of attributes/columns DynamoDB can have?

Within a table, DynamoDB allows a variety of data types for attributes such as Scalar Types (string, number, binary, Boolean, and null), Document Types (JSON), and Set Types (number set, string set, and binary set)