Skip to content
AWS for Query.Farm

aws.datazone.get_subscription_request_details

Example SQL Queries

SELECT * FROM
aws.datazone.get_subscription_request_details
WHERE
"domain_identifier" = 'VALUE'
AND "identifier" = 'VALUE';

Description

Gets the details of the specified subscription request.

Table Definition

Column NameColumn Data Type
domain_identifier Required Input Column

The identifier of the Amazon DataZone domain in which to get the subscription request details.

VARCHAR
identifier Required Input Column

The identifier of the subscription request the details of which to get.

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
created_at

The timestamp of when the specified subscription request was created.

TIMESTAMP_S
created_by

The Amazon DataZone user who created the subscription request.

VARCHAR
decision_comment

The decision comment of the subscription request.

VARCHAR
domain_id

The Amazon DataZone domain of the subscription request.

VARCHAR
id

The identifier of the subscription request.

VARCHAR
request_reason

The reason for the subscription request.

VARCHAR
reviewer_id

The identifier of the Amazon DataZone user who reviewed the subscription request.

VARCHAR
status

The status of the subscription request.

VARCHAR
subscribed_listings

The subscribed listings in the subscription request.

STRUCT(
    "description" VARCHAR,
    "id" VARCHAR,
    "item" STRUCT(
        "asset_listing" STRUCT(
            "entity_id" VARCHAR,
            "entity_revision" VARCHAR,
            "entity_type" VARCHAR,
            "forms" VARCHAR,
            "glossary_terms" STRUCT(
                "name" VARCHAR,
                "short_description" VARCHAR
            )[]
        ),
        "product_listing" STRUCT(
            "asset_listings" STRUCT(
                "entity_id" VARCHAR,
                "entity_revision" VARCHAR,
                "entity_type" VARCHAR
            )[],
            "description" VARCHAR,
            "entity_id" VARCHAR,
            "entity_revision" VARCHAR,
            "glossary_terms" STRUCT(
                "name" VARCHAR,
                "short_description" VARCHAR
            )[],
            "name" VARCHAR
        )
    ),
    "name" VARCHAR,
    "owner_project_id" VARCHAR,
    "owner_project_name" VARCHAR,
    "revision" VARCHAR
)[]
Show child fields
subscribed_listings[]
Show child fields
subscribed_listings[].description

The description of the published asset for which the subscription grant is created.

subscribed_listings[].id

The identifier of the published asset for which the subscription grant is created.

subscribed_listings[].item

The published asset for which the subscription grant is created.

Show child fields
subscribed_listings[].item.asset_listing

The asset for which the subscription grant is created.

Show child fields
subscribed_listings[].item.asset_listing.entity_id

The identifier of the published asset for which the subscription grant is created.

subscribed_listings[].item.asset_listing.entity_revision

The revision of the published asset for which the subscription grant is created.

subscribed_listings[].item.asset_listing.entity_type

The type of the published asset for which the subscription grant is created.

subscribed_listings[].item.asset_listing.forms

The forms attached to the published asset for which the subscription grant is created.

subscribed_listings[].item.asset_listing.glossary_terms[]
Show child fields
subscribed_listings[].item.asset_listing.glossary_terms[].name

The name of a glossary term attached to the inventory asset.

subscribed_listings[].item.asset_listing.glossary_terms[].short_description

The shoft description of a glossary term attached to the inventory asset.

subscribed_listings[].item.product_listing

The data product listing.

Show child fields
subscribed_listings[].item.product_listing.asset_listings[]
Show child fields
subscribed_listings[].item.product_listing.asset_listings[].entity_id

The entity ID of the listing of the asset in a data product.

subscribed_listings[].item.product_listing.asset_listings[].entity_revision

The entity revision of the listing of the asset in a data product.

subscribed_listings[].item.product_listing.asset_listings[].entity_type

The entity type of the listing of the asset in a data product.

subscribed_listings[].item.product_listing.description

The description of the data product listing.

subscribed_listings[].item.product_listing.entity_id

The ID of the data product listing.

subscribed_listings[].item.product_listing.entity_revision

The revision of the data product listing.

subscribed_listings[].item.product_listing.glossary_terms[]
Show child fields
subscribed_listings[].item.product_listing.glossary_terms[].name

The name of a glossary term attached to the inventory asset.

subscribed_listings[].item.product_listing.glossary_terms[].short_description

The shoft description of a glossary term attached to the inventory asset.

subscribed_listings[].item.product_listing.name

The name of the data product listing.

subscribed_listings[].name

The name of the published asset for which the subscription grant is created.

subscribed_listings[].owner_project_id

The identifier of the project of the published asset for which the subscription grant is created.

subscribed_listings[].owner_project_name

The name of the project that owns the published asset for which the subscription grant is created.

subscribed_listings[].revision

The revision of the published asset for which the subscription grant is created.

subscribed_principals

The subscribed principals in the subscription request.

STRUCT(
    "project" STRUCT(
        "id" VARCHAR,
        "name" VARCHAR
    )
)[]
Show child fields
subscribed_principals[]
Show child fields
subscribed_principals[].project

The project that has the subscription grant.

Show child fields
subscribed_principals[].project.id

The identifier of the project that has the subscription grant.

subscribed_principals[].project.name

The name of the project that has the subscription grant.

updated_at

The timestamp of when the subscription request was updated.

TIMESTAMP_S
updated_by

The Amazon DataZone user who updated the subscription request.

VARCHAR