Search code examples
amazon-web-servicesamazon-dynamodbmqttiotaws-iot

Data is not retrieved in DynamoDB table but not in DynamoDBv2

enter image description here

This is the data I receive which inserts into my dynamodb table perfectly fine as seen in the image below. enter image description here However, I want it to be sorted into multiple columns so I changed the action to DynamoDBv2. Upon doing this, it stopped receiving the data. I tried to create a new table, role, and rule but it still did not receive anything. I tried to change the table back into the normal dynamoDB, and it worked but it saved all data (buttonPress and id) in a single column, which is not what I wanted.

Current Payload: enter image description here

SQL Statement: enter image description here

DescribeTable output: enter image description here

Any input is very well appreciated.

Solution

  • Your rule should select both the keys from the payload also

    SELECT Date, Time, buttonPress from topic