By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Firehose destination error

0

Trying to ingest data from kinesis stream to redshift using firehose delivery stream. VPC is made publicly accessible and added IP address of firehose to inbound rules in security groups (modifield later). Still Getting following error : The connection to the specified Amazon Redshift cluster failed. Ensure that security settings allow Firehose connections, that the cluster or database specified in the Amazon Redshift destination configuration or JDBC URL is correct, and that the cluster is available.

Topics
ServerlessAnalyticsDatabaseInternet of Things (IoT)
Tags
ServerlessAmazon Data FirehoseDatabaseAmazon RedshiftAmazon Kinesis
Language
English
Vanishree
asked 14 days ago109 views
1 Answer
1

Hello, is the data delivered to your S3 bucket from Kinesis Data Firehose?

Can you check the metric DeliveryToRedshift.Success metric in CloudWatch to ensure Firehose is trying to copy data from S3 to Redshift?

Check also the IAM role assigned to Firehose towards the Redshift.

Have a look at this document depicting various use cases on this error. https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-refusal-failure-issues.html

profile picture
EXPERT
Giovanni Lauria
answered 14 days ago
  • Vanishree
    13 days ago

    I can see the data in S3 bucket(files for each minute). Delivery to redshift success seems 0. IAM role assigned seems to have necessary permissions and i have also unblocked firehose IP address in firewall.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content