| Column Name | Column Data Type |
|---|
_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.
|
arn
The Amazon Resource Name. | VARCHAR |
creation_time
The creation time of the scheduled query. | TIMESTAMP_S |
error_report_configuration
Configuration for scheduled query error reporting. | STRUCT(
"s3_configuration" STRUCT(
"bucket_name" VARCHAR,
"object_key_prefix" VARCHAR,
"encryption_option" VARCHAR
)
) |
Show child fields- error_report_configuration.s3_configuration
The S3 configuration for the error reports. Show child fields- error_report_configuration.s3_configuration.bucket_name
Name of the S3 bucket under which error reports will be created. - error_report_configuration.s3_configuration.encryption_option
Encryption at rest options for the error reports. If no encryption option is specified, Timestream will choose SSE_S3 as default. - error_report_configuration.s3_configuration.object_key_prefix
Prefix for the error report key. Timestream by default adds the following prefix to the error report path.
|
last_run_status
Status of the last scheduled query run. | VARCHAR |
name
The name of the scheduled query. | VARCHAR |
next_invocation_time
The next time the scheduled query is to be run. | TIMESTAMP_S |
previous_invocation_time
The last time the scheduled query was run. | TIMESTAMP_S |
state
State of scheduled query. | VARCHAR |
target_destination
Target data source where final scheduled query result will be written. | STRUCT(
"timestream_destination" STRUCT(
"database_name" VARCHAR,
"table_name" VARCHAR
)
) |
Show child fields- target_destination.timestream_destination
Query result destination details for Timestream data source. Show child fields- target_destination.timestream_destination.database_name
Timestream database name. - target_destination.timestream_destination.table_name
Timestream table name.
|