I have set up a Firehose and selected options that it seemed would result in the streamed data to end up in Redshift. I have a single Firehose and a single target table in Redshift. The data is showing up correctly in the intermediate S3 bucket but not making it to Redshift.
I have allowed the Firehose region CIDR's  access to the cluster via Redshift security groups. I have given the Firehose the credentials to the Redshift cluster and have tested the credentials. The cluster is publicly accessible.
STL_LOAD_ERRORS table is empty which is where I would expect to see the errors produced by any copy statement that was attempted and failed. There are also no
DeliveryToRedshift events in CloudWatch. This leads me to believe that there isn't even an attempt making it to Redshift.
I am using Redshift COPY options to specify a jsonpath file for the copy. I currently have:
json "s3://app-event-data/_jsonpaths/_bigtable.jsonpath.json". That file exists in s3 at that location and looks like the jsonpath file . I also tried adding credentials to that box but I don't that is necessary.
I enabled logging in Redshift which showed me that there are successful authentications being made from Firehose. I then created a new parameter group with user activity logging enabled and rebooted the cluster. Waiting for the next log batch now.
Why ServerFault? Best StackExchange site for asking about Amazon AWS
I would have tagged this question: amazon-kinesis amazon-firehose amazon-redshift