1 Answer
- Newest
- Most votes
- Most comments
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
Relevant content
- asked 2 months ago
- asked 2 years ago
- Accepted Answerasked 3 years ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 2 years 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.