Athena Migration

0

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?

demandé il y a 2 ans900 vues
1 réponse
0

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.

The unnecessary fields are:

  • DatabaseName
  • CreateTime
  • UpdateTime
  • CreatedBy
  • IsRegisteredWithLakeFormation
  • CatalogId
  • CatalogId
profile picture
EXPERT
iwasa
répondu il y a 2 ans

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