The file format of aws rds snapshots to s3 is Apache Parquet https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html
Does anyone know if that can be restored to a local version of mysql
If it’s exported as parquet, probably not meant as a backup. I don’t think you can restore it back.
To restore, it has to be under a DB snapshot format.
But at least you have the data to query using Athena, hope that helps.
We want to test schema migration changes
And therefore would like to restore the snapshot on a local version of mysql to test the schema changes before applying it to produciton
Deploy a second rds from a snapshot and test the migration there?
