Skip to content
AWS for Query.Farm

aws.dataexchange.get_job

Example SQL Queries

SELECT * FROM
aws.dataexchange.get_job
WHERE
"job_id" = 'VALUE';

Description

This operation returns information about a job.

Table Definition

Column NameColumn Data Type
job_id Required Input Column

The unique identifier for a job.

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
arn

The ARN for the job.

VARCHAR
created_at

The date and time that the job was created, in ISO 8601 format.

TIMESTAMP_S
details

Details about the job.

STRUCT(
    "export_asset_to_signed_url" STRUCT(
        "asset_id" VARCHAR,
        "data_set_id" VARCHAR,
        "revision_id" VARCHAR,
        "signed_url" VARCHAR,
        "signed_url_expires_at" TIMESTAMP_S
    ),
    "export_assets_to_s3" STRUCT(
        "asset_destinations" STRUCT(
            "asset_id" VARCHAR,
            "bucket" VARCHAR,
            "key" VARCHAR
        )[],
        "data_set_id" VARCHAR,
        "encryption" STRUCT(
            "kms_key_arn" VARCHAR,
            "type" VARCHAR
        ),
        "revision_id" VARCHAR
    ),
    "export_revisions_to_s3" STRUCT(
        "data_set_id" VARCHAR,
        "encryption" STRUCT(
            "kms_key_arn" VARCHAR,
            "type" VARCHAR
        ),
        "revision_destinations" STRUCT(
            "bucket" VARCHAR,
            "key_pattern" VARCHAR,
            "revision_id" VARCHAR
        )[],
        "event_action_arn" VARCHAR
    ),
    "import_asset_from_signed_url" STRUCT(
        "asset_name" VARCHAR,
        "data_set_id" VARCHAR,
        "md5_hash" VARCHAR,
        "revision_id" VARCHAR,
        "signed_url" VARCHAR,
        "signed_url_expires_at" TIMESTAMP_S
    ),
    "import_assets_from_s3" STRUCT(
        "asset_sources" STRUCT(
            "bucket" VARCHAR,
            "key" VARCHAR
        )[],
        "data_set_id" VARCHAR,
        "revision_id" VARCHAR
    ),
    "import_assets_from_redshift_data_shares" STRUCT(
        "asset_sources" STRUCT(
            "data_share_arn" VARCHAR
        )[],
        "data_set_id" VARCHAR,
        "revision_id" VARCHAR
    ),
    "import_asset_from_api_gateway_api" STRUCT(
        "api_description" VARCHAR,
        "api_id" VARCHAR,
        "api_key" VARCHAR,
        "api_name" VARCHAR,
        "api_specification_md5_hash" VARCHAR,
        "api_specification_upload_url" VARCHAR,
        "api_specification_upload_url_expires_at" TIMESTAMP_S,
        "data_set_id" VARCHAR,
        "protocol_type" VARCHAR,
        "revision_id" VARCHAR,
        "stage" VARCHAR
    ),
    "create_s3_data_access_from_s3_bucket" STRUCT(
        "asset_source" STRUCT(
            "bucket" VARCHAR,
            "key_prefixes" VARCHAR[],
            "keys" VARCHAR[],
            "kms_keys_to_grant" STRUCT(
                "kms_key_arn" VARCHAR
            )[]
        ),
        "data_set_id" VARCHAR,
        "revision_id" VARCHAR
    ),
    "import_assets_from_lake_formation_tag_policy" STRUCT(
        "catalog_id" VARCHAR,
        "database" STRUCT(
            "expression" STRUCT(
                "tag_key" VARCHAR,
                "tag_values" VARCHAR[]
            )[],
            "permissions" VARCHAR[]
        ),
        "table" STRUCT(
            "expression" STRUCT(
                "tag_key" VARCHAR,
                "tag_values" VARCHAR[]
            )[],
            "permissions" VARCHAR[]
        ),
        "role_arn" VARCHAR,
        "data_set_id" VARCHAR,
        "revision_id" VARCHAR
    )
)
Show child fields
details.create_s3_data_access_from_s3_bucket

Response details from the CreateS3DataAccessFromS3Bucket job.

Show child fields
details.create_s3_data_access_from_s3_bucket.asset_source

Details about the asset source from an Amazon S3 bucket.

Show child fields
details.create_s3_data_access_from_s3_bucket.asset_source.bucket

The Amazon S3 bucket used for hosting shared data in the Amazon S3 data access.

details.create_s3_data_access_from_s3_bucket.asset_source.key_prefixes[]
details.create_s3_data_access_from_s3_bucket.asset_source.keys[]
details.create_s3_data_access_from_s3_bucket.asset_source.kms_keys_to_grant[]
Show child fields
details.create_s3_data_access_from_s3_bucket.asset_source.kms_keys_to_grant[].kms_key_arn

