Exploring Amazon DynamoDB Indexes | Scribe

Exploring Amazon DynamoDB Indexes

  • Hafeez Baig |
  • 10 steps |
  • 35 seconds
  • Amazon Web ServicesAmazon Web Services
information ordinal icon
Refer to the following guide to learn how to use IAM in the cloud\ <https://scribehow.com/shared/Creating_an_IAM_User_and_User_Group_in_AWS_Management_Console__hWNiiXlcRJKFqYZZEJD-cg>
1
Sign in to **AWS Management Console** as an **IAM User** **Pre-requisite** - Ensure you have selected the AWS region closest to your location\ For this guide, we will be using us-east-2 (Ohio) as a preferred choice
2
Type **DynamoDB** in the search bar and click on **DynamoDB** to view the **DynamoDB** Dashboard
information ordinal icon
**What is DynamoDB in AWS?** Amazon DynamoDB is a fully managed NoSQL database service provided by Amazon Web Services (AWS). It is designed to provide high performance, scalability, and availability for applications that require low-latency access to large datasets. DynamoDB is a key component of AWS's database offerings and is widely used for a variety of use cases, ranging from mobile and web applications to gaming, IoT (Internet of Things), and more.
3
On the **DynamoDB** dashboard click on **Tables** from the left bar to view the Tables
4
Tables wizard will open, On the top right corner click on the **Create table** button
5
**Create table** wizard will open, scroll to the **Partition key** section and type "**name**" in the text input field with **String** Data type
information ordinal icon
**What is the Partition key in Amazon DynamoDB?** A partition key is a primary attribute that is used to distribute data across multiple partitions in the underlying storage infrastructure of DynamoDB. Every item in a DynamoDB table must have a unique partition key value, and DynamoDB uses this partition key to determine the partition in which the item will be stored.
6
On the **Sort key** section type "**city**" in the text input field with **String** Data type
information ordinal icon
**What is the Sort key in Amazon DynamoDB?** A sort key is an optional attribute that is part of the primary key for a table. While the partition key is required, the sort key is not, but it becomes relevant when you need to specify a sort order for items within a partition.
7
Scroll to the **Table settings** section, select the option **Customize settings**
8
Scroll to the **Secondary indexes** section and click on the **Create local index** button
information ordinal icon
**What is Secondary indexes in Amazon DynamoDB?** In Amazon DynamoDB, secondary indexes are additional data structures that allow you to query and retrieve items from a table using attributes other than the primary key. While DynamoDB tables are initially indexed on the primary key (either the partition key or a composite of partition key and sort key), secondary indexes provide flexibility by enabling queries based on different attributes, thus supporting various access patterns.
9
**New local secondary index** wizard will open, give "**country**" in the text input field for the Sort key with **String** Data type
10
Give "**country-index**" as the Index name in the text input field and click on the **Create index** button to create Local secondary index
information ordinal icon
Congratulations on successfully creating and exploring Amazon DynamoDB Indexes! Well done!