steampipe plugin install aws

Table: aws_kinesis_video_stream - Query AWS Kinesis Video Streams using SQL

The AWS Kinesis Video Streams service enables you to securely ingest, process, and store video at any scale for applications that power robots, smart cities, industrial automation, and more. It provides SDKs that you can use to stream video from devices to AWS for playback, storage, analytics, machine learning, and other processing. It also automatically provisions and elastically scales all the infrastructure needed to ingest streaming video data from millions of devices.

Table Usage Guide

The aws_kinesis_video_stream table in Steampipe provides you with information about the Kinesis Video Streams within AWS Kinesis. This table allows you, as a DevOps engineer, to query stream-specific details, including the stream ARN, creation time, status, and more. You can utilize this table to gather insights on streams, such as stream status, data retention period, and the version of the stream. The schema outlines the various attributes of the Kinesis Video Stream for you, including the stream name, ARN, version, status, creation time, and data retention period.

Examples

Basic info

Discover the segments that are currently active in your AWS Kinesis video stream, including their creation times and regions. This can aid in monitoring the status and distribution of your video streams across different regions.

select
stream_name,
stream_arn,
status,
creation_time,
region
from
aws_kinesis_video_stream;
select
stream_name,
stream_arn,
status,
creation_time,
region
from
aws_kinesis_video_stream;

List video streams that are not in Active state

Determine the areas in which video streams are not in an active state. This is beneficial in identifying potential issues or disruptions in your video streaming service.

select
stream_name,
stream_arn,
status,
creation_time,
region
from
aws_kinesis_video_stream
where
status != 'ACTIVE';
select
stream_name,
stream_arn,
status,
creation_time,
region
from
aws_kinesis_video_stream
where
status != 'ACTIVE';

List video streams which are not encrypted using CMK

Identify unencrypted video streams to assess potential security vulnerabilities. This query can be used to pinpoint areas where stronger encryption methods may need to be implemented for improved data protection.

select
stream_name,
stream_arn,
status,
kms_key_id,
creation_time,
region
from
aws_kinesis_video_stream
where
split_part(kms_key_id, ':', 6) = 'alias/aws/kinesisvideo';
select
stream_name,
stream_arn,
status,
kms_key_id,
creation_time,
region
from
aws_kinesis_video_stream
where
substr(kms_key_id, instr(kms_key_id, ':') + 5) = 'alias/aws/kinesisvideo';

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

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.

select
stream_name,
stream_arn,
status,
creation_time,
data_retention_in_hours,
region
from
aws_kinesis_video_stream
where
data_retention_in_hours < 168;
select
stream_name,
stream_arn,
status,
creation_time,
data_retention_in_hours,
region
from
aws_kinesis_video_stream
where
data_retention_in_hours < 168;

Schema for aws_kinesis_video_stream

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_timetimestamp with time zoneA time stamp that indicates when the stream was created.
data_retention_in_hoursbigintHow long the stream retains data, in hours.
device_nametextThe name of the device that is associated with the stream.
kms_key_idtextThe ID of the AWS Key Management Service (AWS KMS) key that Kinesis Video Streams uses to encrypt data on the stream.
media_typetextThe MediaType of the stream.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
statustextThe status of the stream.
stream_arntextThe Amazon Resource Name (ARN) of the stream.
stream_nametext=The name of the stream.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
versiontextThe version of the stream.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_kinesis_video_stream