내용으로 건너뛰기

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.

질문됨 2년 전2.7천회 조회
2개 답변
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

AWS
전문가
답변함 2년 전
전문가
검토됨 2년 전
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

답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.