Kafka to Redshift

If you are looking for AWS native server-less solution then use Glue ETL for streaming. https://aws.amazon.com/blogs/aws/new-serverless-streaming-etl-with-aws-glue/ This new feature lets you connect MSK to Redshift using AWS Glue. The auto-populated Glue Job will have take care of mapping and creating table in to the target Redshift. Let me know if you need help with configuration.