Skip to content
AWS for Query.Farm

aws.servicecatalog_appregistry.get_application

Example SQL Queries

SELECT * FROM
aws.servicecatalog_appregistry.get_application
WHERE
"application" = 'VALUE';

Description

Retrieves metadata information about one of your applications. The application can be specified by its ARN, ID, or name (which is unique within one account in one region at a given point in time). Specify by ARN or ID in automated workflows if you want to make sure that the exact same application is returned or a ResourceNotFoundException is thrown, avoiding the ABA addressing problem.

Table Definition

Column NameColumn Data Type
application Required Input Column

The name, ID, or ARN 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_tag

A key-value pair that identifies an associated resource. 

MAP(VARCHAR, VARCHAR)
arn

The Amazon resource name (ARN) that specifies the application across services.

VARCHAR
associated_resource_count

The number of top-level resources that were registered as part of this application.

BIGINT
creation_time

The ISO-8601 formatted timestamp of the moment when the application was created.

TIMESTAMP_S
description

The description of the application.

VARCHAR
id

The identifier of the application.

VARCHAR
integrations

The information about the integration of the application with other services, such as Resource Groups. 

STRUCT(
    "resource_group" STRUCT(
        "state" VARCHAR,
        "arn" VARCHAR,
        "error_message" VARCHAR
    ),
    "application_tag_resource_group" STRUCT(
        "state" VARCHAR,
        "arn" VARCHAR,
        "error_message" VARCHAR
    )
)
Show child fields
integrations.application_tag_resource_group

The information about the resource group integration.

Show child fields
integrations.application_tag_resource_group.arn

The Amazon resource name (ARN) of the resource group.

integrations.application_tag_resource_group.error_message

The error message that generates when the propagation process for the resource group fails.

integrations.application_tag_resource_group.state

The state of the propagation process for the resource group. The states includes:

CREATING if the resource group is in the process of being created.

CREATE_COMPLETE if the resource group was created successfully.

CREATE_FAILED if the resource group failed to be created.

UPDATING if the resource group is in the process of being updated.

UPDATE_COMPLETE if the resource group updated successfully.

UPDATE_FAILED if the resource group could not update successfully.

integrations.resource_group

The information about the resource group integration.

Show child fields
integrations.resource_group.arn

The Amazon resource name (ARN) of the resource group.

integrations.resource_group.error_message

The error message that generates when the propagation process for the resource group fails.

integrations.resource_group.state

The state of the propagation process for the resource group. The states includes:

CREATING if the resource group is in the process of being created.

CREATE_COMPLETE if the resource group was created successfully.

CREATE_FAILED if the resource group failed to be created.

UPDATING if the resource group is in the process of being updated.

UPDATE_COMPLETE if the resource group updated successfully.

UPDATE_FAILED if the resource group could not update successfully.

last_update_time

The ISO-8601 formatted timestamp of the moment when the application was last updated.

TIMESTAMP_S
name

The name of the application. The name must be unique in the region in which you are creating the application.

VARCHAR
tags

Key-value pairs associated with the application.

MAP(VARCHAR, VARCHAR)