Skip to content
AWS for Query.Farm

aws.emr_containers.describe_managed_endpoint

Example SQL Queries

SELECT * FROM
aws.emr_containers.describe_managed_endpoint
WHERE
"id" = 'VALUE'
AND "virtual_cluster_id" = 'VALUE';

Description

Displays detailed information about a managed endpoint. A managed endpoint is a gateway that connects Amazon EMR Studio to Amazon EMR on EKS so that Amazon EMR Studio can communicate with your virtual cluster.

Table Definition

Column NameColumn Data Type
id Required Input Column

This output displays ID of the managed endpoint.

VARCHAR
virtual_cluster_id Required Input Column

The ID of the endpoint's virtual cluster.

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
endpoint

This output displays information about a managed endpoint.

STRUCT(
    "id" VARCHAR,
    "name" VARCHAR,
    "arn" VARCHAR,
    "virtual_cluster_id" VARCHAR,
    "type" VARCHAR,
    "state" VARCHAR,
    "release_label" VARCHAR,
    "execution_role_arn" VARCHAR,
    "certificate_arn" VARCHAR,
    "certificate_authority" STRUCT(
        "certificate_arn" VARCHAR,
        "certificate_data" VARCHAR
    ),
    "configuration_overrides" STRUCT(
        "application_configuration" STRUCT(
            "classification" VARCHAR,
            "properties" MAP(VARCHAR, VARCHAR)
        )[],
        "monitoring_configuration" STRUCT(
            "persistent_app_ui" VARCHAR,
            "cloud_watch_monitoring_configuration" STRUCT(
                "log_group_name" VARCHAR,
                "log_stream_name_prefix" VARCHAR
            ),
            "s3_monitoring_configuration" STRUCT(
                "log_uri" VARCHAR
            ),
            "container_log_rotation_configuration" STRUCT(
                "rotation_size" VARCHAR,
                "max_files_to_keep" BIGINT
            )
        )
    ),
    "server_url" VARCHAR,
    "created_at" TIMESTAMP_S,
    "security_group" VARCHAR,
    "subnet_ids" VARCHAR[],
    "state_details" VARCHAR,
    "failure_reason" VARCHAR,
    "tags" MAP(VARCHAR, VARCHAR)
)
Show child fields
endpoint.arn

The ARN of the endpoint.

endpoint.certificate_arn

The certificate ARN of the endpoint. This field is under deprecation and will be removed in future.

endpoint.certificate_authority

The certificate generated by emr control plane on customer behalf to secure the managed endpoint.

Show child fields
endpoint.certificate_authority.certificate_arn

The ARN of the certificate generated for managed endpoint.

endpoint.certificate_authority.certificate_data

The base64 encoded PEM certificate data generated for managed endpoint.

endpoint.configuration_overrides

The configuration settings that are used to override existing configurations for endpoints.

Show child fields
endpoint.configuration_overrides.application_configuration[]
Show child fields
endpoint.configuration_overrides.application_configuration[].classification

The classification within a configuration.

endpoint.configuration_overrides.application_configuration[].properties

A set of properties specified within a configuration classification.

endpoint.configuration_overrides.monitoring_configuration

The configurations for monitoring.

Show child fields
endpoint.configuration_overrides.monitoring_configuration.cloud_watch_monitoring_configuration

Monitoring configurations for CloudWatch.

Show child fields
endpoint.configuration_overrides.monitoring_configuration.cloud_watch_monitoring_configuration.log_group_name

The name of the log group for log publishing.

endpoint.configuration_overrides.monitoring_configuration.cloud_watch_monitoring_configuration.log_stream_name_prefix

The specified name prefix for log streams.

endpoint.configuration_overrides.monitoring_configuration.container_log_rotation_configuration

Enable or disable container log rotation.

Show child fields
endpoint.configuration_overrides.monitoring_configuration.container_log_rotation_configuration.max_files_to_keep

The number of files to keep in container after rotation.

endpoint.configuration_overrides.monitoring_configuration.container_log_rotation_configuration.rotation_size

The file size at which to rotate logs. Minimum of 2KB, Maximum of 2GB.

endpoint.configuration_overrides.monitoring_configuration.persistent_app_ui

Monitoring configurations for the persistent application UI.

endpoint.configuration_overrides.monitoring_configuration.s3_monitoring_configuration

Amazon S3 configuration for monitoring log publishing.

Show child fields
endpoint.configuration_overrides.monitoring_configuration.s3_monitoring_configuration.log_uri

Amazon S3 destination URI for log publishing.

endpoint.created_at

The date and time when the endpoint was created.

endpoint.execution_role_arn

The execution role ARN of the endpoint.

endpoint.failure_reason

The reasons why the endpoint has failed.

endpoint.id

The ID of the endpoint.

endpoint.name

The name of the endpoint.

endpoint.release_label

The EMR release version to be used for the endpoint.

endpoint.security_group

The security group configuration of the endpoint.

endpoint.server_url

The server URL of the endpoint.

endpoint.state

The state of the endpoint.

endpoint.state_details

Additional details of the endpoint state.

endpoint.subnet_ids[]
endpoint.tags

The tags of the endpoint.

endpoint.type

The type of the endpoint.

endpoint.virtual_cluster_id

The ID of the endpoint's virtual cluster.