MR.QUESTION
Reputation: 359
Copy tables and views from Athena
Hi I need to copy tables and views from one Athena instance to another (I'm not using Glue). How to do this via AWS Console or via boto3/pyathena api without loosing any data? Cant find anything in documentation :(
Upvotes: 0
Views: 1049
Answers (1)
AswinRajaram
Reputation: 1622
Athena tables are built on top of files stored on S3. If you need the data, you will have to export the data.
Upvotes: 1
Related Questions
- saving athena results to another table with partitions
- Importing data from AWS Athena to RDS instance
- Export athena table to S3 as one readable file
- How to access AWS Athena tables from another account
- Ways to backup AWS Athena views
- Load Athena output into Athena table
- How to directly copy Amazon Athena tables into Amazon Redshift?
- Create/update Amazon Athena tables from Amazon S3 bucket files
- Amazon Athena export compressed query (table)
- Creating Table As substitution