| Column Name | Column Data Type |
|---|
summary_metric_queries Input Column
The list of queries to retrieve the summary metrics. | STRUCT(
"query_id" VARCHAR,
"metric_name" VARCHAR,
"dimensions" STRUCT(
"name" VARCHAR,
"value" VARCHAR
)[],
"aggregation_period" VARCHAR,
"start_timestamp" TIMESTAMP_S,
"end_timestamp" TIMESTAMP_S
)[] |
Show child fields- summary_metric_queries[]
Show child fields- summary_metric_queries[].aggregation_period
The aggregation period of the summary metric. - summary_metric_queries[].dimensions[]
Show child fields- summary_metric_queries[].dimensions[].name
The name of the dimension. - summary_metric_queries[].dimensions[].value
The dimension's value.
- summary_metric_queries[].end_timestamp
The end timestamp for the summary metric query. - summary_metric_queries[].metric_name
The name of the metric. - summary_metric_queries[].query_id
The id of the summary metric query. - summary_metric_queries[].start_timestamp
The start timestamp for the summary metric query.
|
_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 |
summary_metric_query_results
The list of summary metrics that were retrieved. | STRUCT(
"query_id" VARCHAR,
"query_status" VARCHAR,
"error" VARCHAR,
"metric_name" VARCHAR,
"dimensions" STRUCT(
"name" VARCHAR,
"value" VARCHAR
)[],
"aggregation_period" VARCHAR,
"start_timestamp" TIMESTAMP_S,
"end_timestamp" TIMESTAMP_S,
"timestamps" TIMESTAMP_S[],
"values" STRUCT(
"min" DOUBLE,
"max" DOUBLE,
"sum" DOUBLE,
"avg" DOUBLE,
"std" DOUBLE,
"p90" DOUBLE
)[],
"unit" VARCHAR
)[] |
Show child fields- summary_metric_query_results[]
Show child fields- summary_metric_query_results[].aggregation_period
The aggregation period of the metric. - summary_metric_query_results[].dimensions[]
Show child fields- summary_metric_query_results[].dimensions[].name
The name of the dimension. - summary_metric_query_results[].dimensions[].value
The dimension's value.
- summary_metric_query_results[].end_timestamp
The end timestamp for the summary metric query. - summary_metric_query_results[].error
The error message for the summary metric query result. - summary_metric_query_results[].metric_name
The name of the summary metric query result. - summary_metric_query_results[].query_id
The ID of the summary metric results query operation. - summary_metric_query_results[].query_status
The status of the summary metric query result. - summary_metric_query_results[].start_timestamp
The start timestamp for the summary metric query. - summary_metric_query_results[].timestamps[]
- summary_metric_query_results[].unit
The units of measurement to be used for interpreting the aggregation result. - summary_metric_query_results[].values[]
Show child fields- summary_metric_query_results[].values[].avg
The average of the values of all data points collected during the aggregation period. - summary_metric_query_results[].values[].max
The maximum of the values of all the data points collected during the aggregation period. - summary_metric_query_results[].values[].min
The minimum of the values of all data points collected during the aggregation period. - summary_metric_query_results[].values[].p90
The 90th percentile of the values of all data points collected during the aggregation period. - summary_metric_query_results[].values[].std
The standard deviation of the values of all data points collected during the aggregation period. - summary_metric_query_results[].values[].sum
The sum of the values of all data points collected during the aggregation period.
|