| Column Name | Column Data Type |
|---|
application_id Required Input Column
The unique identifier of the application that this data set is associated with. | VARCHAR |
data_set_name Required Input Column
The name of the data set. | 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 |
blocksize
The size of the block on disk. | BIGINT |
creation_time
The timestamp when the data set was created. | TIMESTAMP_S |
data_set_org
The type of data set. The only supported value is VSAM. | STRUCT(
"gdg" STRUCT(
"limit" BIGINT,
"roll_disposition" VARCHAR
),
"po" STRUCT(
"encoding" VARCHAR,
"format" VARCHAR
),
"ps" STRUCT(
"encoding" VARCHAR,
"format" VARCHAR
),
"vsam" STRUCT(
"alternate_keys" STRUCT(
"allow_duplicates" BOOLEAN,
"length" BIGINT,
"name" VARCHAR,
"offset" BIGINT
)[],
"cache_at_startup" BOOLEAN,
"compressed" BOOLEAN,
"encoding" VARCHAR,
"primary_key" STRUCT(
"length" BIGINT,
"name" VARCHAR,
"offset" BIGINT
),
"record_format" VARCHAR
)
) |
Show child fields- data_set_org.gdg
The generation data group of the data set. Show child fields- data_set_org.gdg.limit
The maximum number of generation data sets, up to 255, in a GDG. - data_set_org.gdg.roll_disposition
The disposition of the data set in the catalog.
- data_set_org.po
The details of a PO type data set. Show child fields- data_set_org.po.encoding
The character set encoding of the data set. - data_set_org.po.format
The format of the data set records.
- data_set_org.ps
The details of a PS type data set. Show child fields- data_set_org.ps.encoding
The character set encoding of the data set. - data_set_org.ps.format
The format of the data set records.
- data_set_org.vsam
The details of a VSAM data set. Show child fields- data_set_org.vsam.alternate_keys[]
Show child fields- data_set_org.vsam.alternate_keys[].allow_duplicates
Indicates whether the alternate key values are supposed to be unique for the given data set. - data_set_org.vsam.alternate_keys[].length
A strictly positive integer value representing the length of the alternate key. - data_set_org.vsam.alternate_keys[].name
The name of the alternate key. - data_set_org.vsam.alternate_keys[].offset
A positive integer value representing the offset to mark the start of the alternate key part in the record byte array.
- data_set_org.vsam.cache_at_startup
If set to True, enforces loading the data set into cache before it’s used by the application. - data_set_org.vsam.compressed
Indicates whether indexes for this dataset are stored as compressed values. If you have a large data set (typically > 100 Mb), consider setting this flag to True. - data_set_org.vsam.encoding
The character set used by the data set. Can be ASCII, EBCDIC, or unknown. - data_set_org.vsam.primary_key
The primary key of the data set. Show child fields- data_set_org.vsam.primary_key.length
A strictly positive integer value representing the length of the primary key. - data_set_org.vsam.primary_key.name
A name for the Primary Key. - data_set_org.vsam.primary_key.offset
A positive integer value representing the offset to mark the start of the primary key in the record byte array.
- data_set_org.vsam.record_format
The record format of the data set.
|
file_size
File size of the dataset. | BIGINT |
last_referenced_time
The last time the data set was referenced. | TIMESTAMP_S |
last_updated_time
The last time the data set was updated. | TIMESTAMP_S |
location
The location where the data set is stored. | VARCHAR |
record_length
The length of records in the data set. | BIGINT |