Athena Migration

Question

I have Athena tables, views created on  S3 in an account which I want to migrate to another account. What is the best possible way to migrate?

Answer

Hi, @Ajeeth K

There are no migration methods available, so you'll have to do the extraction and copying yourself.

You can get the metadata structure of the table used by Athena with `aws glue get-table`.  
Then, by deleting unnecessary fields and changing the parameters for the acquired structure and doing `aws glue create-table`, you can copy the structure to another database and use it from Athena.

- https://awscli.amazonaws.com/v2/documentation/api/latest/reference/glue/get-table.html
- https://awscli.amazonaws.com/v2/documentation/api/latest/reference/glue/create-table.html

The unnecessary fields are:
- DatabaseName
- CreateTime
- UpdateTime
- CreatedBy
- IsRegisteredWithLakeFormation
- CatalogId
- CatalogId

Athena Migration

Relevant content