Athena Migration

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