I am working on a real-time streaming application that needs to send information to AWS Kinesis streams and from there to AWS Redshift. Based on my understanding as per the documentation, the following are the option to push information from Kinesis Stream to Redshift:
1. Kinesis Streams -> Lambda Function -> Redshift
2. Kinesis Streams -> Lambda Function -> Kinesis Firehose -> Redshift
3. Kinesis Streams -> Kinesis Connector Library -> Redshift
It seems the Kinesis Connector option to be the best option for moving information from Streams to Redshift. But, I am not able to understand where do we deploy this library and how does this runs? Does this need to run as a lambda function or as a java function on an EC2 instance? In case anyone can help me with this!!