Firehose destination error

Question

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.

Answer

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

Firehose destination error

관련 콘텐츠