Skip to content
AWS for Query.Farm

aws.m2.get_application

Example SQL Queries

SELECT * FROM
aws.m2.get_application
WHERE
"application_id" = 'VALUE';

Description

Describes the details of a specific application.

Table Definition

Column NameColumn Data Type
application_id Required Input Column

The identifier of the application.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
application_arn

The Amazon Resource Name (ARN) of the application.

VARCHAR
creation_time

The timestamp when this application was created.

TIMESTAMP_S
deployed_version

The version of the application that is deployed.

STRUCT(
    "application_version" BIGINT,
    "status" VARCHAR,
    "status_reason" VARCHAR
)
Show child fields
deployed_version.application_version

The version of the deployed application.

deployed_version.status

The status of the deployment.

deployed_version.status_reason

The reason for the reported status.

description

The description of the application.

VARCHAR
engine_type

The type of the target platform for the application.

VARCHAR
environment_id

The identifier of the runtime environment where you want to deploy the application.

VARCHAR
kms_key_id

The identifier of a customer managed key.

VARCHAR
last_start_time

The timestamp when you last started the application. Null until the application runs for the first time.

TIMESTAMP_S
latest_version

The latest version of the application.

STRUCT(
    "application_version" BIGINT,
    "creation_time" TIMESTAMP_S,
    "status" VARCHAR,
    "status_reason" VARCHAR
)
Show child fields
latest_version.application_version

The application version.

latest_version.creation_time

The timestamp when the application version was created.

latest_version.status

The status of the application.

latest_version.status_reason

The reason for the reported status.

listener_arns

The Amazon Resource Name (ARN) for the network load balancer listener created in your Amazon Web Services account. Amazon Web Services Mainframe Modernization creates this listener for you the first time you deploy an application.

VARCHAR[]
Show child fields
listener_arns[]
listener_ports

The port associated with the network load balancer listener created in your Amazon Web Services account.

BIGINT[]
Show child fields
listener_ports[]
load_balancer_dns_name

The public DNS name of the load balancer created in your Amazon Web Services account.

VARCHAR
log_groups

The list of log summaries. Each log summary includes the log type as well as the log group identifier. These are CloudWatch logs. Amazon Web Services Mainframe Modernization pushes the application log to CloudWatch under the customer's account.

STRUCT(
    "log_group_name" VARCHAR,
    "log_type" VARCHAR
)[]
Show child fields
log_groups[]
Show child fields
log_groups[].log_group_name

The name of the log group.

log_groups[].log_type

The type of log.

name

The unique identifier of the application.

VARCHAR
role_arn

The Amazon Resource Name (ARN) of the role associated with the application.

VARCHAR
status

The status of the application.

VARCHAR
status_reason

The reason for the reported status.

VARCHAR
tags

A list of tags associated with the application.

MAP(VARCHAR, VARCHAR)
target_group_arns

Returns the Amazon Resource Names (ARNs) of the target groups that are attached to the network load balancer.

VARCHAR[]
Show child fields
target_group_arns[]