Creating a DynamoDB Table

45 minutes
  • 4 Learning Objectives

About this Hands-on Lab

In this hands-on lab, we will create a DynamoDB table to store pet inventory data. In the scenario, the data architect on the team has requested a table definition with a partition key of `pet_species` with the data type `String`, a sort key of `pet_id` with the data type `Number`, and that the table be named `PetInventory`. Because the workload in development is not known, `On-Demand` provisioning should be utilized. We’re free to create the table with any method we choose (web console, CLI/SDK, CloudFormation).

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create a DynamoDB Table Using the AWS Web Console
  1. Navigate to the DynamoDB web console.
  2. Click Create table.
  3. Provide configuration options outlined in the lab instructions.
  4. Click Create.
Create a DynamoDB Table Using the AWS CLI

The following command will create the requested DynamoDB table:

aws dynamodb
    create-table
        --table-name PetInventory
        --attribute-definitions
            AttributeName=pet_species,AttributeType=S
            AttributeName=pet_id,AttributeType=S
        --key-schema
            AttributeName=pet_species,KeyType=HASH
            AttributeName=pet_id,KeyType=RANGE
        --billing-mode PAY_PER_REQUEST
Create a DynamoDB Table with the Python Boto3 SDK

The following Python script will create the requested DynamoDB table:

import boto3
ddb = boto3.client('dynamodb')
createResponse = ddb.create_table(
    AttributeDefinitions=[
        {
            'AttributeName':'pet_species',
            'AttributeType': 'S',
        }, 
        {
            'AttributeName':'pet_id',
            'AttributeType':'N'
        }
    ], 
    KeySchema=[
        {
            'AttributeName':'pet_species',
            'KeyType':'HASH'
        },
        {
            'AttributeName':'pet_id',
            'KeyType':'RANGE'
        },
    ],
    BillingMode = 'PAY_PER_REQUEST',
    TableName='PetInventory'
)
Create a DynamoDB Table with CloudFormation

The following template will create the requested DynamoDB table"

{
    "AWSTemplateFormatVersion": "2010-09-09",
    "Resources": {
        "PetTable": {
            "Type": "AWS::DynamoDB::Table",
            "Properties": {
                "AttributeDefinitions" : [
                    {
                        "AttributeName": "pet_species",
                        "AttributeType": "S"
                    },
                    {
                        "AttributeName": "pet_id",
                        "AttributeType": "N"
                    }
                ],
                "KeySchema" : [
                    {
                        "AttributeName": "pet_species",
                        "KeyType": "HASH"
                    },
                    {
                        "AttributeName": "pet_id",
                        "KeyType": "RANGE"
                    }
                ],
                "TableName": "PetInventory",
                "BillingMode": "PAY_PER_REQUEST"
            }
        }
    }
}

Additional Resources

Your consulting company has been hired to create a new version of the website and associated apps for an exotic pet retailer. You've been tasked with creating a DynamoDB table to store pet inventory data. The data architect on the team has requested a table definition with a partition key of pet_species with the data type String, a sort key of pet_id with the data type Number, and that the table be named PetInventory. Because the workload in development is not known, On-Demand provisioning should be utilized. You're free to create the table with any method you choose (web console, CLI/SDK, CloudFormation).

Once you have created your DynamoDB table, the following AWS CLI command will verify the table was created as requested:

aws dynamodb
    describe-table
        --table-name PetInventory
        --query 'Table.{PartitionKey:KeySchema[0].AttributeName,
PartKeyType:AttributeDefinitions[1].AttributeType,SortKey:KeySchema[1].AttributeName,SortKeyType:AttributeDefinitions[0].AttributeType,BillingMode:BillingModeSummary.BillingMode}'

If the table was created as requested, the output will be:

{
    "SortKeyType": "N",
    "PartitionKey": "pet_species",
    "BillingMode": "PAY_PER_REQUEST",
    "SortKey": "pet_id",
    "PartKeyType": "S"
}

A CloudFormation template to complete this lab can be found at the link below.

CloudFormation Template

Reference

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!