Creating a table in the AWS CLI

If you do not have the AWS CLI yet, install and configure it.

To create a series table with a series number partition key and a series title sort key:

1. Prepare the Document API endpoint and specify it:

   endpoint=<your_DB_endpoint>
   

2. Run this command:

   aws dynamodb create-table \
     --table-name <table_name> \
     --attribute-definitions \
       AttributeName=<series_number>,AttributeType=N \
       AttributeName=<series_title>,AttributeType=S \
       AttributeName=<series_description>,AttributeType=S \
       AttributeName=<series_release_date>,AttributeType=S \
     --key-schema \
       AttributeName=<series_number>,KeyType=HASH \
       AttributeName=<series_title>,KeyType=RANGE \
     --endpoint $endpoint
   

   Where:

   • --table-name: Table name.
   • --attribute-definitions: Description of item attributes, consisting of AttributeName and AttributeType, which can be:
     • N: Number
     • S: String
     • B: Binary
   • --key-schema: Key schema for the table, where AttributeName is the key attribute name, and KeyType can be:
     • HASH: Partition key.
     • RANGE: Sort key.

   The key-schema attributes should also be defined in the attribute-definitions array.

ExampleExample

To create a table named series with the series_id partition key and title sort key:

endpoint="your-database-endpoint"

aws dynamodb create-table \
  --table-name series \
  --attribute-definitions \
    AttributeName=series_id,AttributeType=N \
    AttributeName=title,AttributeType=S \
    AttributeName=series_info,AttributeType=S \
    AttributeName=release_date,AttributeType=S \
  --key-schema \
    AttributeName=series_id,KeyType=HASH \
    AttributeName=title,KeyType=RANGE \
  --endpoint $endpoint

Result:

{
    "TableDescription": {
        "AttributeDefinitions": [
            {
                "AttributeName": "series_id",
                "AttributeType": "N"
            },
            {
                "AttributeName": "title",
                "AttributeType": "S"
            },
            {
                "AttributeName": "series_info",
                "AttributeType": "S"
            },
            {
                "AttributeName": "release_date",
                "AttributeType": "S"
            }
        ],
        "TableName": "series",
        "KeySchema": [
            {
                "AttributeName": "series_id",
                "KeyType": "HASH"
            },
            {
                "AttributeName": "title",
                "KeyType": "RANGE"
            }
        ],
        "TableStatus": "ACTIVE",
        "CreationDateTime": "2020-12-27T13:21:10+00:00",
        "TableSizeBytes": 0,
        "ItemCount": 0
    }
}