Skip to main content

integrations_list_only

Lists integrations in a region or regions, for all properties use integrations

Overview

Nameintegrations_list_only
TypeResource
DescriptionCreates a zero-ETL integration with Amazon Redshift.
Idaws.rds.integrations_list_only

Fields

NameDatatypeDescription
integration_namestringThe name of the integration.
descriptionstringThe description of the integration.
tagsarrayAn array of key-value pairs to apply to this resource.
data_filterstringThe data filter for the integration.
source_arnstringThe Amazon Resource Name (ARN) of the Aurora DB cluster to use as the source for replication.
target_arnstringThe ARN of the Redshift data warehouse to use as the target for replication.
integration_arnstringThe ARN of the integration.
kms_key_idstringAn optional AWS Key Management System (AWS KMS) key ARN for the key used to to encrypt the integration. The resource accepts the key ID and the key ARN forms. The key ID form can be used if the KMS key is owned by te same account. If the KMS key belongs to a different account than the calling account, the full key ARN must be specified. Do not use the key alias or the key alias ARN as this will cause a false drift of the resource.
additional_encryption_contextobjectAn optional set of non-secret key–value pairs that contains additional contextual information about the data.
create_timestring
regionstringAWS region.

Methods

NameAccessible byRequired Params
list_resourcesSELECTregion

SELECT examples

Lists all integrations in a region.

SELECT
region,
integration_arn
FROM aws.rds.integrations_list_only
WHERE region = 'us-east-1';

Permissions

For permissions required to operate on the integrations_list_only resource, see integrations