unable to create DynamoDB table from aws CLI

Question

I am very new to aws. I was trying to create a database table by running following command: ``

aws dynamodb create-table --table-name pizza-order --attribute-definitions AttributeName=orderId, AttributeType=S --key-schema AttributeName=orderId,keyType=HASH --provisioned-throughput ReadCapacityUnit=1,WriteCapacityUnit=1 --region us-east-2  --query TableDescription.TableArn --output text
``

But I am getting a error like this: Error parsing parameter '--attribute-definitions': Expected: '', received: '' for input: AttributeName=orderId,

AttributeName=orderId, AttributeType=S, can you remove the space between orderId and AttributeType and its KeyType,and ReadCapacityUnits same goes for WriteCapacityUnits and why are you using --query TableDescription.TableArn --output text what you want to achieve with ``query option — Jatin Mehrotra
– Jatin Mehrotra, Commented Apr 21, 2021 at 3:44

Shree · Accepted Answer · 2021-04-21 03:44:16Z

3

The command works with following modifications:

Remove space after orderId,
KeyType correctly capitalized
ReadCapacityUnits and WriteCapacityUnits correctly pluralized.

Here is the working command for your reference:

aws dynamodb create-table --table-name pizza-order --attribute-definitions AttributeName=orderId,AttributeType=S --key-schema AttributeName=orderId,KeyType=HASH --provisioned-throughput ReadCapacityUnits=1,WriteCapacityUnits=1 --region us-east-2 --query TableDescription.TableArn --output text

answered Apr 21, 2021 at 3:44

Shree

8586 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Asaduzzaman Himel Over a year ago

after dong that it gives following error. can u tell me what to do!? 😀 An error occurred (AccessDeniedException) when calling the CreateTable operation: User: arn:aws:iam::676374644948:user/suraiya_moon126 is not authorized to perform: dynamodb:CreateTable on resource: arn:aws:dynamodb:us-east-2:676374644948:table/pizza-order

Jatin Mehrotra Over a year ago

you need to atach a policy to your Iam user by going to users in iam -> under permission add permissions -> attach existing policies directly -. search for dynamodb full access and add it :)

Jatin Mehrotra · Accepted Answer · 2021-04-21 03:47:58Z

aws dynamodb create-table --table-name pizza-order --attribute-definitions AttributeName=orderId,AttributeType=S --key-schema AttributeName=orderId,KeyType=HASH --provisioned-throughput ReadCapacityUnits=1,WriteCapacityUnits=1 --region us-east-2 --query TableDescription.TableArn --output text

Docs for reference https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/getting-started-step-1.html

To verify that DynamoDB has finished creating the Music table, use the describe-table command.

 aws dynamodb describe-table --table-name pizza-order | grep TableStatus

This command returns the following result. When DynamoDB finishes creating the table, the value of the TableStatus field is set to ACTIVE.

"TableStatus": "ACTIVE",

note:- whenever you are stuck or want to know the details of the command its a good practice to check aws cli doc for particular API for create table

Collectives™ on Stack Overflow

unable to create DynamoDB table from aws CLI

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related