Skip to content
AWS for Query.Farm

aws.importexport.get_status

Example SQL Queries

SELECT * FROM
aws.importexport.get_status
WHERE
"job_id" = 'VALUE';

Description

This operation returns information about a job, including where the job is in the processing pipeline, the status of the results, and the signature value associated with the job. You can only return information about jobs you own.

Table Definition

Column NameColumn Data Type
job_id Required Input Column

A unique identifier which refers to a particular job.

VARCHAR
api_version Input Column

Specifies the version of the client tool.

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.

artifact_list

A collection of artifacts.

STRUCT(
    "description" VARCHAR,
    "url" VARCHAR
)[]
Show child fields
artifact_list[]
Show child fields
artifact_list[].description

The associated description for this object.

artifact_list[].url

The URL for a given Artifact.

carrier

Name of the shipping company. This value is included when the LocationCode is "Returned".

VARCHAR
creation_date

Timestamp of the CreateJob request in ISO8601 date format. For example "2010-03-28T20:27:35Z".

TIMESTAMP_S
current_manifest

The last manifest submitted, which will be used to process the job.

VARCHAR
error_count

Number of errors. We return this value when the ProgressCode is Success or SuccessWithErrors.

BIGINT
job_type

Specifies whether the job to initiate is an import or export job.

VARCHAR
location_code

A token representing the location of the storage device, such as "AtAWS".

VARCHAR
location_message

A more human readable form of the physical location of the storage device.

VARCHAR
log_bucket

Amazon S3 bucket for user logs.

VARCHAR
log_key

The key where the user logs were stored.

VARCHAR
progress_code

A token representing the state of the job, such as "Started".

VARCHAR
progress_message

A more human readable form of the job status.

VARCHAR
signature

An encrypted code used to authenticate the request and response, for example, "DV+TpDfx1/TdSE9ktyK9k/bDTVI=". Only use this value is you want to create the signature file yourself. Generally you should use the SignatureFileContents value.

VARCHAR
signature_file_contents

An encrypted code used to authenticate the request and response, for example, "DV+TpDfx1/TdSE9ktyK9k/bDTVI=". Only use this value is you want to create the signature file yourself. Generally you should use the SignatureFileContents value.

VARCHAR
tracking_number

The shipping tracking number assigned by AWS Import/Export to the storage device when it's returned to you. We return this value when the LocationCode is "Returned".

VARCHAR