You are currently viewing Secondary Indexes In DynamoDB

Secondary Indexes In DynamoDB

Secondary Indexes in DynamoDB

Hello Everyone

Welcome to CloudAffaire and this is Debjeet

In the last blog post, we have discussed Primary Key in DynamoDB.

In this blog post, we are going to discuss Secondary Indexes in DynamoDB.

Secondary Indexes in DynamoDB:

You can create one or more secondary indexes on a table. A secondary index lets you query the data in the table using an alternate key, in addition to queries against the primary key. DynamoDB doesn’t require that you use indexes, but they give your applications more flexibility when querying your data. After you create a secondary index on a table, you can read data from the index in much the same way as you do from the table.

DynamoDB supports two kinds of indexes:

  • Local secondary index
  • Global secondary index

Local secondary index:

An index that has the same partition key as the table, but a different sort key.

Global secondary index:

An index with a partition key and sort key that can be different from those on the table.

Each table in DynamoDB has a limit of 20 global secondary indexes (default limit) and 5 local secondary indexes per table. Every index belongs to a table, which is called the base table for the index. DynamoDB maintains indexes automatically. When you add, update, or delete an item in the base table, DynamoDB adds, updates, or deletes the corresponding item in any indexes that belong to that table. When you create an index, you specify which attributes will be copied, or projected, from the base table to the index. At a minimum, DynamoDB projects the key attributes from the base table into the index.

Next, we are going to create both local secondary index and global secondary index in our local DynamoDB instance.

Step 1: Create a table with a local secondary index

Secondary Indexes in DynamoDB

Note: Our composite primary key is on company and id. We have created the local secondary index on the country. Hence we will be able to query the table using [company and id] or [company and country]. The local secondary index needs to be created at the time of table creation and cannot add once the table is created.

Step 2: Insert some data in the ClodAffaire table

Secondary Indexes in DynamoDB

Note: You can download the employee.json file from GitHub

Step 3: Query the table data with the company and country

Secondary Indexes in DynamoDB

Note: In order to query using an index, you have to provide the index name in the query.

Next, let’s try to query on a different element (did) which is not the table partition key.

Secondary Indexes in DynamoDB

Note: We are unable to query the table as did is not part of the partition key. To query using a non-partition key, we need to create a global secondary index on the table with the desired element (did in this case)

Step 4: Create a global secondary index (did and country) on an existing table

Secondary Indexes in DynamoDB

Step 5: Query the table data where did=10 and country=India

Secondary Indexes in DynamoDB

Note: In order to query the global secondary index, the index named needs to be given in the query statement.

Delete the table:

Hope you have enjoyed this article. In the next blog post, we will discuss Streams in DynamoDB

To get more details on DynamoDB, please refer below AWS documentation