Dynamo New PartiQL Editor keeps on running

0

I have deployed my stack and I'd like to use the Dynamo New PartiQL Editor but for some reason it is not running the query.

I have checked the Inspector of the browser and looked at the Network, there is no error coming up.

The query I am running is well formed and it should not present any error.

Here is a example of the query SELECT * FROM "TABLE" WHERE "PK" = 'ORG#123456789'

I am using the single table design pattern.

asked a year ago184 views
2 Answers
1

One suggestion from me, ensure you have PartiQL permissions for the User which is logged into the console.

{
   "Version":"2012-10-17",
   "Statement":[
      {
         "Effect":"Allow",
         "Action":[
            "dynamodb:PartiQLInsert",
            "dynamodb:PartiQLUpdate",
            "dynamodb:PartiQLDelete",
            "dynamodb:PartiQLSelect"
         ],
         "Resource":[
            "arn:aws:dynamodb:us-west-2:123456789012:table/Music"
         ]
      }
   ]
}
profile pictureAWS
EXPERT
answered a year ago
0

I just asked the person responsible to the aws account to reattach the permissions for the Dynamo. The guy attach the administrator permission for testing purpose and I can confirm the problem was related to permissions. A good feedback to AWS team would be a better error handling for the PartiQL. I know this is a new service and it is very handy but as a recommendation I highly suggest this improvement as nothing was coming up.

answered a year ago
  • Thanks, I will update the PartiQL team with your feedback.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions