Skip to content
AWS for Query.Farm

aws.glue.get_jobs

Example SQL Queries

SELECT * FROM
aws.glue.get_jobs;

Description

Retrieves all current job definitions.

Table Definition

Column NameColumn Data Type
_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
allocated_capacity

This field is deprecated. Use MaxCapacity instead.

The number of Glue data processing units (DPUs) allocated to runs of this job. You can allocate a minimum of 2 DPUs; the default is 10. A DPU is a relative measure of processing power that consists of 4 vCPUs of compute capacity and 16 GB of memory. For more information, see the Glue pricing page.

BIGINT
code_gen_configuration_nodes

The representation of a directed acyclic graph on which both the Glue Studio visual component and Glue Studio code generation is based.

MAP(VARCHAR, STRUCT(
        "athena_connector_source" STRUCT(
            "name" VARCHAR,
            "connection_name" VARCHAR,
            "connector_name" VARCHAR,
            "connection_type" VARCHAR,
            "connection_table" VARCHAR,
            "schema_name" VARCHAR,
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "jdbc_connector_source" STRUCT(
            "name" VARCHAR,
            "connection_name" VARCHAR,
            "connector_name" VARCHAR,
            "connection_type" VARCHAR,
            "additional_options" STRUCT(
                "filter_predicate" VARCHAR,
                "partition_column" VARCHAR,
                "lower_bound" BIGINT,
                "upper_bound" BIGINT,
                "num_partitions" BIGINT,
                "job_bookmark_keys" VARCHAR[],
                "job_bookmark_keys_sort_order" VARCHAR,
                "data_type_mapping" MAP(VARCHAR, VARCHAR)
            ),
            "connection_table" VARCHAR,
            "query" VARCHAR,
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "spark_connector_source" STRUCT(
            "name" VARCHAR,
            "connection_name" VARCHAR,
            "connector_name" VARCHAR,
            "connection_type" VARCHAR,
            "additional_options" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "redshift_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "redshift_tmp_dir" VARCHAR,
            "tmp_dir_iam_role" VARCHAR
        ),
        "s3_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "partition_predicate" VARCHAR,
            "additional_options" STRUCT(
                "bounded_size" BIGINT,
                "bounded_files" BIGINT
            )
        ),
        "s3_csv_source" STRUCT(
            "name" VARCHAR,
            "paths" VARCHAR[],
            "compression_type" VARCHAR,
            "exclusions" VARCHAR[],
            "group_size" VARCHAR,
            "group_files" VARCHAR,
            "recurse" BOOLEAN,
            "max_band" BIGINT,
            "max_files_in_band" BIGINT,
            "additional_options" STRUCT(
                "bounded_size" BIGINT,
                "bounded_files" BIGINT,
                "enable_sample_path" BOOLEAN,
                "sample_path" VARCHAR
            ),
            "separator" VARCHAR,
            "escaper" VARCHAR,
            "quote_char" VARCHAR,
            "multiline" BOOLEAN,
            "with_header" BOOLEAN,
            "write_header" BOOLEAN,
            "skip_first" BOOLEAN,
            "optimize_performance" BOOLEAN,
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "s3_json_source" STRUCT(
            "name" VARCHAR,
            "paths" VARCHAR[],
            "compression_type" VARCHAR,
            "exclusions" VARCHAR[],
            "group_size" VARCHAR,
            "group_files" VARCHAR,
            "recurse" BOOLEAN,
            "max_band" BIGINT,
            "max_files_in_band" BIGINT,
            "additional_options" STRUCT(
                "bounded_size" BIGINT,
                "bounded_files" BIGINT,
                "enable_sample_path" BOOLEAN,
                "sample_path" VARCHAR
            ),
            "json_path" VARCHAR,
            "multiline" BOOLEAN,
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "s3_parquet_source" STRUCT(
            "name" VARCHAR,
            "paths" VARCHAR[],
            "compression_type" VARCHAR,
            "exclusions" VARCHAR[],
            "group_size" VARCHAR,
            "group_files" VARCHAR,
            "recurse" BOOLEAN,
            "max_band" BIGINT,
            "max_files_in_band" BIGINT,
            "additional_options" STRUCT(
                "bounded_size" BIGINT,
                "bounded_files" BIGINT,
                "enable_sample_path" BOOLEAN,
                "sample_path" VARCHAR
            ),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "relational_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "dynamo_db_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "jdbc_connector_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "connection_name" VARCHAR,
            "connection_table" VARCHAR,
            "connector_name" VARCHAR,
            "connection_type" VARCHAR,
            "additional_options" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "spark_connector_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "connection_name" VARCHAR,
            "connector_name" VARCHAR,
            "connection_type" VARCHAR,
            "additional_options" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "redshift_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "database" VARCHAR,
            "table" VARCHAR,
            "redshift_tmp_dir" VARCHAR,
            "tmp_dir_iam_role" VARCHAR,
            "upsert_redshift_options" STRUCT(
                "table_location" VARCHAR,
                "connection_name" VARCHAR,
                "upsert_keys" VARCHAR[]
            )
        ),
        "s3_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "table" VARCHAR,
            "database" VARCHAR,
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR
            )
        ),
        "s3_glue_parquet_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "path" VARCHAR,
            "compression" VARCHAR,
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR,
                "table" VARCHAR,
                "database" VARCHAR
            )
        ),
        "s3_direct_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "path" VARCHAR,
            "compression" VARCHAR,
            "format" VARCHAR,
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR,
                "table" VARCHAR,
                "database" VARCHAR
            )
        ),
        "apply_mapping" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "mapping" STRUCT(
                "to_key" VARCHAR,
                "from_path" VARCHAR[],
                "from_type" VARCHAR,
                "to_type" VARCHAR,
                "dropped" BOOLEAN
            )[]
        ),
        "select_fields" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "paths" VARCHAR[][]
        ),
        "drop_fields" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "paths" VARCHAR[][]
        ),
        "rename_field" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "source_path" VARCHAR[],
            "target_path" VARCHAR[]
        ),
        "spigot" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "path" VARCHAR,
            "topk" BIGINT,
            "prob" DOUBLE
        ),
        "join" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "join_type" VARCHAR,
            "columns" STRUCT(
                "from" VARCHAR,
                "keys" VARCHAR[][]
            )[]
        ),
        "split_fields" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "paths" VARCHAR[][]
        ),
        "select_from_collection" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "index" BIGINT
        ),
        "fill_missing_values" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "imputed_path" VARCHAR,
            "filled_path" VARCHAR
        ),
        "filter" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "logical_operator" VARCHAR,
            "filters" STRUCT(
                "operation" VARCHAR,
                "negated" BOOLEAN,
                "values" STRUCT(
                    "type" VARCHAR,
                    "value" VARCHAR[]
                )[]
            )[]
        ),
        "custom_code" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "code" VARCHAR,
            "class_name" VARCHAR,
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "spark_sql" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "sql_query" VARCHAR,
            "sql_aliases" STRUCT(
                "from" VARCHAR,
                "alias" VARCHAR
            )[],
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "direct_kinesis_source" STRUCT(
            "name" VARCHAR,
            "window_size" BIGINT,
            "detect_schema" BOOLEAN,
            "streaming_options" STRUCT(
                "endpoint_url" VARCHAR,
                "stream_name" VARCHAR,
                "classification" VARCHAR,
                "delimiter" VARCHAR,
                "starting_position" VARCHAR,
                "max_fetch_time_in_ms" BIGINT,
                "max_fetch_records_per_shard" BIGINT,
                "max_record_per_read" BIGINT,
                "add_idle_time_between_reads" BOOLEAN,
                "idle_time_between_reads_in_ms" BIGINT,
                "describe_shard_interval" BIGINT,
                "num_retries" BIGINT,
                "retry_interval_ms" BIGINT,
                "max_retry_interval_ms" BIGINT,
                "avoid_empty_batches" BOOLEAN,
                "stream_arn" VARCHAR,
                "role_arn" VARCHAR,
                "role_session_name" VARCHAR,
                "add_record_timestamp" VARCHAR,
                "emit_consumer_lag_metrics" VARCHAR,
                "starting_timestamp" TIMESTAMP_S
            ),
            "data_preview_options" STRUCT(
                "polling_time" BIGINT,
                "record_polling_limit" BIGINT
            )
        ),
        "direct_kafka_source" STRUCT(
            "name" VARCHAR,
            "streaming_options" STRUCT(
                "bootstrap_servers" VARCHAR,
                "security_protocol" VARCHAR,
                "connection_name" VARCHAR,
                "topic_name" VARCHAR,
                "assign" VARCHAR,
                "subscribe_pattern" VARCHAR,
                "classification" VARCHAR,
                "delimiter" VARCHAR,
                "starting_offsets" VARCHAR,
                "ending_offsets" VARCHAR,
                "poll_timeout_ms" BIGINT,
                "num_retries" BIGINT,
                "retry_interval_ms" BIGINT,
                "max_offsets_per_trigger" BIGINT,
                "min_partitions" BIGINT,
                "include_headers" BOOLEAN,
                "add_record_timestamp" VARCHAR,
                "emit_consumer_lag_metrics" VARCHAR,
                "starting_timestamp" TIMESTAMP_S
            ),
            "window_size" BIGINT,
            "detect_schema" BOOLEAN,
            "data_preview_options" STRUCT(
                "polling_time" BIGINT,
                "record_polling_limit" BIGINT
            )
        ),
        "catalog_kinesis_source" STRUCT(
            "name" VARCHAR,
            "window_size" BIGINT,
            "detect_schema" BOOLEAN,
            "table" VARCHAR,
            "database" VARCHAR,
            "streaming_options" STRUCT(
                "endpoint_url" VARCHAR,
                "stream_name" VARCHAR,
                "classification" VARCHAR,
                "delimiter" VARCHAR,
                "starting_position" VARCHAR,
                "max_fetch_time_in_ms" BIGINT,
                "max_fetch_records_per_shard" BIGINT,
                "max_record_per_read" BIGINT,
                "add_idle_time_between_reads" BOOLEAN,
                "idle_time_between_reads_in_ms" BIGINT,
                "describe_shard_interval" BIGINT,
                "num_retries" BIGINT,
                "retry_interval_ms" BIGINT,
                "max_retry_interval_ms" BIGINT,
                "avoid_empty_batches" BOOLEAN,
                "stream_arn" VARCHAR,
                "role_arn" VARCHAR,
                "role_session_name" VARCHAR,
                "add_record_timestamp" VARCHAR,
                "emit_consumer_lag_metrics" VARCHAR,
                "starting_timestamp" TIMESTAMP_S
            ),
            "data_preview_options" STRUCT(
                "polling_time" BIGINT,
                "record_polling_limit" BIGINT
            )
        ),
        "catalog_kafka_source" STRUCT(
            "name" VARCHAR,
            "window_size" BIGINT,
            "detect_schema" BOOLEAN,
            "table" VARCHAR,
            "database" VARCHAR,
            "streaming_options" STRUCT(
                "bootstrap_servers" VARCHAR,
                "security_protocol" VARCHAR,
                "connection_name" VARCHAR,
                "topic_name" VARCHAR,
                "assign" VARCHAR,
                "subscribe_pattern" VARCHAR,
                "classification" VARCHAR,
                "delimiter" VARCHAR,
                "starting_offsets" VARCHAR,
                "ending_offsets" VARCHAR,
                "poll_timeout_ms" BIGINT,
                "num_retries" BIGINT,
                "retry_interval_ms" BIGINT,
                "max_offsets_per_trigger" BIGINT,
                "min_partitions" BIGINT,
                "include_headers" BOOLEAN,
                "add_record_timestamp" VARCHAR,
                "emit_consumer_lag_metrics" VARCHAR,
                "starting_timestamp" TIMESTAMP_S
            ),
            "data_preview_options" STRUCT(
                "polling_time" BIGINT,
                "record_polling_limit" BIGINT
            )
        ),
        "drop_null_fields" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "null_check_box_list" STRUCT(
                "is_empty" BOOLEAN,
                "is_null_string" BOOLEAN,
                "is_neg_one" BOOLEAN
            ),
            "null_text_list" STRUCT(
                "value" VARCHAR,
                "datatype" STRUCT(
                    "id" VARCHAR,
                    "label" VARCHAR
                )
            )[]
        ),
        "merge" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "source" VARCHAR,
            "primary_keys" VARCHAR[][]
        ),
        "union" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "union_type" VARCHAR
        ),
        "pii_detection" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "pii_type" VARCHAR,
            "entity_types_to_detect" VARCHAR[],
            "output_column_name" VARCHAR,
            "sample_fraction" DOUBLE,
            "threshold_fraction" DOUBLE,
            "mask_value" VARCHAR
        ),
        "aggregate" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "groups" VARCHAR[][],
            "aggs" STRUCT(
                "column" VARCHAR[],
                "agg_func" VARCHAR
            )[]
        ),
        "drop_duplicates" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "columns" VARCHAR[][]
        ),
        "governed_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "table" VARCHAR,
            "database" VARCHAR,
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR
            )
        ),
        "governed_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "partition_predicate" VARCHAR,
            "additional_options" STRUCT(
                "bounded_size" BIGINT,
                "bounded_files" BIGINT
            )
        ),
        "microsoft_sql_server_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "my_sql_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "oracle_sql_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "postgre_sql_catalog_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "microsoft_sql_server_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "my_sql_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "oracle_sql_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "postgre_sql_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "database" VARCHAR,
            "table" VARCHAR
        ),
        "dynamic_transform" STRUCT(
            "name" VARCHAR,
            "transform_name" VARCHAR,
            "inputs" VARCHAR[],
            "parameters" STRUCT(
                "name" VARCHAR,
                "type" VARCHAR,
                "validation_rule" VARCHAR,
                "validation_message" VARCHAR,
                "value" VARCHAR[],
                "list_type" VARCHAR,
                "is_optional" BOOLEAN
            )[],
            "function_name" VARCHAR,
            "path" VARCHAR,
            "version" VARCHAR,
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "evaluate_data_quality" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "ruleset" VARCHAR,
            "output" VARCHAR,
            "publishing_options" STRUCT(
                "evaluation_context" VARCHAR,
                "results_s3_prefix" VARCHAR,
                "cloud_watch_metrics_enabled" BOOLEAN,
                "results_publishing_enabled" BOOLEAN
            ),
            "stop_job_on_failure_options" STRUCT(
                "stop_job_on_failure_timing" VARCHAR
            )
        ),
        "s3_catalog_hudi_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "additional_hudi_options" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "catalog_hudi_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "additional_hudi_options" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "s3_hudi_source" STRUCT(
            "name" VARCHAR,
            "paths" VARCHAR[],
            "additional_hudi_options" MAP(VARCHAR, VARCHAR),
            "additional_options" STRUCT(
                "bounded_size" BIGINT,
                "bounded_files" BIGINT,
                "enable_sample_path" BOOLEAN,
                "sample_path" VARCHAR
            ),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "s3_hudi_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "table" VARCHAR,
            "database" VARCHAR,
            "additional_options" MAP(VARCHAR, VARCHAR),
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR
            )
        ),
        "s3_hudi_direct_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "path" VARCHAR,
            "compression" VARCHAR,
            "partition_keys" VARCHAR[][],
            "format" VARCHAR,
            "additional_options" MAP(VARCHAR, VARCHAR),
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR,
                "table" VARCHAR,
                "database" VARCHAR
            )
        ),
        "direct_jdbc_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "connection_name" VARCHAR,
            "connection_type" VARCHAR,
            "redshift_tmp_dir" VARCHAR
        ),
        "s3_catalog_delta_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "additional_delta_options" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "catalog_delta_source" STRUCT(
            "name" VARCHAR,
            "database" VARCHAR,
            "table" VARCHAR,
            "additional_delta_options" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "s3_delta_source" STRUCT(
            "name" VARCHAR,
            "paths" VARCHAR[],
            "additional_delta_options" MAP(VARCHAR, VARCHAR),
            "additional_options" STRUCT(
                "bounded_size" BIGINT,
                "bounded_files" BIGINT,
                "enable_sample_path" BOOLEAN,
                "sample_path" VARCHAR
            ),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "s3_delta_catalog_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "table" VARCHAR,
            "database" VARCHAR,
            "additional_options" MAP(VARCHAR, VARCHAR),
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR
            )
        ),
        "s3_delta_direct_target" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "partition_keys" VARCHAR[][],
            "path" VARCHAR,
            "compression" VARCHAR,
            "format" VARCHAR,
            "additional_options" MAP(VARCHAR, VARCHAR),
            "schema_change_policy" STRUCT(
                "enable_update_catalog" BOOLEAN,
                "update_behavior" VARCHAR,
                "table" VARCHAR,
                "database" VARCHAR
            )
        ),
        "amazon_redshift_source" STRUCT(
            "name" VARCHAR,
            "data" STRUCT(
                "access_type" VARCHAR,
                "source_type" VARCHAR,
                "connection" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "schema" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "table" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "catalog_database" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "catalog_table" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "catalog_redshift_schema" VARCHAR,
                "catalog_redshift_table" VARCHAR,
                "temp_dir" VARCHAR,
                "iam_role" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "advanced_options" STRUCT(
                    "key" VARCHAR,
                    "value" VARCHAR
                )[],
                "sample_query" VARCHAR,
                "pre_action" VARCHAR,
                "post_action" VARCHAR,
                "action" VARCHAR,
                "table_prefix" VARCHAR,
                "upsert" BOOLEAN,
                "merge_action" VARCHAR,
                "merge_when_matched" VARCHAR,
                "merge_when_not_matched" VARCHAR,
                "merge_clause" VARCHAR,
                "crawler_connection" VARCHAR,
                "table_schema" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[],
                "staging_table" VARCHAR,
                "selected_columns" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[]
            )
        ),
        "amazon_redshift_target" STRUCT(
            "name" VARCHAR,
            "data" STRUCT(
                "access_type" VARCHAR,
                "source_type" VARCHAR,
                "connection" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "schema" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "table" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "catalog_database" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "catalog_table" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "catalog_redshift_schema" VARCHAR,
                "catalog_redshift_table" VARCHAR,
                "temp_dir" VARCHAR,
                "iam_role" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "advanced_options" STRUCT(
                    "key" VARCHAR,
                    "value" VARCHAR
                )[],
                "sample_query" VARCHAR,
                "pre_action" VARCHAR,
                "post_action" VARCHAR,
                "action" VARCHAR,
                "table_prefix" VARCHAR,
                "upsert" BOOLEAN,
                "merge_action" VARCHAR,
                "merge_when_matched" VARCHAR,
                "merge_when_not_matched" VARCHAR,
                "merge_clause" VARCHAR,
                "crawler_connection" VARCHAR,
                "table_schema" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[],
                "staging_table" VARCHAR,
                "selected_columns" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[]
            ),
            "inputs" VARCHAR[]
        ),
        "evaluate_data_quality_multi_frame" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "additional_data_sources" MAP(VARCHAR, VARCHAR),
            "ruleset" VARCHAR,
            "publishing_options" STRUCT(
                "evaluation_context" VARCHAR,
                "results_s3_prefix" VARCHAR,
                "cloud_watch_metrics_enabled" BOOLEAN,
                "results_publishing_enabled" BOOLEAN
            ),
            "additional_options" MAP(VARCHAR, VARCHAR),
            "stop_job_on_failure_options" STRUCT(
                "stop_job_on_failure_timing" VARCHAR
            )
        ),
        "recipe" STRUCT(
            "name" VARCHAR,
            "inputs" VARCHAR[],
            "recipe_reference" STRUCT(
                "recipe_arn" VARCHAR,
                "recipe_version" VARCHAR
            ),
            "recipe_steps" STRUCT(
                "action" STRUCT(
                    "operation" VARCHAR,
                    "parameters" MAP(VARCHAR, VARCHAR)
                ),
                "condition_expressions" STRUCT(
                    "condition" VARCHAR,
                    "value" VARCHAR,
                    "target_column" VARCHAR
                )[]
            )[]
        ),
        "snowflake_source" STRUCT(
            "name" VARCHAR,
            "data" STRUCT(
                "source_type" VARCHAR,
                "connection" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "schema" VARCHAR,
                "table" VARCHAR,
                "database" VARCHAR,
                "temp_dir" VARCHAR,
                "iam_role" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "additional_options" MAP(VARCHAR, VARCHAR),
                "sample_query" VARCHAR,
                "pre_action" VARCHAR,
                "post_action" VARCHAR,
                "action" VARCHAR,
                "upsert" BOOLEAN,
                "merge_action" VARCHAR,
                "merge_when_matched" VARCHAR,
                "merge_when_not_matched" VARCHAR,
                "merge_clause" VARCHAR,
                "staging_table" VARCHAR,
                "selected_columns" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[],
                "auto_pushdown" BOOLEAN,
                "table_schema" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[]
            ),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "snowflake_target" STRUCT(
            "name" VARCHAR,
            "data" STRUCT(
                "source_type" VARCHAR,
                "connection" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "schema" VARCHAR,
                "table" VARCHAR,
                "database" VARCHAR,
                "temp_dir" VARCHAR,
                "iam_role" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                ),
                "additional_options" MAP(VARCHAR, VARCHAR),
                "sample_query" VARCHAR,
                "pre_action" VARCHAR,
                "post_action" VARCHAR,
                "action" VARCHAR,
                "upsert" BOOLEAN,
                "merge_action" VARCHAR,
                "merge_when_matched" VARCHAR,
                "merge_when_not_matched" VARCHAR,
                "merge_clause" VARCHAR,
                "staging_table" VARCHAR,
                "selected_columns" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[],
                "auto_pushdown" BOOLEAN,
                "table_schema" STRUCT(
                    "value" VARCHAR,
                    "label" VARCHAR,
                    "description" VARCHAR
                )[]
            ),
            "inputs" VARCHAR[]
        ),
        "connector_data_source" STRUCT(
            "name" VARCHAR,
            "connection_type" VARCHAR,
            "data" MAP(VARCHAR, VARCHAR),
            "output_schemas" STRUCT(
                "columns" STRUCT(
                    "name" VARCHAR,
                    "type" VARCHAR
                )[]
            )[]
        ),
        "connector_data_target" STRUCT(
            "name" VARCHAR,
            "connection_type" VARCHAR,
            "data" MAP(VARCHAR, VARCHAR),
            "inputs" VARCHAR[]
        )
    ))
command

The JobCommand that runs this job.

STRUCT(
    "name" VARCHAR,
    "script_location" VARCHAR,
    "python_version" VARCHAR,
    "runtime" VARCHAR
)
Show child fields
command.name

The name of the job command. For an Apache Spark ETL job, this must be glueetl. For a Python shell job, it must be pythonshell. For an Apache Spark streaming ETL job, this must be gluestreaming. For a Ray job, this must be glueray.

command.python_version

The Python version being used to run a Python shell job. Allowed values are 2 or 3.

command.runtime

In Ray jobs, Runtime is used to specify the versions of Ray, Python and additional libraries available in your environment. This field is not used in other job types. For supported runtime environment values, see Supported Ray runtime environments in the Glue Developer Guide.

command.script_location

Specifies the Amazon Simple Storage Service (Amazon S3) path to a script that runs a job.

connections

The connections used for this job.

STRUCT(
    "connections" VARCHAR[]
)
Show child fields
connections.connections[]
created_on

The time and date that this job definition was created.

TIMESTAMP_S
default_arguments

The default arguments for every run of this job, specified as name-value pairs.

You can specify arguments here that your own job-execution script consumes, as well as arguments that Glue itself consumes.

Job arguments may be logged. Do not pass plaintext secrets as arguments. Retrieve secrets from a Glue Connection, Secrets Manager or other secret management mechanism if you intend to keep them within the Job.

