| Column Name | Column Data Type |
|---|
database_name Required Input Column
The database containing the governed table. | VARCHAR |
table_name Required Input Column
The governed table for which to retrieve objects. | VARCHAR |
catalog_id Input Column
The catalog containing the governed table. Defaults to the caller’s account. | VARCHAR |
max_results Input Column
Specifies how many values to return in a page. | BIGINT |
next_token Input Column
A continuation token indicating whether additional data is available. | VARCHAR |
partition_predicate Input Column
A predicate to filter the objects returned based on the partition keys defined in the governed table. -
The comparison operators supported are: =, >, <, >=, <= -
The logical operators supported are: AND -
The data types supported are integer, long, date(yyyy-MM-dd), timestamp(yyyy-MM-dd HH:mm:ssXXX or yyyy-MM-dd HH:mm:ss"), string and decimal. | VARCHAR |
query_as_of_time Input Column
The time as of when to read the governed table contents. If not set, the most recent transaction commit time is used. Cannot be specified along with TransactionId. | TIMESTAMP_S |
transaction_id Input Column
The transaction ID at which to read the governed table contents. If this transaction has aborted, an error is returned. If not set, defaults to the most recent committed transaction. Cannot be specified along with QueryAsOfTime. | 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 |
objects
A list of objects organized by partition keys. | STRUCT(
"partition_values" VARCHAR[],
"objects" STRUCT(
"uri" VARCHAR,
"e_tag" VARCHAR,
"size" BIGINT
)[]
)[] |
Show child fields- objects[]
Show child fields- objects[].objects[]
Show child fields- objects[].objects[].e_tag
The Amazon S3 ETag of the object. Returned by GetTableObjects for validation and used to identify changes to the underlying data. - objects[].objects[].size
The size of the Amazon S3 object in bytes. - objects[].objects[].uri
The Amazon S3 location of the object.
- objects[].partition_values[]
|