Skip to content
AWS for Query.Farm

aws.emr.describe_notebook_execution

Example SQL Queries

SELECT * FROM
aws.emr.describe_notebook_execution
WHERE
"notebook_execution_id" = 'VALUE';

Description

Provides details of a notebook execution.

Table Definition

Column NameColumn Data Type
notebook_execution_id Required Input Column

The unique identifier of the notebook execution.

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.

notebook_execution

Properties of the notebook execution.

STRUCT(
    "notebook_execution_id" VARCHAR,
    "editor_id" VARCHAR,
    "execution_engine" STRUCT(
        "id" VARCHAR,
        "type" VARCHAR,
        "master_instance_security_group_id" VARCHAR,
        "execution_role_arn" VARCHAR
    ),
    "notebook_execution_name" VARCHAR,
    "notebook_params" VARCHAR,
    "status" VARCHAR,
    "start_time" TIMESTAMP_S,
    "end_time" TIMESTAMP_S,
    "arn" VARCHAR,
    "output_notebook_uri" VARCHAR,
    "last_state_change_reason" VARCHAR,
    "notebook_instance_security_group_id" VARCHAR,
    "tags" STRUCT(
        "key" VARCHAR,
        "value" VARCHAR
    )[],
    "notebook_s3_location" STRUCT(
        "bucket" VARCHAR,
        "key" VARCHAR
    ),
    "output_notebook_s3_location" STRUCT(
        "bucket" VARCHAR,
        "key" VARCHAR
    ),
    "output_notebook_format" VARCHAR,
    "environment_variables" MAP(VARCHAR, VARCHAR)
)
Show child fields
notebook_execution.arn

The Amazon Resource Name (ARN) of the notebook execution.

notebook_execution.editor_id

The unique identifier of the Amazon EMR Notebook that is used for the notebook execution.

notebook_execution.end_time

The timestamp when notebook execution ended.

notebook_execution.environment_variables

The environment variables associated with the notebook execution.

notebook_execution.execution_engine

The execution engine, such as an Amazon EMR cluster, used to run the Amazon EMR notebook and perform the notebook execution.

Show child fields
notebook_execution.execution_engine.execution_role_arn

The execution role ARN required for the notebook execution.

notebook_execution.execution_engine.id

The unique identifier of the execution engine. For an Amazon EMR cluster, this is the cluster ID.

notebook_execution.execution_engine.master_instance_security_group_id

An optional unique ID of an Amazon EC2 security group to associate with the master instance of the Amazon EMR cluster for this notebook execution. For more information see Specifying Amazon EC2 Security Groups for Amazon EMR Notebooks in the EMR Management Guide.

notebook_execution.execution_engine.type

The type of execution engine. A value of EMR specifies an Amazon EMR cluster.

notebook_execution.last_state_change_reason

The reason for the latest status change of the notebook execution.

notebook_execution.notebook_execution_id

The unique identifier of a notebook execution.

notebook_execution.notebook_execution_name

A name for the notebook execution.

notebook_execution.notebook_instance_security_group_id

The unique identifier of the Amazon EC2 security group associated with the Amazon EMR Notebook instance. For more information see Specifying Amazon EC2 Security Groups for Amazon EMR Notebooks in the Amazon EMR Management Guide.

notebook_execution.notebook_params

Input parameters in JSON format passed to the Amazon EMR Notebook at runtime for execution.

notebook_execution.notebook_s3_location

The Amazon S3 location that stores the notebook execution input.

Show child fields
notebook_execution.notebook_s3_location.bucket

The Amazon S3 bucket that stores the notebook execution input.

notebook_execution.notebook_s3_location.key

The key to the Amazon S3 location that stores the notebook execution input.

notebook_execution.output_notebook_format

The output format for the notebook execution.

notebook_execution.output_notebook_s3_location

The Amazon S3 location for the notebook execution output.

Show child fields
notebook_execution.output_notebook_s3_location.bucket

The Amazon S3 bucket that stores the notebook execution output.

notebook_execution.output_notebook_s3_location.key

The key to the Amazon S3 location that stores the notebook execution output.

notebook_execution.output_notebook_uri

The location of the notebook execution's output file in Amazon S3.

notebook_execution.start_time

The timestamp when notebook execution started.

notebook_execution.status

The status of the notebook execution.

  • START_PENDING indicates that the cluster has received the execution request but execution has not begun.

  • STARTING indicates that the execution is starting on the cluster.

  • RUNNING indicates that the execution is being processed by the cluster.

  • FINISHING indicates that execution processing is in the final stages.

  • FINISHED indicates that the execution has completed without error.

  • FAILING indicates that the execution is failing and will not finish successfully.

  • FAILED indicates that the execution failed.

  • STOP_PENDING indicates that the cluster has received a StopNotebookExecution request and the stop is pending.

  • STOPPING indicates that the cluster is in the process of stopping the execution as a result of a StopNotebookExecution request.

  • STOPPED indicates that the execution stopped because of a StopNotebookExecution request.

notebook_execution.tags[]
Show child fields
notebook_execution.tags[].key

A user-defined key, which is the minimum required information for a valid tag. For more information, see Tag.

notebook_execution.tags[].value

A user-defined value, which is optional in a tag. For more information, see Tag Clusters.