Skip to content
AWS for Query.Farm

aws.comprehendmedical.list_snomedct_inference_jobs

Example SQL Queries

SELECT * FROM
aws.comprehendmedical.list_snomedct_inference_jobs;

Description

Gets a list of InferSNOMEDCT jobs a user has submitted.

Table Definition

Column NameColumn Data Type
filter Input Column

Provides information for filtering a list of detection jobs.

STRUCT(
    "job_name" VARCHAR,
    "job_status" VARCHAR,
    "submit_time_before" TIMESTAMP_S,
    "submit_time_after" TIMESTAMP_S
)
Show child fields
filter.job_name

Filters on the name of the job.

filter.job_status

Filters the list of jobs based on job status. Returns only jobs with the specified status.

filter.submit_time_after

Filters the list of jobs based on the time that the job was submitted for processing. Returns only jobs submitted after the specified time. Jobs are returned in descending order, newest to oldest.

filter.submit_time_before

Filters the list of jobs based on the time that the job was submitted for processing. Returns only jobs submitted before the specified time. Jobs are returned in ascending order, oldest to newest.

max_results Input Column

The maximum number of results to return in each page. The default is 100. 

BIGINT
next_token Input Column

Identifies the next page of results to return. 

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
comprehend_medical_async_job_properties_list

A list containing the properties of each job that is returned. 

STRUCT(
    "job_id" VARCHAR,
    "job_name" VARCHAR,
    "job_status" VARCHAR,
    "message" VARCHAR,
    "submit_time" TIMESTAMP_S,
    "end_time" TIMESTAMP_S,
    "expiration_time" TIMESTAMP_S,
    "input_data_config" STRUCT(
        "s3_bucket" VARCHAR,
        "s3_key" VARCHAR
    ),
    "output_data_config" STRUCT(
        "s3_bucket" VARCHAR,
        "s3_key" VARCHAR
    ),
    "language_code" VARCHAR,
    "data_access_role_arn" VARCHAR,
    "manifest_file_path" VARCHAR,
    "kms_key" VARCHAR,
    "model_version" VARCHAR
)[]
Show child fields
comprehend_medical_async_job_properties_list[]
Show child fields
comprehend_medical_async_job_properties_list[].data_access_role_arn

The Amazon Resource Name (ARN) that gives Amazon Comprehend Medical read access to your input data.

comprehend_medical_async_job_properties_list[].end_time

The time that the detection job completed.

comprehend_medical_async_job_properties_list[].expiration_time

The date and time that job metadata is deleted from the server. Output files in your S3 bucket will not be deleted. After the metadata is deleted, the job will no longer appear in the results of the ListEntitiesDetectionV2Job or the ListPHIDetectionJobs operation.

comprehend_medical_async_job_properties_list[].input_data_config

The input data configuration that you supplied when you created the detection job.

Show child fields
comprehend_medical_async_job_properties_list[].input_data_config.s3_bucket

The URI of the S3 bucket that contains the input data. The bucket must be in the same region as the API endpoint that you are calling.

comprehend_medical_async_job_properties_list[].input_data_config.s3_key

The path to the input data files in the S3 bucket.

comprehend_medical_async_job_properties_list[].job_id

The identifier assigned to the detection job.

comprehend_medical_async_job_properties_list[].job_name

The name that you assigned to the detection job.

comprehend_medical_async_job_properties_list[].job_status

The current status of the detection job. If the status is FAILED, the Message field shows the reason for the failure.

comprehend_medical_async_job_properties_list[].kms_key

The AWS Key Management Service key, if any, used to encrypt the output files.

comprehend_medical_async_job_properties_list[].language_code

The language code of the input documents.

comprehend_medical_async_job_properties_list[].manifest_file_path

The path to the file that describes the results of a batch job.

comprehend_medical_async_job_properties_list[].message

A description of the status of a job.

comprehend_medical_async_job_properties_list[].model_version

The version of the model used to analyze the documents. The version number looks like X.X.X. You can use this information to track the model used for a particular batch of documents.

comprehend_medical_async_job_properties_list[].output_data_config

The output data configuration that you supplied when you created the detection job.

Show child fields
comprehend_medical_async_job_properties_list[].output_data_config.s3_bucket

When you use the OutputDataConfig object with asynchronous operations, you specify the Amazon S3 location where you want to write the output data. The URI must be in the same region as the API endpoint that you are calling. The location is used as the prefix for the actual location of the output.

comprehend_medical_async_job_properties_list[].output_data_config.s3_key

The path to the output data files in the S3 bucket. Amazon Comprehend Medical creates an output directory using the job ID so that the output from one job does not overwrite the output of another.

comprehend_medical_async_job_properties_list[].submit_time

The time that the detection job was submitted for processing.