DynamoDB - How to analize data from payload?


I have DynamoDB table. It returns 3 columns.

First 2 columns are ID of the device and date in UNIX format. I can change it though.

I want to make graphs for PMag, PSys and PSet values that are in JSON. But I cannot figure out how to them out.


I’ve managed to solve my problem. I reorganized on AWS so it saves in separate columns.


Yeah this is what I would recommend. The JSON table formatting is useful but we don’t as yet have a good way to expand JSON data into tabular form inside of Redash. The recently release JSON data source allows for unpacking object contents. So I’d be curious to see if this could be added to other document-style databases.