Another option to stream data into Redshift is to stream data to Kinesis.
You can configure streaming ingestion for your Amazon Redshift cluster and create a materialized view using SQL statements.You can follow the guide from AWS to set it up.Or you can follow the steps below to set up the materialized view.
Create an IAM Role which has the policies AmazonKinesisReadOnlyAccess and AmazonRedshiftFullAccess.
Go to the Redshift cluster’s Properties tab. In the Cluster permissions section, attach the IAM role to the Redshift cluster.