Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create a dynamodb table using AWS CLI?

I am trying below command after aws

--configure command:

aws dynamodb create-table 
--table-name MusicCollection2 
--attribute-definitions

 AttributeName=Artist,AttributeType=S AttributeName=SongTitle,AttributeType=S --

key-schema AttributeName=Artist,KeyType=HASH AttributeName=SongTitle,KeyType=RANGE 

--provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5

Output: Nothing

Please give suggestion how to create dyanmodb table using AWS CLI.

like image 202
Anoop Kumar Avatar asked Feb 24 '17 09:02

Anoop Kumar


People also ask

How do I create a DynamoDB table from the command-line?

Creating an AWS DynamoDB table from the command-line Step 1: Set Up Your AWS CLI Credentials Create the file ~/.aws/config and add a block like the following: This will let... Step 2: Create the Table JSON File The easiest way to create a new table is by passing a JSON file with the table schema... ...

How do I Check my DynamoDB table in AWS?

We can double check our work by heading back into the AWS console, click on “ Database ”, select “ DynamoDB”, and click on “ Tables ” to view our tables. From this point forward we’ll use the AWS console to complete our table. Click on the name on the table.

What is the KMS key archival attribute in DynamoDB?

This attribute will automatically be cleared when DynamoDB detects that the table's KMS key is accessible again. DynamoDB will initiate the table archival process when table's KMS key remains inaccessible for more than seven days from this date. Contains information about the table archive.

What is the value of the tablestatus field in DynamoDB?

When DynamoDB finishes creating the table, the value of the TableStatus field is set to ACTIVE. The following AWS CLI example creates a new Music table using create-table. Using create-table returns the following sample result. Note that the value of the TableStatus field is set to CREATING.


1 Answers

  1. Create the JSON file create-table-movies.json with the below content

    {
        "TableName": "MusicCollection2",
        "KeySchema": [
          { "AttributeName": "Artist", "KeyType": "HASH" },
          { "AttributeName": "SongTitle", "KeyType": "RANGE" }
        ],
        "AttributeDefinitions": [
          { "AttributeName": "Artist", "AttributeType": "S" },
          { "AttributeName": "SongTitle", "AttributeType": "S" }
        ],
        "ProvisionedThroughput": {
          "ReadCapacityUnits": 5,
          "WriteCapacityUnits": 5
        }
    }
    
  2. Browse to the file path on DOS command prompt (assuming Windows OS) and execute the below command

Creates the table on local DynamoDB:-

    aws dynamodb create-table --cli-input-json file://create-table-movies.json --endpoint-url http://localhost:8000

To create the table on AWS DynamoDB service, please provide the correct region name. If your config is done already, it should work.

aws dynamodb create-table --cli-input-json file://create-table-movies.json --region us-west-2

AWS CLI Configure:-

$ aws configure
AWS Access Key ID [None]: accesskey
AWS Secret Access Key [None]: secretkey
Default region name [None]: us-west-2
Default output format [None]:

Once you execute the above command, it updates the data on your profile (on windows).

C:\Users\<username>\.aws\

Check the following files:-

config   - should have the region name
credentials  - should have access key and secret key

Credentials Sample:-

[default]
aws_access_key_id = aaaadffewe
aws_secret_access_key = t45435egfdg456retgfg

Config File Sample:-

[default]
region = us-east-1
like image 108
notionquest Avatar answered Oct 18 '22 22:10

notionquest