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.

asked a year ago1.3K views
2 Answers
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
answered a year ago
profile picture
EXPERT
reviewed 7 months ago
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

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions