Skip to content

aws.forecast.describe_dataset_import_job

Example SQL Queries

SELECT * FROM
aws.forecast.describe_dataset_import_job
WHERE
"dataset_import_job_arn" = 'VALUE';

Description

Describes a dataset import job created using the CreateDatasetImportJob operation.

In addition to listing the parameters provided in the CreateDatasetImportJob request, this operation includes the following properties:

  • CreationTime

  • LastModificationTime

  • DataSize

  • FieldStatistics

  • Status

  • Message - If an error occurred, information about the error.

Table Definition

Column NameColumn Data Type
dataset_import_job_arn Required Input Column

The ARN of the dataset import 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
creation_time

When the dataset import job was created.

TIMESTAMP_S
data_size

The size of the dataset in gigabytes (GB) after the import job has finished.

DOUBLE
data_source

The location of the training data to import and an Identity and Access Management (IAM) role that Amazon Forecast can assume to access the data.

If encryption is used, DataSource includes an Key Management Service (KMS) key.

STRUCT(
"s3_config" STRUCT(
"path" VARCHAR,
"role_arn" VARCHAR,
"kms_key_arn" VARCHAR
)
)
Show child fields
data_source.s3_config

The path to the data stored in an Amazon Simple Storage Service (Amazon S3) bucket along with the credentials to access the data.

Show child fields
data_source.s3_config.kms_key_arn

The Amazon Resource Name (ARN) of an Key Management Service (KMS) key.

data_source.s3_config.path

The path to an Amazon Simple Storage Service (Amazon S3) bucket or file(s) in an Amazon S3 bucket.

data_source.s3_config.role_arn

The ARN of the Identity and Access Management (IAM) role that Amazon Forecast can assume to access the Amazon S3 bucket or files. If you provide a value for the KMSKeyArn key, the role must allow access to the key.

Passing a role across Amazon Web Services accounts is not allowed. If you pass a role that isn't in your account, you get an InvalidInputException error.

dataset_arn

The Amazon Resource Name (ARN) of the dataset that the training data was imported to.

VARCHAR
dataset_import_job_name

The name of the dataset import job.

VARCHAR
estimated_time_remaining_in_minutes

The estimated time remaining in minutes for the dataset import job to complete.

BIGINT
field_statistics

Statistical information about each field in the input data.

MAP(VARCHAR, STRUCT(
"count" BIGINT,
"count_distinct" BIGINT,
"count_null" BIGINT,
"count_nan" BIGINT,
"min" VARCHAR,
"max" VARCHAR,
"avg" DOUBLE,
"stddev" DOUBLE,
"count_long" BIGINT,
"count_distinct_long" BIGINT,
"count_null_long" BIGINT,
"count_nan_long" BIGINT
))
format

The format of the imported data, CSV or PARQUET.

VARCHAR
geolocation_format

The format of the geolocation attribute. Valid Values:"LAT_LONG" and "CC_POSTALCODE".

VARCHAR
import_mode

The import mode of the dataset import job, FULL or INCREMENTAL.

VARCHAR
last_modification_time

The last time the resource was modified. The timestamp depends on the status of the job:

  • CREATE_PENDING - The CreationTime.

  • CREATE_IN_PROGRESS - The current timestamp.

  • CREATE_STOPPING - The current timestamp.

  • CREATE_STOPPED - When the job stopped.

  • ACTIVE or CREATE_FAILED - When the job finished or failed.

TIMESTAMP_S
message

If an error occurred, an informational message about the error.

VARCHAR
status

The status of the dataset import job. States include:

  • ACTIVE

  • CREATE_PENDING, CREATE_IN_PROGRESS, CREATE_FAILED

  • DELETE_PENDING, DELETE_IN_PROGRESS, DELETE_FAILED

  • CREATE_STOPPING, CREATE_STOPPED

VARCHAR
time_zone

The single time zone applied to every item in the dataset

VARCHAR
timestamp_format

The format of timestamps in the dataset. The format that you specify depends on the DataFrequency specified when the dataset was created. The following formats are supported

  • "yyyy-MM-dd"

    For the following data frequencies: Y, M, W, and D

  • "yyyy-MM-dd HH:mm:ss"

    For the following data frequencies: H, 30min, 15min, and 1min; and optionally, for: Y, M, W, and D

VARCHAR
use_geolocation_for_time_zone

Whether TimeZone is automatically derived from the geolocation attribute.

BOOLEAN