aws.emr_serverless.get_application

Example SQL Queries

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

Description

Displays detailed information about a specified application.

• View All EMR Serverless Tables
• Boto3 Reference

Table Definition

Column Name	Column Data Type
application_id Required Input Column The ID of the application that will be described.	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 The output displays information about the specified application.	STRUCT( "application_id" VARCHAR, "name" VARCHAR, "arn" VARCHAR, "release_label" VARCHAR, "type" VARCHAR, "state" VARCHAR, "state_details" VARCHAR, "initial_capacity" MAP(VARCHAR, STRUCT( "worker_count" BIGINT, "worker_configuration" STRUCT( "cpu" VARCHAR, "memory" VARCHAR, "disk" VARCHAR, "disk_type" VARCHAR ) )), "maximum_capacity" STRUCT( "cpu" VARCHAR, "memory" VARCHAR, "disk" VARCHAR ), "created_at" TIMESTAMP_S, "updated_at" TIMESTAMP_S, "tags" MAP(VARCHAR, VARCHAR), "auto_start_configuration" STRUCT( "enabled" BOOLEAN ), "auto_stop_configuration" STRUCT( "enabled" BOOLEAN, "idle_timeout_minutes" BIGINT ), "network_configuration" STRUCT( "subnet_ids" VARCHAR[], "security_group_ids" VARCHAR[] ), "architecture" VARCHAR, "image_configuration" STRUCT( "image_uri" VARCHAR, "resolved_image_digest" VARCHAR ), "worker_type_specifications" MAP(VARCHAR, STRUCT( "image_configuration" STRUCT( "image_uri" VARCHAR, "resolved_image_digest" VARCHAR ) )), "runtime_configuration" STRUCT( "classification" VARCHAR, "properties" MAP(VARCHAR, VARCHAR) )[], "monitoring_configuration" STRUCT( "s3_monitoring_configuration" STRUCT( "log_uri" VARCHAR, "encryption_key_arn" VARCHAR ), "managed_persistence_monitoring_configuration" STRUCT( "enabled" BOOLEAN, "encryption_key_arn" VARCHAR ), "cloud_watch_logging_configuration" STRUCT( "enabled" BOOLEAN, "log_group_name" VARCHAR, "log_stream_name_prefix" VARCHAR, "encryption_key_arn" VARCHAR, "log_types" MAP(VARCHAR, VARCHAR[]) ), "prometheus_monitoring_configuration" STRUCT( "remote_write_url" VARCHAR ) ), "interactive_configuration" STRUCT( "studio_enabled" BOOLEAN, "livy_endpoint_enabled" BOOLEAN ) )
Show child fields application.application_id The ID of the application. application.architecture The CPU architecture of an application. application.arn The ARN of the application. application.auto_start_configuration The configuration for an application to automatically start on job submission. Show child fields application.auto_start_configuration.enabled Enables the application to automatically start on job submission. Defaults to true. application.auto_stop_configuration The configuration for an application to automatically stop after a certain amount of time being idle. Show child fields application.auto_stop_configuration.enabled Enables the application to automatically stop after a certain amount of time being idle. Defaults to true. application.auto_stop_configuration.idle_timeout_minutes The amount of idle time in minutes after which your application will automatically stop. Defaults to 15 minutes. application.created_at The date and time when the application run was created. application.image_configuration The image configuration applied to all worker types. Show child fields application.image_configuration.image_uri The image URI. application.image_configuration.resolved_image_digest The SHA256 digest of the image URI. This indicates which specific image the application is configured for. The image digest doesn't exist until an application has started. application.initial_capacity The initial capacity of the application. application.interactive_configuration The interactive configuration object that enables the interactive use cases for an application. Show child fields application.interactive_configuration.livy_endpoint_enabled Enables an Apache Livy endpoint that you can connect to and run interactive jobs. application.interactive_configuration.studio_enabled Enables you to connect an application to Amazon EMR Studio to run interactive workloads in a notebook. application.maximum_capacity The maximum capacity of the application. This is cumulative across all workers at any given point in time during the lifespan of the application is created. No new resources will be created once any one of the defined limits is hit. Show child fields application.maximum_capacity.cpu The maximum allowed CPU for an application. application.maximum_capacity.disk The maximum allowed disk for an application. application.maximum_capacity.memory The maximum allowed resources for an application. application.monitoring_configuration The configuration setting for monitoring. Show child fields application.monitoring_configuration.cloud_watch_logging_configuration The Amazon CloudWatch configuration for monitoring logs. You can configure your jobs to send log information to CloudWatch. Show child fields application.monitoring_configuration.cloud_watch_logging_configuration.enabled Enables CloudWatch logging. application.monitoring_configuration.cloud_watch_logging_configuration.encryption_key_arn The Key Management Service (KMS) key ARN to encrypt the logs that you store in CloudWatch Logs. application.monitoring_configuration.cloud_watch_logging_configuration.log_group_name The name of the log group in Amazon CloudWatch Logs where you want to publish your logs. application.monitoring_configuration.cloud_watch_logging_configuration.log_stream_name_prefix Prefix for the CloudWatch log stream name. application.monitoring_configuration.cloud_watch_logging_configuration.log_types The types of logs that you want to publish to CloudWatch. If you don't specify any log types, driver STDOUT and STDERR logs will be published to CloudWatch Logs by default. For more information including the supported worker types for Hive and Spark, see Logging for EMR Serverless with CloudWatch. Key Valid Values: SPARK_DRIVER, SPARK_EXECUTOR, HIVE_DRIVER, TEZ_TASK Array Members Valid Values: STDOUT, STDERR, HIVE_LOG, TEZ_AM, SYSTEM_LOGS application.monitoring_configuration.managed_persistence_monitoring_configuration The managed log persistence configuration for a job run. Show child fields application.monitoring_configuration.managed_persistence_monitoring_configuration.enabled Enables managed logging and defaults to true. If set to false, managed logging will be turned off. application.monitoring_configuration.managed_persistence_monitoring_configuration.encryption_key_arn The KMS key ARN to encrypt the logs stored in managed log persistence. application.monitoring_configuration.prometheus_monitoring_configuration The monitoring configuration object you can configure to send metrics to Amazon Managed Service for Prometheus for a job run. Show child fields application.monitoring_configuration.prometheus_monitoring_configuration.remote_write_url The remote write URL in the Amazon Managed Service for Prometheus workspace to send metrics to. application.monitoring_configuration.s3_monitoring_configuration The Amazon S3 configuration for monitoring log publishing. Show child fields application.monitoring_configuration.s3_monitoring_configuration.encryption_key_arn The KMS key ARN to encrypt the logs published to the given Amazon S3 destination. application.monitoring_configuration.s3_monitoring_configuration.log_uri The Amazon S3 destination URI for log publishing. application.name The name of the application. application.network_configuration The network configuration for customer VPC connectivity for the application. Show child fields application.network_configuration.security_group_ids[] application.network_configuration.subnet_ids[] application.release_label The Amazon EMR release associated with the application. application.runtime_configuration[] Show child fields application.runtime_configuration[].classification The classification within a configuration. application.runtime_configuration[].properties A set of properties specified within a configuration classification. application.state The state of the application. application.state_details The state details of the application. application.tags The tags assigned to the application. application.type The type of application, such as Spark or Hive. application.updated_at The date and time when the application run was last updated. application.worker_type_specifications The specification applied to each worker type.

Note

Tables may require input columns to have values specified before the table can return it’s rows. The values for input parameters are set in the where clause of the query typically using = or IN.