Support Restoring Databases From Backups

[derylseale]

It would be helpful to for the aptible_database resource to be able to create a database from an existing backup. The aws_db_instance resource does this with an optional snapshot_identifier parameter.

Also nice to have would be something like the aws_db_snapshot data source, which can provide details about the latest snapshot, thus making it easy to create a database with the most recent snapshot without having to pass in its identifier.

The use case for these features is to be able to manage ephemeral environments (e.g. qa) that don't need to be running 24/7.

[robertfairhead]

Building out the rest of this functionality is on our roadmap but is not currently in development as we focus on some core performance and security upgrades to the Deploy platform. We will comment on this ticket once something is available. If you have a more urgent need for a solution, please reach out to the the Aptible Support Team to discuss.