Skip to main content

certificates

Creates, updates, deletes or gets a certificate resource or lists certificates in a region

Overview

Namecertificates
TypeResource
DescriptionResource Type definition for AWS::Transfer::Certificate
Idawscc.transfer.certificates

Fields

NameDatatypeDescription
usagestringSpecifies the usage type for the certificate.
certificatestringSpecifies the certificate body to be imported.
certificate_chainstringSpecifies the certificate chain to be imported.
private_keystringSpecifies the private key for the certificate.
active_datestringSpecifies the active date for the certificate.
inactive_datestringSpecifies the inactive date for the certificate.
descriptionstringA textual description for the certificate.
tagsarrayKey-value pairs that can be used to group and search for certificates. Tags are metadata attached to certificates for any purpose.
arnstringSpecifies the unique Amazon Resource Name (ARN) for the agreement.
certificate_idstringA unique identifier for the certificate.
statusstringA status description for the certificate.
typestringDescribing the type of certificate. With or without a private key.
serialstringSpecifies Certificate's serial.
not_before_datestringSpecifies the not before date for the certificate.
not_after_datestringSpecifies the not after date for the certificate.
regionstringAWS region.

For more information, see AWS::Transfer::Certificate.

Methods

NameResourceAccessible byRequired Params
create_resourcecertificatesINSERTCertificate, Usage, region
delete_resourcecertificatesDELETEIdentifier, region
update_resourcecertificatesUPDATEIdentifier, PatchDocument, region
list_resourcescertificates_list_onlySELECTregion
get_resourcecertificatesSELECTIdentifier, region

SELECT examples

Gets all properties from an individual certificate.

SELECT
region,
usage,
certificate,
certificate_chain,
private_key,
active_date,
inactive_date,
description,
tags,
arn,
certificate_id,
status,
type,
serial,
not_before_date,
not_after_date
FROM awscc.transfer.certificates
WHERE
region = 'us-east-1' AND
Identifier = '{{ certificate_id }}';

INSERT example

Use the following StackQL query and manifest file to create a new certificate resource, using stack-deploy.

/*+ create */
INSERT INTO awscc.transfer.certificates (
Usage,
Certificate,
region
)
SELECT
'{{ usage }}',
'{{ certificate }}',
'{{ region }}';

UPDATE example

Use the following StackQL query and manifest file to update a certificate resource, using stack-deploy.

/*+ update */
UPDATE awscc.transfer.certificates
SET PatchDocument = string('{{ {
"Usage": usage,
"ActiveDate": active_date,
"InactiveDate": inactive_date,
"Description": description,
"Tags": tags
} | generate_patch_document }}')
WHERE
region = '{{ region }}' AND
Identifier = '{{ certificate_id }}';

DELETE example

/*+ delete */
DELETE FROM awscc.transfer.certificates
WHERE
Identifier = '{{ certificate_id }}' AND
region = 'us-east-1';

Permissions

To operate on the certificates resource, the following permissions are required:

transfer:ImportCertificate,
transfer:TagResource