Does anyone know of any good solution for exportin...
# helpt
Tobias T
06/14/2022, 5:27 PMDoes anyone know of any good solution for exporting / importing a dynamodb table to another dynamodb table?
t
thdxr
06/14/2022, 5:32 PMdepends on why you need to do this, can you share more?
t
Tobias T
06/14/2022, 5:33 PMWe have a dynamo table with about 6000 rows in our stage environment that we want to import into our newly created production table
Tobias T
06/14/2022, 5:34 PMProbably not SST related..
t
thdxr
06/14/2022, 5:35 PM6000 rows seems small so I'd maybe just read it out manually and write it back
t
Tobias T
06/14/2022, 5:36 PMyeah I guess we can do that 🙂
t
thdxr
06/14/2022, 5:36 PMI do know there's a cli command for
dynamodb restore-table-from-backupthdxr
06/14/2022, 5:36 PMbut cross account stuff maybe tricky: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Restore.Tutorial.html#restoretable_console
t
Tobias T
06/14/2022, 5:37 PMI have been down the google rabbit hole for a while and came across AWS Pipeline / AWS Glue and it seems to be way to complicated for our use case
r
Ross Coundon
06/14/2022, 5:39 PMI had a similar experience, I ended up writing a small utility to read and then write it
d
Devin
06/14/2022, 5:40 PMRoss, you essentially jsut wrote a script?
r
Ross Coundon
06/14/2022, 5:41 PMYeah, a little CLI tool
Ross Coundon
06/14/2022, 5:41 PMWasn't a tonne of data so did the job
t
Tobias T
06/14/2022, 5:49 PMthis https://www.npmjs.com/package/dynamodump worked fine for us
g
Garret Harp
06/14/2022, 6:04 PMI personally just did a full scan of the old table and put all of it into a new table and 6k rows is nothing that should be super super fast (did about 200k rows myself not sure how long it took but couldnt have been more than like 15mins, been a long time since I did that migration 😅)