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?
Comments
-
How does the data appear in Dynamo DB itself? Are you saying it seems Domo is combining it into one column or are you saying you are storing as shown, all in one, so Domo is then pulling that. I haven't attempted a Dynamo connection before but set this one up to test and it appears to work as expected.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive