Skip to main content

inbound_integrations

Creates, updates, deletes, gets or lists an inbound_integrations resource.

Overview

Nameinbound_integrations
TypeResource
Idaws.redshift.inbound_integrations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
create_timestringThe creation time of an inbound integration.
errorsstringThe outstanding errors of an inbound integration. Each item is an "IntegrationError". This is null if there is no error.
integration_arnstringThe Amazon Resource Name (ARN) of an inbound integration.
source_arnstringThe Amazon Resource Name (ARN) of the source of an inbound integration.
statusstringThe status of an inbound integration.
target_arnstringThe Amazon Resource Name (ARN) of the target of an inbound integration.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_inbound_integrationsselectregionIntegrationArn, TargetArn, MaxRecords, MarkerReturns a list of inbound integrations.

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
regionstringAWS region (default: us-east-1)
IntegrationArnstringThe Amazon Resource Name (ARN) of the inbound integration.
MarkerstringAn optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeInboundIntegrations request exceed the value specified in MaxRecords, Amazon Web Services returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.
MaxRecordsintegerThe maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value. Default: 100 Constraints: minimum 20, maximum 100.
TargetArnstringThe Amazon Resource Name (ARN) of the target of an inbound integration.

SELECT examples

Returns a list of inbound integrations.

SELECT
create_time,
errors,
integration_arn,
source_arn,
status,
target_arn
FROM aws.redshift.inbound_integrations
WHERE region = '{{ region }}' -- required
AND IntegrationArn = '{{ IntegrationArn }}'
AND TargetArn = '{{ TargetArn }}'
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;