Athena Datasource backup

Question

Question from customer :Is there a way to backup an athena datasource without backing up each views? is snapshotting an option. From my research, the only options from this repost is to download the query files- https://repost.aws/knowledge-center/access-download-athena-query-results and https://docs.aws.amazon.com/athena/latest/ug/querying.html#query-results-specify-location

Didier_Durand · Answer

Hi,

Athena's documentation clearly suggests to use S3 mechanisms for the backup of data:

See https://docs.aws.amazon.com/athena/latest/ug/security-resilience.html

```
Athena uses Amazon S3 as its underlying data store, making your data highly available 
and durable. Amazon S3 provides durable infrastructure to store important data and 
is designed for durability of 99.999999999% of objects. Your data is redundantly stored 
across multiple facilities and multiple devices in each facility.
```

So, AWS Backup for S3 is probably the most efficient way to save your Athena data: https://docs.aws.amazon.com/aws-backup/latest/devguide/s3-backups.html

Best,

Didier

Riku_Kobayashi · Answer

Hello.

How about setting up S3 versioning?  
By configuring versioning settings, you can recover from an older version even if you accidentally delete an object.  
https://docs.aws.amazon.com/AmazonS3/latest/userguide/Versioning.html

You can also use AWS Backup with S3, so I think it's a good idea to check that.  
https://docs.aws.amazon.com/aws-backup/latest/devguide/s3-backups.html

Athena Datasource backup

Relevant content