New Data Source: aws_rds_certificate

[bflad]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

RDS Certificates differ between AWS Commercial and GovCloud (US):

        {
            "CertificateIdentifier": "rds-ca-2019",
            "CertificateType": "CA",
            "Thumbprint": "c8de1d13ad359b3dea182adcb4796d2247753c4a",
            "ValidFrom": "2019-09-16T18:21:15+00:00",
            "ValidTill": "2024-08-22T17:08:50+00:00",
            "CertificateArn": "arn:aws:rds:us-west-2::cert:rds-ca-2019",
            "CustomerOverride": false
        }

        {
            "CertificateIdentifier": "rds-ca-2017",
            "CertificateType": "CA",
            "Thumbprint": "77558cc45e711f1b57e3da6e5b7427124ee869e8",
            "ValidFrom": "2017-05-19T22:31:19+00:00",
            "ValidTill": "2022-05-18T12:00:00+00:00",
            "CertificateArn": "arn:aws-us-gov:rds:us-gov-west-1::cert:rds-ca-2017"
        }

Thumbprints also differ between regions. This difference causes failures in our hardcoded test configurations:

=== CONT  TestAccAWSDBInstance_CACertificateIdentifier
TestAccAWSDBInstance_CACertificateIdentifier: resource_aws_db_instance_test.go:2991: Step 1/1 error: terraform failed: exit status 1
stderr:
Error: error modifying DB Instance (terraform-20200918073750038000000001): CertificateNotFound: Certificate not found: rds-ca-2019
  status code: 404, request id: 61e06444-7f68-472c-b97d-a0fff6c6974e
--- FAIL: TestAccAWSDBInstance_CACertificateIdentifier (508.55s)

We can support a new data source to lookup this information. 👍 It looks like the other RDS-backed services are also beginning to support this type of lookup, but those can have their own tracking issues.

New Data Source

• aws_rds_certificate

Potential Terraform Configuration

data "aws_rds_certificate" "test" {
  most_recent = true
}

resource "aws_db_instance" "test" {
  # ... other configuration ...

  ca_cert_identifier  = data.aws_rds_certificate.test.id
}

References

• RDS API Reference

[bflad]

Support for this new data source has been merged and will release with version 3.12.0 of the Terraform AWS Provider, likely later today.

[ghost]

This has been released in version 3.12.0 of the Terraform AWS provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading.

For further feature requests or bug reports with this functionality, please create a new GitHub issue following the template for triage. Thanks!

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. Thanks!