Query: List delivery streams with at least one failure

Description

Identify instances where delivery streams have experienced at least one failure. This is useful for diagnosing issues and ensuring reliable data delivery within AWS Kinesis.

Query

Tables used in this query:

• aws_kinesis_firehose_delivery_stream

SQL