Query: List video streams with data retention period < 7 days (represented as hours in query)

Description

Determine the areas in which video streams have a data retention period of less than a week. This is useful for identifying potential data loss risks due to short retention periods.

Query

Tables used in this query:

• aws_kinesis_video_stream

SQL