Amazon DynamoDB Data ETL
domo
💎
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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 27 γη₯γγ
- 64 Kowaza
- 299 δ»²ιγ«ηΈθ«
- 654 γ²γγγε ±ζ