Amazon DynamoDB Data ETL
My team recently began to transition one of our key source data systems to be housed on AWS DynamoDB. Our connection to the legacy system is cumbersome to say the least (e.g. use a custom powershell script, workbench, and csv to feed data to Domo)...So, I was excited to utilize one of Domo's API Connectors to DynamoDB, however, when I tested out the connection I found that all the data elements flow through in a single column `formdata`[screenshot below].
Our entire Domo instance runs off of a standard relational database format where we can utilize MySQL to transform and manipulate datapoints. Does anyone know an efficient way to get the data seen in the screenshot above into a format with columns and rows where we could mimic the format of our legacy systems output?