Amazon Redshift streaming ingestion is a native feature designed for low-latency, high-speed data ingestion directly from Amazon Kinesis Data Streams. This solution has the least operational overhead because it is a fully managed process within Redshift. The user only needs to create an external schema pointing to the Kinesis stream and a materialized view to consume the data. Redshift then automatically and continuously ingests data in the background, making it available for querying in seconds. This directly meets the requirements for real-time queries and minimal management effort.

1. Amazon Redshift Database Developer Guide

"Streaming ingestion for Amazon Redshift": This guide states

"Amazon Redshift streaming ingestion provides low-latency

high-speed ingestion of streaming data from Amazon Kinesis Data Streams... into an Amazon Redshift materialized view... You can get started with streaming ingestion in minutes." This confirms it is a low-latency

low-overhead

native solution.

2. Amazon Redshift Database Developer Guide

"CREATE MATERIALIZED VIEW": The documentation for creating a materialized view from an external source like Kinesis states

"Amazon Redshift automatically refreshes the materialized view with the latest data from the streaming ingestion external table." This highlights the minimal operational overhead.

3. Amazon Data Firehose Developer Guide

"Choosing Amazon Redshift for Your Destination": This document explains the Firehose to Redshift process: "Amazon Data Firehose first delivers your incoming data to your S3 bucket... Then

Amazon Data Firehose issues an Amazon Redshift COPY command to load data...". This confirms the use of an intermediate S3 bucket and a batch COPY command

which is less direct and has higher latency than native streaming.

4. Amazon Managed Service for Apache Flink Developer Guide

"Sinks": The official documentation lists available sinks for Flink applications

which include Amazon S3

Amazon Kinesis Data Streams

Amazon Kinesis Data Firehose

and Amazon OpenSearch Service

but not a direct sink for Amazon Redshift.