Re:Announcing RDS/Aurora Snapshot Export to S3
by etaioinshrdlu on Friday January 24, 2020 @05:05PM
(#22142900)
Can you load that dump using any open source tools outside of AWS and recreate the database identically? Because you can do that with mysqldump.
Re:Announcing RDS/Aurora Snapshot Export to S3
by derision on Friday January 24, 2020 @07:00PM
(#22143529)
I don't think this is meant for recreating the database, but rather exporting large sets for analysis somewhere else. But as far as tools yes, parquet can be parsed by any tool that knows the format. It's not too uncommon
Would have preferred CSV as well, though, easier to work with. There’s also a little known feature called S3 Select that allows you to run SQL on S3 files and selectively retrieve data, which is what Parquet is for in the first place.