Skip to content

aws.apprunner.describe_service

Example SQL Queries

SELECT * FROM
aws.apprunner.describe_service
WHERE
"service_arn" = 'VALUE';

Description

Return a full description of an App Runner service.

Table Definition

Column NameColumn Data Type
service_arn Required Input Column

The Amazon Resource Name (ARN) of the App Runner service that you want a description for.

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
service

A full description of the App Runner service that you specified in this request.

STRUCT(
"service_name" VARCHAR,
"service_id" VARCHAR,
"service_arn" VARCHAR,
"service_url" VARCHAR,
"created_at" TIMESTAMP_S,
"updated_at" TIMESTAMP_S,
"deleted_at" TIMESTAMP_S,
"status" VARCHAR,
"source_configuration" STRUCT(
"code_repository" STRUCT(
"repository_url" VARCHAR,
"source_code_version" STRUCT(
"type" VARCHAR,
"value" VARCHAR
),
"code_configuration" STRUCT(
"configuration_source" VARCHAR,
"code_configuration_values" STRUCT(
"runtime" VARCHAR,
"build_command" VARCHAR,
"start_command" VARCHAR,
"port" VARCHAR,
"runtime_environment_variables" MAP(VARCHAR, VARCHAR),
"runtime_environment_secrets" MAP(VARCHAR, VARCHAR)
)
),
"source_directory" VARCHAR
),
"image_repository" STRUCT(
"image_identifier" VARCHAR,
"image_configuration" STRUCT(
"runtime_environment_variables" MAP(VARCHAR, VARCHAR),
"start_command" VARCHAR,
"port" VARCHAR,
"runtime_environment_secrets" MAP(VARCHAR, VARCHAR)
),
"image_repository_type" VARCHAR
),
"auto_deployments_enabled" BOOLEAN,
"authentication_configuration" STRUCT(
"connection_arn" VARCHAR,
"access_role_arn" VARCHAR
)
),
"instance_configuration" STRUCT(
"cpu" VARCHAR,
"memory" VARCHAR,
"instance_role_arn" VARCHAR
),
"encryption_configuration" STRUCT(
"kms_key" VARCHAR
),
"health_check_configuration" STRUCT(
"protocol" VARCHAR,
"path" VARCHAR,
"interval" BIGINT,
"timeout" BIGINT,
"healthy_threshold" BIGINT,
"unhealthy_threshold" BIGINT
),
"auto_scaling_configuration_summary" STRUCT(
"auto_scaling_configuration_arn" VARCHAR,
"auto_scaling_configuration_name" VARCHAR,
"auto_scaling_configuration_revision" BIGINT,
"status" VARCHAR,
"created_at" TIMESTAMP_S,
"has_associated_service" BOOLEAN,
"is_default" BOOLEAN
),
"network_configuration" STRUCT(
"egress_configuration" STRUCT(
"egress_type" VARCHAR,
"vpc_connector_arn" VARCHAR
),
"ingress_configuration" STRUCT(
"is_publicly_accessible" BOOLEAN
),
"ip_address_type" VARCHAR
),
"observability_configuration" STRUCT(
"observability_enabled" BOOLEAN,
"observability_configuration_arn" VARCHAR
)
)
Show child fields
service.auto_scaling_configuration_summary

Summary information for the App Runner automatic scaling configuration resource that's associated with this service.

Show child fields
service.auto_scaling_configuration_summary.auto_scaling_configuration_arn

The Amazon Resource Name (ARN) of this auto scaling configuration.

service.auto_scaling_configuration_summary.auto_scaling_configuration_name

The customer-provided auto scaling configuration name. It can be used in multiple revisions of a configuration.

service.auto_scaling_configuration_summary.auto_scaling_configuration_revision

The revision of this auto scaling configuration. It's unique among all the active configurations ("Status": "ACTIVE") with the same AutoScalingConfigurationName.

service.auto_scaling_configuration_summary.created_at

The time when the auto scaling configuration was created. It's in Unix time stamp format.

service.auto_scaling_configuration_summary.has_associated_service

Indicates if this auto scaling configuration has an App Runner service associated with it. A value of true indicates one or more services are associated. A value of false indicates no services are associated.

service.auto_scaling_configuration_summary.is_default

Indicates if this auto scaling configuration should be used as the default for a new App Runner service that does not have an auto scaling configuration ARN specified during creation. Each account can have only one default AutoScalingConfiguration per region. The default AutoScalingConfiguration can be any revision under the same AutoScalingConfigurationName.

service.auto_scaling_configuration_summary.status

The current state of the auto scaling configuration. If the status of a configuration revision is INACTIVE, it was deleted and can't be used. Inactive configuration revisions are permanently removed some time after they are deleted.

service.created_at

The time when the App Runner service was created. It's in the Unix time stamp format.

service.deleted_at

The time when the App Runner service was deleted. It's in the Unix time stamp format.

service.encryption_configuration

The encryption key that App Runner uses to encrypt the service logs and the copy of the source repository that App Runner maintains for the service. It can be either a customer-provided encryption key or an Amazon Web Services managed key.

Show child fields
service.encryption_configuration.kms_key

The ARN of the KMS key that's used for encryption.

service.health_check_configuration

The settings for the health check that App Runner performs to monitor the health of this service.

Show child fields
service.health_check_configuration.healthy_threshold

The number of consecutive checks that must succeed before App Runner decides that the service is healthy.

Default: 1

service.health_check_configuration.interval

The time interval, in seconds, between health checks.

Default: 5

service.health_check_configuration.path

The URL that health check requests are sent to.

Path is only applicable when you set Protocol to HTTP.

Default: "/"

service.health_check_configuration.protocol

The IP protocol that App Runner uses to perform health checks for your service.

If you set Protocol to HTTP, App Runner sends health check requests to the HTTP path specified by Path.

Default: TCP

service.health_check_configuration.timeout

The time, in seconds, to wait for a health check response before deciding it failed.

Default: 2

service.health_check_configuration.unhealthy_threshold

The number of consecutive checks that must fail before App Runner decides that the service is unhealthy.

Default: 5

service.instance_configuration

The runtime configuration of instances (scaling units) of this service.

Show child fields
service.instance_configuration.cpu

The number of CPU units reserved for each instance of your App Runner service.

Default: 1 vCPU

service.instance_configuration.instance_role_arn

The Amazon Resource Name (ARN) of an IAM role that provides permissions to your App Runner service. These are permissions that your code needs when it calls any Amazon Web Services APIs.

service.instance_configuration.memory

The amount of memory, in MB or GB, reserved for each instance of your App Runner service.

Default: 2 GB

service.network_configuration

Configuration settings related to network traffic of the web application that this service runs.

Show child fields
service.network_configuration.egress_configuration

Network configuration settings for outbound message traffic.

Show child fields
service.network_configuration.egress_configuration.egress_type

The type of egress configuration.

Set to DEFAULT for access to resources hosted on public networks.

Set to VPC to associate your service to a custom VPC specified by VpcConnectorArn.

service.network_configuration.egress_configuration.vpc_connector_arn

The Amazon Resource Name (ARN) of the App Runner VPC connector that you want to associate with your App Runner service. Only valid when EgressType = VPC.

service.network_configuration.ingress_configuration

Network configuration settings for inbound message traffic.

Show child fields
service.network_configuration.ingress_configuration.is_publicly_accessible

Specifies whether your App Runner service is publicly accessible. To make the service publicly accessible set it to True. To make the service privately accessible, from only within an Amazon VPC set it to False.

service.network_configuration.ip_address_type

App Runner provides you with the option to choose between Internet Protocol version 4 (IPv4) and dual stack (IPv4 and IPv6) for your incoming public network configuration. This is an optional parameter. If you do not specify an IpAddressType, it defaults to select IPv4.

Currently, App Runner supports dual stack for only Public endpoint. Only IPv4 is supported for Private endpoint. If you update a service that's using dual-stack Public endpoint to a Private endpoint, your App Runner service will default to support only IPv4 for Private endpoint and fail to receive traffic originating from IPv6 endpoint.

service.observability_configuration

The observability configuration of this service.

Show child fields
service.observability_configuration.observability_configuration_arn

The Amazon Resource Name (ARN) of the observability configuration that is associated with the service. Specified only when ObservabilityEnabled is true.

Specify an ARN with a name and a revision number to associate that revision. For example: arn:aws:apprunner:us-east-1:123456789012:observabilityconfiguration/xray-tracing/3

Specify just the name to associate the latest revision. For example: arn:aws:apprunner:us-east-1:123456789012:observabilityconfiguration/xray-tracing

service.observability_configuration.observability_enabled

When true, an observability configuration resource is associated with the service, and an ObservabilityConfigurationArn is specified.

service.service_arn

The Amazon Resource Name (ARN) of this service.

service.service_id

An ID that App Runner generated for this service. It's unique within the Amazon Web Services Region.

service.service_name

The customer-provided service name.

service.service_url

A subdomain URL that App Runner generated for this service. You can use this URL to access your service web application.

service.source_configuration

The source deployed to the App Runner service. It can be a code or an image repository.

Show child fields
service.source_configuration.authentication_configuration

Describes the resources that are needed to authenticate access to some source repositories.

Show child fields
service.source_configuration.authentication_configuration.access_role_arn

The Amazon Resource Name (ARN) of the IAM role that grants the App Runner service access to a source repository. It's required for ECR image repositories (but not for ECR Public repositories).

service.source_configuration.authentication_configuration.connection_arn

The Amazon Resource Name (ARN) of the App Runner connection that enables the App Runner service to connect to a source repository. It's required for GitHub code repositories.

service.source_configuration.auto_deployments_enabled

If true, continuous integration from the source repository is enabled for the App Runner service. Each repository change (including any source code commit or new image version) starts a deployment.

Default: App Runner sets to false for a source image that uses an ECR Public repository or an ECR repository that's in an Amazon Web Services account other than the one that the service is in. App Runner sets to true in all other cases (which currently include a source code repository or a source image using a same-account ECR repository).

service.source_configuration.code_repository

The description of a source code repository.

You must provide either this member or ImageRepository (but not both).

Show child fields
service.source_configuration.code_repository.code_configuration

Configuration for building and running the service from a source code repository.

CodeConfiguration is required only for CreateService request.

Show child fields
service.source_configuration.code_repository.code_configuration.code_configuration_values

The basic configuration for building and running the App Runner service. Use it to quickly launch an App Runner service without providing a apprunner.yaml file in the source code repository (or ignoring the file if it exists).

Show child fields
service.source_configuration.code_repository.code_configuration.code_configuration_values.build_command

The command App Runner runs to build your application.

service.source_configuration.code_repository.code_configuration.code_configuration_values.port

The port that your application listens to in the container.

Default: 8080

service.source_configuration.code_repository.code_configuration.code_configuration_values.runtime

A runtime environment type for building and running an App Runner service. It represents a programming language runtime.

service.source_configuration.code_repository.code_configuration.code_configuration_values.runtime_environment_secrets

An array of key-value pairs representing the secrets and parameters that get referenced to your service as an environment variable. The supported values are either the full Amazon Resource Name (ARN) of the Secrets Manager secret or the full ARN of the parameter in the Amazon Web Services Systems Manager Parameter Store.

  • If the Amazon Web Services Systems Manager Parameter Store parameter exists in the same Amazon Web Services Region as the service that you're launching, you can use either the full ARN or name of the secret. If the parameter exists in a different Region, then the full ARN must be specified.

  • Currently, cross account referencing of Amazon Web Services Systems Manager Parameter Store parameter is not supported.

service.source_configuration.code_repository.code_configuration.code_configuration_values.runtime_environment_variables

The environment variables that are available to your running App Runner service. An array of key-value pairs.

service.source_configuration.code_repository.code_configuration.code_configuration_values.start_command

The command App Runner runs to start your application.

service.source_configuration.code_repository.code_configuration.configuration_source

The source of the App Runner configuration. Values are interpreted as follows:

  • REPOSITORY – App Runner reads configuration values from the apprunner.yaml file in the source code repository and ignores CodeConfigurationValues.

  • API – App Runner uses configuration values provided in CodeConfigurationValues and ignores the apprunner.yaml file in the source code repository.

service.source_configuration.code_repository.repository_url

The location of the repository that contains the source code.

service.source_configuration.code_repository.source_code_version

The version that should be used within the source code repository.

Show child fields
service.source_configuration.code_repository.source_code_version.type

The type of version identifier.

For a git-based repository, branches represent versions.

service.source_configuration.code_repository.source_code_version.value

A source code version.

For a git-based repository, a branch name maps to a specific version. App Runner uses the most recent commit to the branch.

service.source_configuration.code_repository.source_directory

The path of the directory that stores source code and configuration files. The build and start commands also execute from here. The path is absolute from root and, if not specified, defaults to the repository root.

service.source_configuration.image_repository

The description of a source image repository.

You must provide either this member or CodeRepository (but not both).

Show child fields
service.source_configuration.image_repository.image_configuration

Configuration for running the identified image.

Show child fields
service.source_configuration.image_repository.image_configuration.port

The port that your application listens to in the container.

Default: 8080

service.source_configuration.image_repository.image_configuration.runtime_environment_secrets

An array of key-value pairs representing the secrets and parameters that get referenced to your service as an environment variable. The supported values are either the full Amazon Resource Name (ARN) of the Secrets Manager secret or the full ARN of the parameter in the Amazon Web Services Systems Manager Parameter Store.

  • If the Amazon Web Services Systems Manager Parameter Store parameter exists in the same Amazon Web Services Region as the service that you're launching, you can use either the full ARN or name of the secret. If the parameter exists in a different Region, then the full ARN must be specified.

  • Currently, cross account referencing of Amazon Web Services Systems Manager Parameter Store parameter is not supported.

service.source_configuration.image_repository.image_configuration.runtime_environment_variables

Environment variables that are available to your running App Runner service. An array of key-value pairs.

service.source_configuration.image_repository.image_configuration.start_command

An optional command that App Runner runs to start the application in the source image. If specified, this command overrides the Docker image’s default start command.

service.source_configuration.image_repository.image_identifier

The identifier of an image.

For an image in Amazon Elastic Container Registry (Amazon ECR), this is an image name. For the image name format, see Pulling an image in the Amazon ECR User Guide.

service.source_configuration.image_repository.image_repository_type

The type of the image repository. This reflects the repository provider and whether the repository is private or public.

service.status

The current state of the App Runner service. These particular values mean the following.

  • CREATE_FAILED – The service failed to create. The failed service isn't usable, and still counts towards your service quota. To troubleshoot this failure, read the failure events and logs, change any parameters that need to be fixed, and rebuild your service using UpdateService.

  • DELETE_FAILED – The service failed to delete and can't be successfully recovered. Retry the service deletion call to ensure that all related resources are removed.

service.updated_at

The time when the App Runner service was last updated at. It's in the Unix time stamp format.