Skip to content
AWS for Query.Farm

aws.ec2.get_aws_network_performance_data

Example SQL Queries

SELECT * FROM
aws.ec2.get_aws_network_performance_data;

Description

Gets network performance data.

Table Definition

Column NameColumn Data Type
data_queries Input Column

A list of network performance data queries.

STRUCT(
    "id" VARCHAR,
    "source" VARCHAR,
    "destination" VARCHAR,
    "metric" VARCHAR,
    "statistic" VARCHAR,
    "period" VARCHAR
)[]
Show child fields
data_queries[]
Show child fields
data_queries[].destination

The Region or Availability Zone that's the target for the data query. For example, eu-north-1.

data_queries[].id

A user-defined ID associated with a data query that's returned in the dataResponse identifying the query. For example, if you set the Id to MyQuery01in the query, the dataResponse identifies the query as MyQuery01.

data_queries[].metric

The metric used for the network performance request.

data_queries[].period

The aggregation period used for the data query.

data_queries[].source

The Region or Availability Zone that's the source for the data query. For example, us-east-1.

data_queries[].statistic

The metric data aggregation period, p50, between the specified startDate and endDate. For example, a metric of five_minutes is the median of all the data points gathered within those five minutes. p50 is the only supported metric.

dry_run Input Column

Checks whether you have the required permissions for the action, without actually making the request, and provides an error response. If you have the required permissions, the error response is DryRunOperation. Otherwise, it is UnauthorizedOperation.

BOOLEAN
end_time Input Column

The ending time for the performance data request. The end time must be formatted as yyyy-mm-ddThh:mm:ss. For example, 2022-06-12T12:00:00.000Z.

TIMESTAMP_S
start_time Input Column

The starting time for the performance data request. The starting time must be formatted as yyyy-mm-ddThh:mm:ss. For example, 2022-06-10T12:00:00.000Z.

TIMESTAMP_S
_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
destination

The Region or Availability Zone that's the destination for the data query. For example, eu-west-1.

VARCHAR
id

The ID passed in the DataQuery.

VARCHAR
metric

The metric used for the network performance request.

VARCHAR
metric_points

A list of MetricPoint objects.

STRUCT(
    "start_date" TIMESTAMP_S,
    "end_date" TIMESTAMP_S,
    "value" DOUBLE,
    "status" VARCHAR
)[]
Show child fields
metric_points[]
Show child fields
metric_points[].end_date

The end date for the metric point. The ending time must be formatted as yyyy-mm-ddThh:mm:ss. For example, 2022-06-12T12:00:00.000Z.

metric_points[].start_date

The start date for the metric point. The starting date for the metric point. The starting time must be formatted as yyyy-mm-ddThh:mm:ss. For example, 2022-06-10T12:00:00.000Z.

metric_points[].status

The status of the metric point.

metric_points[].value
period

The period used for the network performance request.

VARCHAR
source

The Region or Availability Zone that's the source for the data query. For example, us-east-1.

VARCHAR
statistic

The statistic used for the network performance request.

VARCHAR