Skip to content

aws.servicecatalog.describe_provisioned_product

Example SQL Queries

SELECT * FROM
aws.servicecatalog.describe_provisioned_product;

Description

Gets information about the specified provisioned product.

Table Definition

Column NameColumn Data Type
accept_language Input Column

The language code.

  • jp - Japanese

  • zh - Chinese

VARCHAR
id Input Column

The provisioned product identifier. You must provide the name or ID, but not both.

If you do not provide a name or ID, or you provide both name and ID, an InvalidParametersException will occur.

VARCHAR
name Input Column

The name of the provisioned product. You must provide the name or ID, but not both.

If you do not provide a name or ID, or you provide both name and ID, an InvalidParametersException will occur.

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
cloud_watch_dashboards

Any CloudWatch dashboards that were created when provisioning the product.

STRUCT(
"name" VARCHAR
)[]
Show child fields
cloud_watch_dashboards[]
Show child fields
cloud_watch_dashboards[].name

The name of the CloudWatch dashboard.

provisioned_product_detail

Information about the provisioned product.

STRUCT(
"name" VARCHAR,
"arn" VARCHAR,
"type" VARCHAR,
"id" VARCHAR,
"status" VARCHAR,
"status_message" VARCHAR,
"created_time" TIMESTAMP_S,
"idempotency_token" VARCHAR,
"last_record_id" VARCHAR,
"last_provisioning_record_id" VARCHAR,
"last_successful_provisioning_record_id" VARCHAR,
"product_id" VARCHAR,
"provisioning_artifact_id" VARCHAR,
"launch_role_arn" VARCHAR
)
Show child fields
provisioned_product_detail.arn

The ARN of the provisioned product.

provisioned_product_detail.created_time

The UTC time stamp of the creation time.

provisioned_product_detail.id

The identifier of the provisioned product.

provisioned_product_detail.idempotency_token

A unique identifier that you provide to ensure idempotency. If multiple requests differ only by the idempotency token, the same response is returned for each repeated request.

provisioned_product_detail.last_provisioning_record_id

The record identifier of the last request performed on this provisioned product of the following types:

  • ProvisionProduct

  • UpdateProvisionedProduct

  • ExecuteProvisionedProductPlan

  • TerminateProvisionedProduct

provisioned_product_detail.last_record_id

The record identifier of the last request performed on this provisioned product.

provisioned_product_detail.last_successful_provisioning_record_id

The record identifier of the last successful request performed on this provisioned product of the following types:

  • ProvisionProduct

  • UpdateProvisionedProduct

  • ExecuteProvisionedProductPlan

  • TerminateProvisionedProduct

provisioned_product_detail.launch_role_arn

The ARN of the launch role associated with the provisioned product.

provisioned_product_detail.name

The user-friendly name of the provisioned product.

provisioned_product_detail.product_id

The product identifier. For example, prod-abcdzk7xy33qa.

provisioned_product_detail.provisioning_artifact_id

The identifier of the provisioning artifact. For example, pa-4abcdjnxjj6ne.

provisioned_product_detail.status

The current status of the provisioned product.

  • AVAILABLE - Stable state, ready to perform any operation. The most recent operation succeeded and completed.

  • UNDER_CHANGE - Transitive state. Operations performed might not have valid results. Wait for an AVAILABLE status before performing operations.

  • TAINTED - Stable state, ready to perform any operation. The stack has completed the requested operation but is not exactly what was requested. For example, a request to update to a new version failed and the stack rolled back to the current version.

  • ERROR - An unexpected error occurred. The provisioned product exists but the stack is not running. For example, CloudFormation received a parameter value that was not valid and could not launch the stack.

  • PLAN_IN_PROGRESS - Transitive state. The plan operations were performed to provision a new product, but resources have not yet been created. After reviewing the list of resources to be created, execute the plan. Wait for an AVAILABLE status before performing operations.

provisioned_product_detail.status_message

The current status message of the provisioned product.

provisioned_product_detail.type

The type of provisioned product. The supported values are CFN_STACK, CFN_STACKSET, TERRAFORM_OPEN_SOURCE, TERRAFORM_CLOUD, and EXTERNAL.