Migrating an existing data store to use Amazon Athena
data stores created before November, 14, 2022 are functional, but are not queryable in Athena using SQL. To query a preexisting data store with Athena, you must first migrate it to a new data store.
To migrate data to a new data store
-
Create a new data store.
-
Export the data from the pre-existing to an Amazon S3 bucket.
-
Import the data into the new data store from the Amazon S3 bucket.
Exporting data to an Amazon S3 bucket incurs an extra charge. The extra charge depends on the size of the data that you export.
