Create an delivery stream
To create an Firehose delivery stream for delivering Amazon SNS notifications to Amazon Redshift
-
Start by following the procedures in Creating an Firehose delivery stream in the Amazon Data Firehose Developer Guide.
-
On the Choose a destination page in Firehose, choose Amazon Redshift.
-
Using the Choose Amazon Redshift for your destination section for reference, complete the fields up to the COPY fields.
-
For COPY options, paste the following:
{ "jsonpaths": [ "$.Type", "$.MessageId", "$.TopicArn", "$.Subject", "$.Timestamp", "$.UnsubscribeURL" ] } -
Choose Next and finish creating the delivery stream.
You've created the Firehose delivery stream. To continue, return to the Task overview.