Can we rollback the version of table in AWS glue?

0

We have created a table in athena and we are updating the schema of the table accordingly the versions are being created of that table in AWS Glue so can we roll down that version in glue and same version schema should be reflected in the AWS Athena.

demandé il y a un an1,3 k vues
2 réponses
0

That is not a common use case unless there was a mistake, normally you evolve the table as you evolve the data so you would need to also rollback the data.
You can delete the version you want to rollback using the CLI or the APIs: https://docs.aws.amazon.com/cli/latest/reference/glue/delete-table-version.html

profile pictureAWS
EXPERT
répondu il y a un an
profile picture
EXPERT
vérifié il y a 7 mois
0

It is not possible to "rollback" to a previous version per se and also you cannot delete the latest version of the table (neither on the console nor via API/CLI) so the only option is to publish a new schema version that is identical to the one you want to restore back to.

The easiest way to do this from is from the console by navigating to the table and version you want to restore and then click on "Edit Schema as JSON" the editor will be populated with the JSON of that version and then just click on "Save as new table version" which will create a new version with the same format which actually restores your table schema to the desired state.

Enter image description here

répondu il y a 2 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions