Skip to content
AWS for Query.Farm

aws.glue.get_trigger

Example SQL Queries

SELECT * FROM
aws.glue.get_trigger
WHERE
"name" = 'VALUE';

Description

Retrieves the definition of a trigger.

Table Definition

Column NameColumn Data Type
name Required Input Column

The name of the trigger to retrieve.

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
trigger

The requested trigger definition.

STRUCT(
    "name" VARCHAR,
    "workflow_name" VARCHAR,
    "id" VARCHAR,
    "type" VARCHAR,
    "state" VARCHAR,
    "description" VARCHAR,
    "schedule" VARCHAR,
    "actions" STRUCT(
        "job_name" VARCHAR,
        "arguments" MAP(VARCHAR, VARCHAR),
        "timeout" BIGINT,
        "security_configuration" VARCHAR,
        "notification_property" STRUCT(
            "notify_delay_after" BIGINT
        ),
        "crawler_name" VARCHAR
    )[],
    "predicate" STRUCT(
        "logical" VARCHAR,
        "conditions" STRUCT(
            "logical_operator" VARCHAR,
            "job_name" VARCHAR,
            "state" VARCHAR,
            "crawler_name" VARCHAR,
            "crawl_state" VARCHAR
        )[]
    ),
    "event_batching_condition" STRUCT(
        "batch_size" BIGINT,
        "batch_window" BIGINT
    )
)
Show child fields
trigger.actions[]
Show child fields
trigger.actions[].arguments

The job arguments used when this trigger fires. For this job run, they replace the default arguments set in the job definition itself.

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

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 key-value pairs that Glue consumes to set up your job, see the Special Parameters Used by Glue topic in the developer guide.

trigger.actions[].crawler_name

The name of the crawler to be used with this action.

trigger.actions[].job_name

The name of a job to be run.

trigger.actions[].notification_property

Specifies configuration properties of a job run notification.

Show child fields
trigger.actions[].notification_property.notify_delay_after

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

trigger.actions[].security_configuration

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

trigger.actions[].timeout

The JobRun 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). This overrides the timeout value set in the parent job.

trigger.description

A description of this trigger.

trigger.event_batching_condition

Batch condition that must be met (specified number of events received or batch time window expired) before EventBridge event trigger fires.

Show child fields
trigger.event_batching_condition.batch_size

Number of events that must be received from Amazon EventBridge before EventBridge event trigger fires.

trigger.event_batching_condition.batch_window

Window of time in seconds after which EventBridge event trigger fires. Window starts when first event is received.

trigger.id

Reserved for future use.

trigger.name

The name of the trigger.

trigger.predicate

The predicate of this trigger, which defines when it will fire.

Show child fields
trigger.predicate.conditions[]
Show child fields
trigger.predicate.conditions[].crawl_state

The state of the crawler to which this condition applies.

trigger.predicate.conditions[].crawler_name

The name of the crawler to which this condition applies.

trigger.predicate.conditions[].job_name

The name of the job whose JobRuns this condition applies to, and on which this trigger waits.

trigger.predicate.conditions[].logical_operator

A logical operator.

trigger.predicate.conditions[].state

The condition state. Currently, the only job states that a trigger can listen for are SUCCEEDED, STOPPED, FAILED, and TIMEOUT. The only crawler states that a trigger can listen for are SUCCEEDED, FAILED, and CANCELLED.

trigger.predicate.logical

An optional field if only one condition is listed. If multiple conditions are listed, then this field is required.

trigger.schedule

A cron expression used to specify the schedule (see Time-Based Schedules for Jobs and Crawlers. For example, to run something every day at 12:15 UTC, you would specify: cron(15 12 * * ? *).

trigger.state

The current state of the trigger.

trigger.type

The type of trigger that this is.

trigger.workflow_name

The name of the workflow associated with the trigger.