| Column Name | Column Data Type |
|---|
job_id Required Input Column
The job's ID. | 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 |
annotation_fields
The annotation schema generated by the parsed annotation data. | MAP(VARCHAR, VARCHAR) |
completion_time
When the job completed. | TIMESTAMP_S |
creation_time
When the job was created. | TIMESTAMP_S |
destination_name
The job's destination annotation store. | VARCHAR |
format_options
Formatting options for a file. | STRUCT(
"tsv_options" STRUCT(
"read_options" STRUCT(
"sep" VARCHAR,
"encoding" VARCHAR,
"quote" VARCHAR,
"quote_all" BOOLEAN,
"escape" VARCHAR,
"escape_quotes" BOOLEAN,
"comment" VARCHAR,
"header" BOOLEAN,
"line_sep" VARCHAR
)
),
"vcf_options" STRUCT(
"ignore_qual_field" BOOLEAN,
"ignore_filter_field" BOOLEAN
)
) |
Show child fields- format_options.tsv_options
Options for a TSV file. Show child fields- format_options.tsv_options.read_options
The file's read options. Show child fields- format_options.tsv_options.read_options.comment
The file's comment character. - format_options.tsv_options.read_options.encoding
The file's encoding. - format_options.tsv_options.read_options.escape
A character for escaping quotes in the file. - format_options.tsv_options.read_options.escape_quotes
Whether quotes need to be escaped in the file. - format_options.tsv_options.read_options.header
Whether the file has a header row. - format_options.tsv_options.read_options.line_sep
A line separator for the file. - format_options.tsv_options.read_options.quote
The file's quote character. - format_options.tsv_options.read_options.quote_all
Whether all values need to be quoted, or just those that contain quotes. - format_options.tsv_options.read_options.sep
The file's field separator.
- format_options.vcf_options
Options for a VCF file. Show child fields- format_options.vcf_options.ignore_filter_field
The file's ignore filter field setting. - format_options.vcf_options.ignore_qual_field
The file's ignore qual field setting.
|
id
The job's ID. | VARCHAR |
items
The job's imported items. | STRUCT(
"source" VARCHAR,
"job_status" VARCHAR
)[] |
Show child fields- items[]
Show child fields- items[].job_status
The item's job status. - items[].source
The source file's location in Amazon S3.
|
role_arn
The job's service role ARN. | VARCHAR |
run_left_normalization
The job's left normalization setting. | BOOLEAN |
status
The job's status. | VARCHAR |
status_message
The job's status message. | VARCHAR |
update_time
When the job was updated. | TIMESTAMP_S |
version_name
The name of the annotation store version. | VARCHAR |