For information about how to specify and consume your own Job arguments, see the Calling Glue APIs in Python topic in the developer guide.

For information about the arguments you can provide to this field when configuring Spark jobs, see the Special Parameters Used by Glue topic in the developer guide.

For information about the arguments you can provide to this field when configuring Ray jobs, see Using job parameters in Ray jobs in the developer guide.

MAP(VARCHAR, VARCHAR)
description

A description of the job.

VARCHAR
execution_class

Indicates whether the job is run with a standard or flexible execution class. The standard execution class is ideal for time-sensitive workloads that require fast job startup and dedicated resources.

The flexible execution class is appropriate for time-insensitive jobs whose start and completion times may vary.

Only jobs with Glue version 3.0 and above and command type glueetl will be allowed to set ExecutionClass to FLEX. The flexible execution class is available for Spark jobs.

VARCHAR
execution_property

An ExecutionProperty specifying the maximum number of concurrent runs allowed for this job.

STRUCT(
    "max_concurrent_runs" BIGINT
)
Show child fields
execution_property.max_concurrent_runs

The maximum number of concurrent runs allowed for the job. The default is 1. An error is returned when this threshold is reached. The maximum value you can specify is controlled by a service limit.

glue_version

In Spark jobs, GlueVersion determines the versions of Apache Spark and Python that Glue available in a job. The Python version indicates the version supported for jobs of type Spark.

