Skip to main content
Version: 0.0.25

Table: certificate

Table to query for all AWS certificates in the system, managed by AWS ACM. AWS Certificate Manager (ACM) handles the complexity of creating, storing, and renewing public and private SSL/TLS X.509 certificates and keys that protect your AWS websites and applications.

This table is used to list the existing certificates and be able to delete them. Certificates can be created or imported by using the following postgres functions:

See

Example

  SELECT * FROM certificate WHERE domain_name = 'domain.com';

Columns

Optional arn: string

ARN for the generated certificate

Optional certificate_id: string

AWS generated ID for the certificate

Optional certificate_type: certificate_type

Type of certificate

domain_name: string

Domain name to which the certificate was issued

in_use: boolean

Specifies if the certificate is already in use

region: string

Region for the certificate creation

Optional renewal_eligibility: certificate_renewal_eligibility

Specifies if the certificate can be renewed or not

Optional status: certificate_status

Status of the certificate