Skip to content

aws.datasync.describe_storage_system_resource_metrics

Example SQL Queries

SELECT * FROM
aws.datasync.describe_storage_system_resource_metrics
WHERE
"discovery_job_arn" = 'VALUE'
AND "resource_type" = 'VALUE'
AND "resource_id" = 'VALUE';

Description

Returns information, including performance data and capacity usage, which DataSync Discovery collects about a specific resource in your-premises storage system.

Table Definition

Column NameColumn Data Type
discovery_job_arn Required Input Column

Specifies the Amazon Resource Name (ARN) of the discovery job that collects information about your on-premises storage system.

VARCHAR
resource_id Required Input Column

The universally unique identifier (UUID) of the on-premises storage system resource.

VARCHAR
resource_type Required Input Column

The type of on-premises storage system resource.

VARCHAR
end_time Input Column

Specifies a time within the total duration that the discovery job ran. To see information gathered during a certain time frame, use this parameter with StartTime.

TIMESTAMP_S
start_time Input Column

Specifies a time within the total duration that the discovery job ran. To see information gathered during a certain time frame, use this parameter with EndTime.

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
capacity

The storage capacity of the on-premises storage system resource.

STRUCT(
"used" BIGINT,
"provisioned" BIGINT,
"logical_used" BIGINT,
"cluster_cloud_storage_used" BIGINT
)
Show child fields
capacity.cluster_cloud_storage_used

The amount of space in the cluster that's in cloud storage (for example, if you're using data tiering).

capacity.logical_used

The amount of space that's being used in a storage system resource without accounting for compression or deduplication.

capacity.provisioned

The total amount of space available in a storage system resource.

capacity.used

The amount of space that's being used in a storage system resource.

p95_metrics

The types of performance data that DataSync Discovery collects about the on-premises storage system resource.

STRUCT(
"iops" STRUCT(
"read" DOUBLE,
"write" DOUBLE,
"other" DOUBLE,
"total" DOUBLE
),
"throughput" STRUCT(
"read" DOUBLE,
"write" DOUBLE,
"other" DOUBLE,
"total" DOUBLE
),
"latency" STRUCT(
"read" DOUBLE,
"write" DOUBLE,
"other" DOUBLE
)
)
Show child fields
p95_metrics.iops

The IOPS peaks for an on-premises storage system resource. Each data point represents the 95th percentile peak value during a 1-hour interval.

Show child fields
p95_metrics.iops.other

Peak IOPS unrelated to read and write operations.

p95_metrics.iops.read

Peak IOPS related to read operations.

p95_metrics.iops.total

Peak total IOPS on your on-premises storage system resource.

p95_metrics.iops.write

Peak IOPS related to write operations.

p95_metrics.latency

The latency peaks for an on-premises storage system resource. Each data point represents the 95th percentile peak value during a 1-hour interval.

Show child fields
p95_metrics.latency.other

Peak latency for operations unrelated to read and write operations.

p95_metrics.latency.read

Peak latency for read operations.

p95_metrics.latency.write

Peak latency for write operations.

p95_metrics.throughput

The throughput peaks for an on-premises storage system resource. Each data point represents the 95th percentile peak value during a 1-hour interval.

Show child fields
p95_metrics.throughput.other

Peak throughput unrelated to read and write operations.

p95_metrics.throughput.read

Peak throughput related to read operations.

p95_metrics.throughput.total

Peak total throughput on your on-premises storage system resource.

p95_metrics.throughput.write

Peak throughput related to write operations.

timestamp

The time when DataSync Discovery collected this information from the resource.

TIMESTAMP_S