steampipe plugin install aws

Table: aws_kinesisanalyticsv2_application - Query AWS Kinesis Analytics Applications using SQL

The AWS Kinesis Analytics Applications is a feature of Amazon Kinesis Data Analytics service. It enables you to process and analyze streaming data using standard SQL queries. This service is ideal for scenarios such as real-time analytics on streaming data, alerts, and dynamic pricing.

Table Usage Guide

The aws_kinesisanalyticsv2_application table in Steampipe provides you with information about applications within AWS Kinesis Analytics. This table allows you, as a DevOps engineer, to query application-specific details, including the application name, ARN, description, status, runtime environment, and more. You can utilize this table to gather insights on applications, such as the application's creation time, last update time, and the application version. The schema outlines the various attributes of the Kinesis Analytics application for you, including the application ARN, creation time, last update time, application version, and associated tags.

Examples

Basic info

Explore which applications are running in your AWS Kinesis Analytics environment to assess their status and understand their configuration. This is particularly useful for auditing purposes or when troubleshooting issues within your environment.

select
application_name,
application_arn,
application_version_id,
application_status,
application_description,
service_execution_role,
runtime_environment
from
aws_kinesisanalyticsv2_application;
select
application_name,
application_arn,
application_version_id,
application_status,
application_description,
service_execution_role,
runtime_environment
from
aws_kinesisanalyticsv2_application;

List applications with multiple versions

Determine the areas in which applications are running multiple versions to assess potential inconsistencies or upgrade needs within your AWS Kinesis Analytics setup.

select
application_name,
application_version_id,
application_arn,
application_status
from
aws_kinesisanalyticsv2_application
where
application_version_id > 1;
select
application_name,
application_version_id,
application_arn,
application_status
from
aws_kinesisanalyticsv2_application
where
application_version_id > 1;

List applications with a SQL runtime environment

Identify applications operating in a SQL runtime environment to understand their status and performance. This is useful for assessing the state of your applications and ensuring they are functioning as expected.

select
application_name,
runtime_environment,
application_arn,
application_status
from
aws_kinesisanalyticsv2_application
where
runtime_environment = 'SQL-1_0';
select
application_name,
runtime_environment,
application_arn,
application_status
from
aws_kinesisanalyticsv2_application
where
runtime_environment = 'SQL-1_0';

Schema for aws_kinesisanalyticsv2_application

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.
application_arntextThe ARN of the application.
application_configuration_descriptionjsonbProvides details about the application's Java, SQL, or Scala code and starting parameters.
application_descriptiontextThe description of the application.
application_nametext=The name of the application.
application_statustextThe status of the application.
application_version_idbigintProvides the current application version.
cloud_watch_logging_option_descriptionsjsonbDescribes the application Amazon CloudWatch logging options.
create_timestamptimestamp with time zoneThe current timestamp when the application was created.
last_update_timestamptimestamp with time zoneThe current timestamp when the application was last updated.
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.
runtime_environmenttextThe runtime environment for the application.
service_execution_roletextSpecifies the IAM role that the application uses to access external resources.
tagsjsonbA map of tags for the resource.
tags_srcjsonbThe key-value tags assigned to the application.
titletextTitle of the resource.

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_kinesisanalyticsv2_application