How To Scan In DynamoDB ?

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. You can use Amazon DynamoDB to create a database table that can store and retrieve any amount of data, and serve any level of request traffic. Amazon DynamoDB automatically spreads the data and traffic for the table over a sufficient number of servers to handle the request capacity specified by the customer and the amount of data stored, while maintaining consistent and fast performance.

Please refer to this article before diving into Scan Operation in DynamoDB - DynamoDB Introduction

Scan Operation

Scan operation in Amazon DynamoDB reads every item in a table or a secondary index. By default, a Scan operation returns all of the data attributes for every item in the table or index.

Scan always returns a result set. If no matching items are found, the result set is empty. A single Scan request can retrieve a maximum of 1 MB of data.

To do the scan operation from the AWS Management Console, Follow the below steps:

• Open the DynamoDB console at https://console.aws.amazon.com/dynamodb/.
• In the navigation pane on the left side of the console, choose Tables.
• Choose your table from the table list.
• Choose Explore Table Items.
• In the Scan or Query items, Choose Scan.
• In the Select Attribute Projection list, Select whether you want all attributes to be returned or the specific attributes to be returned.
• And Run

Let's dive into the small example. I have the table named test-table which have the following items.

If I want to do the scan operation to get all attributes from the table, Then

But If you want specific attributes, then select them from specific projection. Here I am selecting only fname and lname, so only two attributes are returned.

The following code snippet in python will return all the Attributes.

import boto3

def lambda_handler(event, context):
    client = boto3.client("dynamodb")
    
    response = client.scan(
            TableName= "Your-Table-Name",
            Select='ALL_ATTRIBUTES' # This will select All Attributes and return         
        )
    return {
            "statusCode" : 200,
            "headers" : {},
            "body" : response
        }

The following code snippet will only return the specified attributes.

import json
import boto3

def lambda_handler(event, context):
    client = boto3.client("dynamodb")
    
    response = client.scan(
            TableName= "Your-Table-Name",
            AttributesToGet=[
                'fname','lname'
            ] # The specified attributes are returned from the table.      
        )
    return {
            "statusCode" : 200,
            "headers" : {},
            "body" : response
        }

This is how we can do Scan operation with Console and Code.

bhargav_katabathuni

Follow

Improve

Article Tags :

• DBMS
• AWS
• Geeks Premier League 2023