Ray jobs should set GlueVersion to 4.0 or greater. However, the versions of Ray, Python and additional libraries available in your Ray job are determined by the Runtime parameter of the Job command.

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

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

VARCHAR
job_mode

A mode that describes how a job was created. Valid values are:

  • SCRIPT - The job was created using the Glue Studio script editor.

  • VISUAL - The job was created using the Glue Studio visual editor.

  • NOTEBOOK - The job was created using an interactive sessions notebook.

When the JobMode field is missing or null, SCRIPT is assigned as the default value.

VARCHAR
job_run_queuing_enabled

Specifies whether job run queuing is enabled for the job runs for this job.

A value of true means job run queuing is enabled for the job runs. If false or not populated, the job runs will not be considered for queueing.

If this field does not match the value set in the job run, then the value from the job run field will be used.

BOOLEAN
last_modified_on

The last point in time when this job definition was modified.

TIMESTAMP_S
log_uri

This field is reserved for future use.

VARCHAR
maintenance_window

This field specifies a day of the week and hour for a maintenance window for streaming jobs. Glue periodically performs maintenance activities. During these maintenance windows, Glue will need to restart your streaming jobs.

Glue will restart the job within 3 hours of the specified maintenance window. For instance, if you set up the maintenance window for Monday at 10:00AM GMT, your jobs will be restarted between 10:00AM GMT to 1:00PM GMT.

