Table: aws_dynamodb_metric_account_provisioned_read_capacity_util - Query AWS DynamoDB Metrics using SQL

The AWS DynamoDB Metrics service provides detailed performance metrics for your DynamoDB tables. One such metric is the Account Provisioned Read Capacity Utilization, which measures the percentage of provisioned read capacity units that your application consumes. This allows you to monitor your application's read activity and optimize your provisioned read capacity units for cost-effectiveness and performance.

Table Usage Guide

The aws_dynamodb_metric_account_provisioned_read_capacity_util table in Steampipe provides you with information about account provisioned read capacity utilization metrics within AWS DynamoDB. This table allows you, as a DevOps engineer, to query metric-specific details, including the average, maximum, and minimum read capacity utilization. You can utilize this table to gather insights on DynamoDB performance, such as understanding the read capacity utilization of your DynamoDB tables, identifying potential performance bottlenecks, and planning capacity accordingly. The schema outlines the various attributes of the DynamoDB metric, including the region, account_id, and timestamp for you.

Examples

Basic info

Determine the areas in which your AWS DynamoDB account's provisioned read capacity is being utilized. This can help in monitoring resource usage over time and planning for future capacity needs.

select
  account_id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  aws_dynamodb_metric_account_provisioned_read_capacity_util
order by
  timestamp;

select
  account_id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  aws_dynamodb_metric_account_provisioned_read_capacity_util
order by
  timestamp;

Intervals where throughput exceeds 80 percent

Analyze the instances where the provisioned read capacity utilization of your AWS DynamoDB account exceeds 80 percent. This can help in identifying periods of high demand and assist in capacity planning to ensure optimal performance.

select
  account_id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  aws_dynamodb_metric_account_provisioned_read_capacity_util
where
  maximum > 80
order by
  timestamp;

select
  account_id,
  timestamp,
  minimum,
  maximum,
  average,
  sum,
  sample_count
from
  aws_dynamodb_metric_account_provisioned_read_capacity_util
where
  maximum > 80
order by
  timestamp;

Query examples

dynamodb_table_average_read_throughput

Schema for aws_dynamodb_metric_account_provisioned_read_capacity_util

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
average	double precision		The average of the metric values that correspond to the data point.
maximum	double precision		The maximum metric value for the data point.
metric_name	text		The name of the metric.
minimum	double precision		The minimum metric value for the data point.
namespace	text		The metric namespace.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
sample_count	double precision		The number of metric values that contributed to the aggregate value of this data point.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
sum	double precision		The sum of the metric values for the data point.
timestamp	timestamp with time zone		The time stamp used for the data point.
unit	text		The standard unit for the data point.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_dynamodb_metric_account_provisioned_read_capacity_util