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
    Try the sample pipeline yourself at
    Read about managing the lifecycle of your snapshot exports in S3 at

    More AWS videos
    More AWS events videos

    #AWS #AWSDemo


    Previous articleAWS Elastic load Balancer Part-4 | AWS ELB | What is aws elastic Load Balancer | AWS ALB vs NLB
    Next articleHow to Connect AWS to External Relational Database Services RDS (SQL electron).


    1. 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

    2. 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.

    3. 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?

    4. 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.