VARCHAR
max_capacity

For Glue version 1.0 or earlier jobs, using the standard worker type, the number of Glue data processing units (DPUs) that can be allocated when this job runs. A DPU is a relative measure of processing power that consists of 4 vCPUs of compute capacity and 16 GB of memory. For more information, see the Glue pricing page.

For Glue version 2.0 or later jobs, you cannot specify a Maximum capacity. Instead, you should specify a Worker type and the Number of workers.

Do not set MaxCapacity if using WorkerType and NumberOfWorkers.

The value that can be allocated for MaxCapacity depends on whether you are running a Python shell job, an Apache Spark ETL job, or an Apache Spark streaming ETL job:

  • When you specify a Python shell job (JobCommand.Name="pythonshell"), you can allocate either 0.0625 or 1 DPU. The default is 0.0625 DPU.

  • When you specify an Apache Spark ETL job (JobCommand.Name="glueetl") or Apache Spark streaming ETL job (JobCommand.Name="gluestreaming"), you can allocate from 2 to 100 DPUs. The default is 10 DPUs. This job type cannot have a fractional DPU allocation.

DOUBLE
max_retries

The maximum number of times to retry this job after a JobRun fails.

BIGINT
name

The name you assign to this job definition.

VARCHAR
non_overridable_arguments

