Explore the dynamic process of streaming data ingestion into Apache Pinot, which is essential for handling real-time data scenarios. Understand how Pinot seamlessly integrates with streaming sources like Kafka and Amazon Kinesis, creating a direct link between these platforms and Pinot tables. This detailed explanation covers the journey of streaming data from ingestion to queryable state, emphasizing the continuous consumption of data, segment creation, and the crucial roles of consuming segments, servers, and controllers in maintaining data freshness and availability.