How to find latest or most recent AWS RDS snapshot?

amazon-web-services command-line-interface snapshot
itchy23 picture itchy23 · Jul 19, 2016 · Viewed 9.9k times · Source

I can call aws rds describe-db-snapshots --db-instance-identifier {my_db_instance} and sort all automated snapshots to find the most recently created one but I was hoping someone has a better idea out there.

Answer

hey picture hey · May 22, 2018

For me, this one works:

aws rds describe-db-snapshots \
  --query="reverse(sort_by(DBSnapshots, &SnapshotCreateTime))[0]"

The query parameter sorts them automatically and returns only the most recent one.

If only the Arn is needed, this one might help:

aws rds describe-db-snapshots \
  --query="reverse(sort_by(DBSnapshots, &SnapshotCreateTime))[0]|DBSnapshotArn" \
  --output text

And all that for a specific database instance:

aws rds describe-db-snapshots \
  --db-instance-identifier={instance identifier} \
  --query="reverse(sort_by(DBSnapshots, &SnapshotCreateTime))[0]|DBSnapshotArn" \
  --output text

Related questions

How do I delete a versioned bucket in AWS S3 using the CLI?

I have tried both s3cmd: $ s3cmd -r -f -v del s3://my-versioned-bucket/ And the AWS CLI: $ aws s3 rm s3://my-versioned-bucket/ --recursive But both of these commands simply add DELETE markers to S3. The command for removing a …

Read More
How to get AWS command line interface to work in cygwin

I installed the AWS command line interface on my Windows 7 box, and it worked immediately when I called commands from a DOS shell. But DOS, the worst language ever invented, is hideous for any serious scripting. So, I would like …

Read More
How to login with AWS CLI using credentials profiles

I want to setup multiple AWS profiles so that I can easily change settings and credentials when jumping between projects. I've read the AWS documentation but it's quite vague about how to select what profile you want to use when …

Read More