Arguments for this job that are not overridden when providing job arguments in a job run, specified as name-value pairs.

MAP(VARCHAR, VARCHAR)
notification_property

Specifies configuration properties of a job notification.

STRUCT(
    "notify_delay_after" BIGINT
)
Show child fields
notification_property.notify_delay_after

After a job run starts, the number of minutes to wait before sending a job run delay notification.

number_of_workers

The number of workers of a defined workerType that are allocated when a job runs.

BIGINT
profile_name

The name of an Glue usage profile associated with the job.

VARCHAR
role

The name or Amazon Resource Name (ARN) of the IAM role associated with this job.

VARCHAR
security_configuration

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

VARCHAR
source_control_details

The details for a source control configuration for a job, allowing synchronization of job artifacts to or from a remote repository.

STRUCT(
    "provider" VARCHAR,
    "repository" VARCHAR,
    "owner" VARCHAR,
    "branch" VARCHAR,
    "folder" VARCHAR,
    "last_commit_id" VARCHAR,
    "auth_strategy" VARCHAR,
    "auth_token" VARCHAR
)
Show child fields
source_control_details.auth_strategy

The type of authentication, which can be an authentication token stored in Amazon Web Services Secrets Manager, or a personal access token.

source_control_details.auth_token

The value of an authorization token.