The AWS KMS CMK (Key Management System Customer Managed Key) used to encrypt S3 objects in the shared S3 Bucket. AWS Data exchange will create a KMS grant for each subscriber to allow them to access and decrypt their entitled data that is encrypted using this KMS key specified.

details.create_s3_data_access_from_s3_bucket.data_set_id

The unique identifier for this data set.

details.create_s3_data_access_from_s3_bucket.revision_id

The unique identifier for the revision.

details.export_asset_to_signed_url

Details for the export to signed URL response.

Show child fields
details.export_asset_to_signed_url.asset_id

The unique identifier for the asset associated with this export job.

details.export_asset_to_signed_url.data_set_id

The unique identifier for the data set associated with this export job.

details.export_asset_to_signed_url.revision_id

The unique identifier for the revision associated with this export response.

details.export_asset_to_signed_url.signed_url

The signed URL for the export request.

details.export_asset_to_signed_url.signed_url_expires_at

The date and time that the signed URL expires, in ISO 8601 format.

details.export_assets_to_s3

Details for the export to Amazon S3 response.

Show child fields
details.export_assets_to_s3.asset_destinations[]
Show child fields
details.export_assets_to_s3.asset_destinations[].asset_id

The unique identifier for the asset.

details.export_assets_to_s3.asset_destinations[].bucket

The Amazon S3 bucket that is the destination for the asset.

details.export_assets_to_s3.asset_destinations[].key

The name of the object in Amazon S3 for the asset.

details.export_assets_to_s3.data_set_id

The unique identifier for the data set associated with this export job.

details.export_assets_to_s3.encryption

Encryption configuration of the export job.

Show child fields
details.export_assets_to_s3.encryption.kms_key_arn

The Amazon Resource Name (ARN) of the AWS KMS key you want to use to encrypt the Amazon S3 objects. This parameter is required if you choose aws:kms as an encryption type.

details.export_assets_to_s3.encryption.type

The type of server side encryption used for encrypting the objects in Amazon S3.

details.export_assets_to_s3.revision_id

The unique identifier for the revision associated with this export response.

details.export_revisions_to_s3

Details for the export revisions to Amazon S3 response.

Show child fields
details.export_revisions_to_s3.data_set_id

The unique identifier for the data set associated with this export job.

details.export_revisions_to_s3.encryption

Encryption configuration of the export job.

Show child fields
details.export_revisions_to_s3.encryption.kms_key_arn

The Amazon Resource Name (ARN) of the AWS KMS key you want to use to encrypt the Amazon S3 objects. This parameter is required if you choose aws:kms as an encryption type.

details.export_revisions_to_s3.encryption.type

The type of server side encryption used for encrypting the objects in Amazon S3.

details.export_revisions_to_s3.event_action_arn

The Amazon Resource Name (ARN) of the event action.

details.export_revisions_to_s3.revision_destinations[]
Show child fields
details.export_revisions_to_s3.revision_destinations[].bucket

The Amazon S3 bucket that is the destination for the assets in the revision.

details.export_revisions_to_s3.revision_destinations[].key_pattern

A string representing the pattern for generated names of the individual assets in the revision. For more information about key patterns, see Key patterns when exporting revisions.

details.export_revisions_to_s3.revision_destinations[].revision_id

The unique identifier for the revision.

details.import_asset_from_api_gateway_api

The response details.

Show child fields
details.import_asset_from_api_gateway_api.api_description

The API description.

details.import_asset_from_api_gateway_api.api_id

The API ID.

details.import_asset_from_api_gateway_api.api_key

The API key.

details.import_asset_from_api_gateway_api.api_name

The API name.

details.import_asset_from_api_gateway_api.api_specification_md5_hash

The Base64-encoded Md5 hash for the API asset, used to ensure the integrity of the API at that location.

details.import_asset_from_api_gateway_api.api_specification_upload_url

The upload URL of the API specification.

details.import_asset_from_api_gateway_api.api_specification_upload_url_expires_at

The date and time that the upload URL expires, in ISO 8601 format.

details.import_asset_from_api_gateway_api.data_set_id

The data set ID.

details.import_asset_from_api_gateway_api.protocol_type

The protocol type.

details.import_asset_from_api_gateway_api.revision_id

The revision ID.

details.import_asset_from_api_gateway_api.stage

The API stage.

details.import_asset_from_signed_url

Details for the import from signed URL response.

Show child fields
details.import_asset_from_signed_url.asset_name

The name for the asset associated with this import job.

details.import_asset_from_signed_url.data_set_id

The unique identifier for the data set associated with this import job.

details.import_asset_from_signed_url.md5_hash

