search

aws-amplify / amplify-studio

AWS Amplify Studio (Formerly Admin UI)
136 stars 31 forks source link

bulk update table in data manager amplify studio #1010

Closed rahuljhu closed 1 year ago

rahuljhu commented 1 year ago
image

Which Specific Feature is your question related to?

data manager in amplify studio

Question

I want to bulk update a data table in the amplify studio data manager. Is there a way to do it? I see it allows to createNote, but that only fills row one by one, I want to create thousands of rows in a go, may be using a offline csv.

ykethan commented 1 year ago

Hey @rahuljhu, thank you for reaching out. Amplify Studio data manager currently does not support batch uploads. You will need to utilize a custom solution such as use the Amplify JS library to upload records iteratively or custom script that uploads records iteratively or build a custom vtl resolvers with custom mutation query that does a batch put. Do note that Amplify Studio does not support custom queries, we will have to use the Amplify CLI to pull the project and create the custom queries.

Additionally, observed the banner with the warning message. This appears when we create a record without the required fields set as DataStore utilizes these fields. We will need to backfill the 3 records with the _version and _lastChangedAt.

ykethan commented 1 year ago

@rahuljhu following up on this issue, would you require any further assistance.

ykethan commented 1 year ago

Closing the issue due to inactivity. Please feel free in reaching out to us, we would be happy in assisting you.

github-actions[bot] commented 1 year ago

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see. If you need more assistance, please open a new issue that references this one. If you wish to keep having a conversation with other community members under this issue feel free to do so.