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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
application_arn	text		The ARN of the application.
application_configuration_description	jsonb		Provides details about the application's Java, SQL, or Scala code and starting parameters.
application_description	text		The description of the application.
application_maintenance_configuration_description	jsonb		The details of the maintenance configuration for the application.
application_mode	text		To create a Managed Service for Apache Flink Studio notebook, you must set the mode to INTERACTIVE.
application_name	text	=	The name of the application.
application_status	text		The status of the application.
application_version_id	bigint		Provides the current application version.
application_version_rolled_back_from	bigint		If you reverted the application using RollbackApplication , the application version when RollbackApplication was called.
application_version_rolled_back_to	bigint		The version to which you want to roll back the application.
application_version_updated_from	bigint		The previous application version before the latest application update.
cloud_watch_logging_option_descriptions	jsonb		Describes the application Amazon CloudWatch logging options.
conditional_token	text		A value you use to implement strong concurrency for application updates.
create_timestamp	timestamp with time zone		The current timestamp when the application was created.
last_update_timestamp	timestamp with time zone		The current timestamp when the application 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.
runtime_environment	text		The runtime environment for the application.
service_execution_role	text		Specifies the IAM role that the application uses to access external resources.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		The key-value tags assigned to the application.
title	text		Title 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