AWS CloudFormation
User Guide (Version )

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

AWS::KinesisFirehose::DeliveryStream RedshiftDestinationConfiguration

The RedshiftDestinationConfiguration property type specifies an Amazon Redshift cluster to which Amazon Kinesis Data Firehose (Kinesis Data Firehose) delivers data.

Syntax

To declare this entity in your AWS CloudFormation template, use the following syntax:

Properties

CloudWatchLoggingOptions

The CloudWatch logging options for your delivery stream.

Required: No

Type: CloudWatchLoggingOptions

Update requires: No interruption

ClusterJDBCURL

The connection string that Kinesis Data Firehose uses to connect to the Amazon Redshift cluster.

Required: Yes

Type: String

Minimum: 1

Pattern: jdbc:(redshift|postgresql)://((?!-)[A-Za-z0-9-]{1,63}(?<!-)\.)+redshift\.([a-zA-Z0-9\.]+):\d{1,5}/[a-zA-Z0-9_$]+

Update requires: No interruption

CopyCommand

Configures the Amazon Redshift COPY command that Kinesis Data Firehose uses to load data into the cluster from the Amazon S3 bucket.

Required: Yes

Type: CopyCommand

Update requires: No interruption

Password

The password for the Amazon Redshift user that you specified in the Username property.

Required: Yes

Type: String

Minimum: 6

Update requires: No interruption

ProcessingConfiguration

The data processing configuration for the Kinesis Data Firehose delivery stream.

Required: No

Type: ProcessingConfiguration

Update requires: No interruption

RoleARN

The ARN of the AWS Identity and Access Management (IAM) role that grants Kinesis Data Firehose access to your Amazon S3 bucket and AWS KMS (if you enable data encryption). For more information, see Grant Kinesis Data Firehose Access to an Amazon Redshift Destination in the Amazon Kinesis Data Firehose Developer Guide.

Required: Yes

Type: String

Minimum: 1

Maximum: 512

Pattern: arn:.*

Update requires: No interruption

S3Configuration

The S3 bucket where Kinesis Data Firehose first delivers data. After the data is in the bucket, Kinesis Data Firehose uses the COPY command to load the data into the Amazon Redshift cluster. For the Amazon S3 bucket's compression format, don't specify SNAPPY or ZIP because the Amazon Redshift COPY command doesn't support them.

Required: Yes

Type: S3DestinationConfiguration

Update requires: No interruption

Username

The Amazon Redshift user that has permission to access the Amazon Redshift cluster. This user must have INSERT privileges for copying data from the Amazon S3 bucket to the cluster.

Required: Yes

Type: String

Minimum: 1

Update requires: No interruption

On this page: