steampipe plugin install awssteampipe plugin install aws

Table: aws_kinesis_firehose_delivery_stream

The AWS Kinesis Firehose Delivery Stream resource delivers real-time streaming data to an Amazon Simple Storage Service (Amazon S3), Amazon Redshift or Amazon Elasticsearch Service (Amazon ES) destination.

Examples

Basic info

select
  delivery_stream_name,
  arn,
  create_timestamp,
  delivery_stream_type
from
  aws_kinesis_firehose_delivery_stream;

List inactive delivery streams

select
  delivery_stream_name,
  arn,
  delivery_stream_status,
  create_timestamp,
  delivery_stream_type
from
  aws_kinesis_firehose_delivery_stream
where
  delivery_stream_status != 'ACTIVE';

List delivery streams that are not encrypted

select
  delivery_stream_name,
  arn,
  delivery_stream_status,
  create_timestamp,
  delivery_stream_type,
  delivery_stream_encryption_configuration ->> 'Status' as encryption_status
from
  aws_kinesis_firehose_delivery_stream
where
  delivery_stream_encryption_configuration ->> 'Status' = 'DISABLED';

List delivery streams for a specific delivery stream type

select
  delivery_stream_name,
  arn,
  delivery_stream_status,
  create_timestamp,
  delivery_stream_type
from
  aws_kinesis_firehose_delivery_stream
where
  delivery_stream_type = 'DirectPut';

List delivery streams with at least one failure

select
  delivery_stream_name,
  arn,
  delivery_stream_status,
  delivery_stream_type,
  failure_description
from
  aws_kinesis_firehose_delivery_stream
where
  failure_description is not null;

Control examples

.inspect aws_kinesis_firehose_delivery_stream

AWS Kinesis Firehose Delivery Stream

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) of the delivery stream.
create_timestamp	timestamp with time zone	The date and time that the delivery stream was created.
delivery_stream_encryption_configuration	jsonb	Indicates the server-side encryption (SSE) status for the delivery stream.
delivery_stream_name	text	The name of the delivery stream.
delivery_stream_status	text	The server-side encryption type used on the stream.
delivery_stream_type	text	The delivery stream type.
destinations	jsonb	The destinations for the stream.
failure_description	jsonb	Provides details in case one of the following operations fails due to an error related to KMS: CreateDeliveryStream, DeleteDeliveryStream, StartDeliveryStreamEncryption,StopDeliveryStreamEncryption.
has_more_destinations	boolean	Indicates whether there are more destinations available to list.
last_update_timestamp	timestamp with time zone	The date and time that the delivery stream was last updated.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
source	jsonb	If the DeliveryStreamType parameter is KinesisStreamAsSource, a SourceDescription object describing the source Kinesis data stream.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags associated with the delivery stream.
title	text	Title of the resource.
version_id	text	The version id of the stream. Each time the destination is updated for a delivery stream, the version ID is changed, and the current version ID is required when updating the destination

turbot/aws