Amazon RDS Snapshot Export to S3



In this demo, we’ll see how we can export Amazon RDS snapshots to Amazon S3, run queries on them using Amazon Athena, and automate the entire process using RDS event notifications and AWS Lambda. Snapshot exports enable us to make use of our data in a number of different ways without sacrificing the performance of our database or needing to scale it up to handle the increased load!

Learn more in the Amazon RDS documentation at https://amzn.to/347Ox8h
Try the sample pipeline yourself at https://bit.ly/3aHmcrN
Read about managing the lifecycle of your snapshot exports in S3 at https://amzn.to/3bMmSfJ

Subscribe:
More AWS videos http://bit.ly/2O3zS75
More AWS events videos http://bit.ly/316g9t4

#AWS #AWSDemo

source

24 thoughts on “Amazon RDS Snapshot Export to S3”
  1. Thank you fo r the video, as per the partial export, do we mention only the name of the table followed by a space or we need to write: database.schema.table ?

  2. Excellent tutorial. Before I implement this, I want to know I'll be able to do the reverse. Restoring the files on S3 to become a new database instance. Any reference for that?

  3. Is there no way to automatically send nightly RDS snapshots to AWS S3? Only see the manual action in the AWS console.

  4. Wow I'm so glad I met N. 1hacker page on Instagram for my Amazon account recovery 🙂

  5. Even after watching this video I couldn’t still recover my account but Genuis_Tech via inštàgräm was able to do that for me

  6. Thanks a lot, @AWS, I have wasted my whole day to learn to export to S3 but this video done my work in just 3 minutes 😀 :))))))

  7. I have exported RDS snapshot to S3 in parquet format but my dates have been changed to BIGINT data type and getting same BIGINT value while querying from Athena. Could you please suggest why I'm getting date in different format as in your tutorial you're getting correct date. Date format in RDS Aurora mySQL is – 2020-04-14 13:30:37

  8. I am attempting to follow this video and was having similar issues to other users with a Postgres RDS instance – I did not see the option to Export to S3. Is it possible for me to use the AWS CLI to accomplish this task?

  9. Actually dont work, the function is sucessfuly created in Lambda, the bucket is created as well, the KMS key too, even the export task call function… but nothing happends after snapshot created, no export task to S3 in the scope, something the video is missing something… i guess. Any feedback will help me.

  10. I tried following this tutorial but am having some trouble. I am trying to take a snapshot of an PostgreSQL 11.6 RDS instance in us-east-1 and select the "Export to Amazon S3", however, that option is greyed out and I am unable to click it. Any suggestions?

  11. I wanted to follow this tutorial but I am missing the Export to S3 option. Do I need some set up to execute this tutorial or am I restricted by something? I am currently using an Postgres 12 RDS instance on a fresh account with no further set up.

  12. Easy to understand. keep making these types of videos. I will definitely suggest this use-case to my organisation's CTO.

Leave a Reply

Your email address will not be published.

Captcha loading...