The Base64-encoded Md5 hash for the asset, used to ensure the integrity of the file at that location.

details.import_asset_from_signed_url.revision_id

The unique identifier for the revision associated with this import response.

details.import_asset_from_signed_url.signed_url

The signed URL.

details.import_asset_from_signed_url.signed_url_expires_at

The time and date at which the signed URL expires, in ISO 8601 format.

details.import_assets_from_lake_formation_tag_policy

Response details from the ImportAssetsFromLakeFormationTagPolicy job.

Show child fields
details.import_assets_from_lake_formation_tag_policy.catalog_id

The identifier for the AWS Glue Data Catalog.

details.import_assets_from_lake_formation_tag_policy.data_set_id

The unique identifier for the data set associated with this import job.

details.import_assets_from_lake_formation_tag_policy.database

A structure for the database object.

Show child fields
details.import_assets_from_lake_formation_tag_policy.database.expression[]
Show child fields
details.import_assets_from_lake_formation_tag_policy.database.expression[].tag_key

The key name for the LF-tag.

details.import_assets_from_lake_formation_tag_policy.database.expression[].tag_values[]
details.import_assets_from_lake_formation_tag_policy.database.permissions[]
details.import_assets_from_lake_formation_tag_policy.revision_id

The unique identifier for the revision associated with this import job.

details.import_assets_from_lake_formation_tag_policy.role_arn

The IAM role's ARN that allows AWS Data Exchange to assume the role and grant and revoke permissions to AWS Lake Formation data permissions.

details.import_assets_from_lake_formation_tag_policy.table

A structure for the table object.

Show child fields
details.import_assets_from_lake_formation_tag_policy.table.expression[]
Show child fields
details.import_assets_from_lake_formation_tag_policy.table.expression[].tag_key

The key name for the LF-tag.

details.import_assets_from_lake_formation_tag_policy.table.expression[].tag_values[]
details.import_assets_from_lake_formation_tag_policy.table.permissions[]
details.import_assets_from_redshift_data_shares

Details from an import from Amazon Redshift datashare response.

Show child fields
details.import_assets_from_redshift_data_shares.asset_sources[]
Show child fields
details.import_assets_from_redshift_data_shares.asset_sources[].data_share_arn

The Amazon Resource Name (ARN) of the datashare asset.

details.import_assets_from_redshift_data_shares.data_set_id

The unique identifier for the data set associated with this import job.

details.import_assets_from_redshift_data_shares.revision_id

The unique identifier for the revision associated with this import job.

details.import_assets_from_s3

Details for the import from Amazon S3 response.

Show child fields
details.import_assets_from_s3.asset_sources[]
Show child fields
details.import_assets_from_s3.asset_sources[].bucket

The Amazon S3 bucket that's part of the source of the asset.

details.import_assets_from_s3.asset_sources[].key

The name of the object in Amazon S3 for the asset.

details.import_assets_from_s3.data_set_id

The unique identifier for the data set associated with this import job.

details.import_assets_from_s3.revision_id

The unique identifier for the revision associated with this import response.

errors

The errors associated with jobs.

STRUCT(
    "code" VARCHAR,
    "details" STRUCT(
        "import_asset_from_signed_url_job_error_details" STRUCT(
            "asset_name" VARCHAR
        ),
        "import_assets_from_s3_job_error_details" STRUCT(
            "bucket" VARCHAR,
            "key" VARCHAR
        )[]
    ),
    "limit_name" VARCHAR,
    "limit_value" DOUBLE,
    "message" VARCHAR,
    "resource_id" VARCHAR,
    "resource_type" VARCHAR
)[]
Show child fields
errors[]
Show child fields
errors[].code

The code for the job error.

errors[].details

The details about the job error.

Show child fields
errors[].details.import_asset_from_signed_url_job_error_details

Information about the job error.

Show child fields
errors[].details.import_asset_from_signed_url_job_error_details.asset_name

Details about the job error.

errors[].details.import_assets_from_s3_job_error_details[]
Show child fields
errors[].details.import_assets_from_s3_job_error_details[].bucket

The Amazon S3 bucket that's part of the source of the asset.

errors[].details.import_assets_from_s3_job_error_details[].key

The name of the object in Amazon S3 for the asset.

errors[].limit_name

The name of the limit that was reached.

errors[].limit_value

The value of the exceeded limit.

errors[].message

The message related to the job error.

errors[].resource_id

The unique identifier for the resource related to the error.

errors[].resource_type

The type of resource related to the error.

id

The unique identifier for the job.

VARCHAR
state

The state of the job.

VARCHAR
type

The job type.

VARCHAR
updated_at

The date and time that the job was last updated, in ISO 8601 format.

TIMESTAMP_S