source_control_details.branch

An optional branch in the remote repository.

source_control_details.folder

An optional folder in the remote repository.

source_control_details.last_commit_id

The last commit ID for a commit in the remote repository.

source_control_details.owner

The owner of the remote repository that contains the job artifacts.

source_control_details.provider

The provider for the remote repository.

source_control_details.repository

The name of the remote repository that contains the job artifacts.

timeout

The job timeout in minutes. This is the maximum time that a job run can consume resources before it is terminated and enters TIMEOUT status. The default is 2,880 minutes (48 hours) for batch jobs.

Streaming jobs must have timeout values less than 7 days or 10080 minutes. When the value is left blank, the job will be restarted after 7 days based if you have not setup a maintenance window. If you have setup maintenance window, it will be restarted during the maintenance window after 7 days.

BIGINT
worker_type

The type of predefined worker that is allocated when a job runs. Accepts a value of G.1X, G.2X, G.4X, G.8X or G.025X for Spark jobs. Accepts the value Z.2X for Ray jobs.

  • For the G.1X worker type, each worker maps to 1 DPU (4 vCPUs, 16 GB of memory) with 84GB disk (approximately 34GB free), and provides 1 executor per worker. We recommend this worker type for workloads such as data transforms, joins, and queries, to offers a scalable and cost effective way to run most jobs.

  • For the G.2X worker type, each worker maps to 2 DPU (8 vCPUs, 32 GB of memory) with 128GB disk (approximately 77GB free), and provides 1 executor per worker. We recommend this worker type for workloads such as data transforms, joins, and queries, to offers a scalable and cost effective way to run most jobs.

  • For the G.4X worker type, each worker maps to 4 DPU (16 vCPUs, 64 GB of memory) with 256GB disk (approximately 235GB free), and provides 1 executor per worker. We recommend this worker type for jobs whose workloads contain your most demanding transforms, aggregations, joins, and queries. This worker type is available only for Glue version 3.0 or later Spark ETL jobs in the following Amazon Web Services Regions: US East (Ohio), US East (N. Virginia), US West (Oregon), Asia Pacific (Singapore), Asia Pacific (Sydney), Asia Pacific (Tokyo), Canada (Central), Europe (Frankfurt), Europe (Ireland), and Europe (Stockholm).

  • For the G.8X worker type, each worker maps to 8 DPU (32 vCPUs, 128 GB of memory) with 512GB disk (approximately 487GB free), and provides 1 executor per worker. We recommend this worker type for jobs whose workloads contain your most demanding transforms, aggregations, joins, and queries. This worker type is available only for Glue version 3.0 or later Spark ETL jobs, in the same Amazon Web Services Regions as supported for the G.4X worker type.

  • For the G.025X worker type, each worker maps to 0.25 DPU (2 vCPUs, 4 GB of memory) with 84GB disk (approximately 34GB free), and provides 1 executor per worker. We recommend this worker type for low volume streaming jobs. This worker type is only available for Glue version 3.0 streaming jobs.

  • For the Z.2X worker type, each worker maps to 2 M-DPU (8vCPUs, 64 GB of memory) with 128 GB disk (approximately 120GB free), and provides up to 8 Ray workers based on the autoscaler.

VARCHAR