Dynamo New PartiQL Editor keeps on running

Question

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.

Answer

One suggestion from me, ensure you have [PartiQL permissions](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-iam.html#access-policy-ql-iam-example1) 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"
         ]
      }
   ]
}
```

Answer

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.

Dynamo New PartiQL Editor keeps on running

相关内容