Skip to main content

custom_domain_associations

Creates, updates, deletes, gets or lists a custom_domain_associations resource.

Overview

Namecustom_domain_associations
TypeResource
Idaws.redshift.custom_domain_associations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
certificate_associationsstringA list of all associated clusters and domain names tied to a specific certificate.
custom_domain_certificate_arnstringThe Amazon Resource Name (ARN) for the certificate associated with the custom domain.
custom_domain_certificate_expiry_datestringThe expiration date for the certificate.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_custom_domain_associationsselectregionCustomDomainName, CustomDomainCertificateArn, MaxRecords, MarkerContains information about custom domain associations for a cluster.
create_custom_domain_associationinsertCustomDomainName, CustomDomainCertificateArn, ClusterIdentifier, regionUsed to create a custom domain name for a cluster. Properties include the custom domain name, the cluster the custom domain is associated with, and the certificate Amazon Resource Name (ARN).
modify_custom_domain_associationupdateCustomDomainName, CustomDomainCertificateArn, ClusterIdentifier, regionContains information for changing a custom domain association.
delete_custom_domain_associationdeleteClusterIdentifier, CustomDomainName, regionContains information about deleting a custom domain association for a cluster.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
ClusterIdentifierstringThe identifier of the cluster to delete a custom domain association for.
CustomDomainCertificateArnstringThe certificate Amazon Resource Name (ARN) for the changed custom domain association.
CustomDomainNamestringThe custom domain name for the custom domain association.
regionstringAWS region (default: us-east-1)
CustomDomainCertificateArnstringThe certificate Amazon Resource Name (ARN) for the custom domain association.
CustomDomainNamestringThe custom domain name for the custom domain association.
MarkerstringThe marker for the custom domain association.
MaxRecordsintegerThe maximum records setting for the associated custom domain.

SELECT examples

Contains information about custom domain associations for a cluster.

SELECT
certificate_associations,
custom_domain_certificate_arn,
custom_domain_certificate_expiry_date
FROM aws.redshift.custom_domain_associations
WHERE region = '{{ region }}' -- required
AND CustomDomainName = '{{ CustomDomainName }}'
AND CustomDomainCertificateArn = '{{ CustomDomainCertificateArn }}'
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;

INSERT examples

Used to create a custom domain name for a cluster. Properties include the custom domain name, the cluster the custom domain is associated with, and the certificate Amazon Resource Name (ARN).

INSERT INTO aws.redshift.custom_domain_associations (
CustomDomainName,
CustomDomainCertificateArn,
ClusterIdentifier,
region
)
SELECT
'{{ CustomDomainName }}',
'{{ CustomDomainCertificateArn }}',
'{{ ClusterIdentifier }}',
'{{ region }}'
RETURNING
cluster_identifier,
custom_domain_cert_expiry_time,
custom_domain_certificate_arn,
custom_domain_name
;

UPDATE examples

Contains information for changing a custom domain association.

UPDATE aws.redshift.custom_domain_associations
SET
-- No updatable properties
WHERE
CustomDomainName = '{{ CustomDomainName }}' --required
AND CustomDomainCertificateArn = '{{ CustomDomainCertificateArn }}' --required
AND ClusterIdentifier = '{{ ClusterIdentifier }}' --required
AND region = '{{ region }}' --required
RETURNING
cluster_identifier,
custom_domain_cert_expiry_time,
custom_domain_certificate_arn,
custom_domain_name;

DELETE examples

Contains information about deleting a custom domain association for a cluster.

DELETE FROM aws.redshift.custom_domain_associations
WHERE ClusterIdentifier = '{{ ClusterIdentifier }}' --required
AND CustomDomainName = '{{ CustomDomainName }}' --required
AND region = '{{ region }}' --required
;