Skip to content

aws.glue.get_dev_endpoint

Example SQL Queries

SELECT * FROM
aws.glue.get_dev_endpoint
WHERE
"endpoint_name" = 'VALUE';

Description

Retrieves information about a specified development endpoint.

When you create a development endpoint in a virtual private cloud (VPC), Glue returns only a private IP address, and the public IP address field is not populated. When you create a non-VPC development endpoint, Glue returns only a public IP address.

Table Definition

Column NameColumn Data Type
endpoint_name Required Input Column

Name of the DevEndpoint to retrieve information 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
dev_endpoint

A DevEndpoint definition.

STRUCT(
"endpoint_name" VARCHAR,
"role_arn" VARCHAR,
"security_group_ids" VARCHAR[],
"subnet_id" VARCHAR,
"yarn_endpoint_address" VARCHAR,
"private_address" VARCHAR,
"zeppelin_remote_spark_interpreter_port" BIGINT,
"public_address" VARCHAR,
"status" VARCHAR,
"worker_type" VARCHAR,
"glue_version" VARCHAR,
"number_of_workers" BIGINT,
"number_of_nodes" BIGINT,
"availability_zone" VARCHAR,
"vpc_id" VARCHAR,
"extra_python_libs_s3_path" VARCHAR,
"extra_jars_s3_path" VARCHAR,
"failure_reason" VARCHAR,
"last_update_status" VARCHAR,
"created_timestamp" TIMESTAMP_S,
"last_modified_timestamp" TIMESTAMP_S,
"public_key" VARCHAR,
"public_keys" VARCHAR[],
"security_configuration" VARCHAR,
"arguments" MAP(VARCHAR, VARCHAR)
)
Show child fields
dev_endpoint.arguments

A map of arguments used to configure the DevEndpoint.

Valid arguments are:

  • "--enable-glue-datacatalog": ""

You can specify a version of Python support for development endpoints by using the Arguments parameter in the CreateDevEndpoint or UpdateDevEndpoint APIs. If no arguments are provided, the version defaults to Python 2.

dev_endpoint.availability_zone

The Amazon Web Services Availability Zone where this DevEndpoint is located.

dev_endpoint.created_timestamp

The point in time at which this DevEndpoint was created.

dev_endpoint.endpoint_name

The name of the DevEndpoint.

dev_endpoint.extra_jars_s3_path

The path to one or more Java .jar files in an S3 bucket that should be loaded in your DevEndpoint.

You can only use pure Java/Scala libraries with a DevEndpoint.

dev_endpoint.extra_python_libs_s3_path

The paths to one or more Python libraries in an Amazon S3 bucket that should be loaded in your DevEndpoint. Multiple values must be complete paths separated by a comma.

You can only use pure Python libraries with a DevEndpoint. Libraries that rely on C extensions, such as the pandas Python data analysis library, are not currently supported.

dev_endpoint.failure_reason

The reason for a current failure in this DevEndpoint.

dev_endpoint.glue_version

Glue version determines the versions of Apache Spark and Python that Glue supports. The Python version indicates the version supported for running your ETL scripts on development endpoints.

For more information about the available Glue versions and corresponding Spark and Python versions, see Glue version in the developer guide.

Development endpoints that are created without specifying a Glue version default to Glue 0.9.

You can specify a version of Python support for development endpoints by using the Arguments parameter in the CreateDevEndpoint or UpdateDevEndpoint APIs. If no arguments are provided, the version defaults to Python 2.

dev_endpoint.last_modified_timestamp

The point in time at which this DevEndpoint was last modified.

dev_endpoint.last_update_status

The status of the last update.

dev_endpoint.number_of_nodes

The number of Glue Data Processing Units (DPUs) allocated to this DevEndpoint.

dev_endpoint.number_of_workers

The number of workers of a defined workerType that are allocated to the development endpoint.

The maximum number of workers you can define are 299 for G.1X, and 149 for G.2X.

dev_endpoint.private_address

A private IP address to access the DevEndpoint within a VPC if the DevEndpoint is created within one. The PrivateAddress field is present only when you create the DevEndpoint within your VPC.

dev_endpoint.public_address

The public IP address used by this DevEndpoint. The PublicAddress field is present only when you create a non-virtual private cloud (VPC) DevEndpoint.

dev_endpoint.public_key

The public key to be used by this DevEndpoint for authentication. This attribute is provided for backward compatibility because the recommended attribute to use is public keys.

dev_endpoint.public_keys[]
dev_endpoint.role_arn

The Amazon Resource Name (ARN) of the IAM role used in this DevEndpoint.

dev_endpoint.security_configuration

The name of the SecurityConfiguration structure to be used with this DevEndpoint.

dev_endpoint.security_group_ids[]
dev_endpoint.status

The current status of this DevEndpoint.

dev_endpoint.subnet_id

The subnet ID for this DevEndpoint.

dev_endpoint.vpc_id

The ID of the virtual private cloud (VPC) used by this DevEndpoint.

dev_endpoint.worker_type

The type of predefined worker that is allocated to the development endpoint. Accepts a value of Standard, G.1X, or G.2X.

  • For the Standard worker type, each worker provides 4 vCPU, 16 GB of memory and a 50GB disk, and 2 executors per worker.

  • For the G.1X worker type, each worker maps to 1 DPU (4 vCPU, 16 GB of memory, 64 GB disk), and provides 1 executor per worker. We recommend this worker type for memory-intensive jobs.

  • For the G.2X worker type, each worker maps to 2 DPU (8 vCPU, 32 GB of memory, 128 GB disk), and provides 1 executor per worker. We recommend this worker type for memory-intensive jobs.

Known issue: when a development endpoint is created with the G.2X WorkerType configuration, the Spark drivers for the development endpoint will run on 4 vCPU, 16 GB of memory, and a 64 GB disk.

dev_endpoint.yarn_endpoint_address

The YARN endpoint address used by this DevEndpoint.

dev_endpoint.zeppelin_remote_spark_interpreter_port

The Apache Zeppelin port for the remote Apache Spark interpreter.