steampipe plugin install aws

Table: aws_dynamodb_metric_account_provisioned_write_capacity_util - Query AWS DynamoDB Metrics using SQL

The AWS DynamoDB Metrics service allows you to monitor the performance characteristics of DynamoDB tables. One such metric is the Account Provisioned Write Capacity Utilization, which provides information about the write capacity units consumed by all tables in your AWS account. This helps you manage your resources effectively and optimize your database's performance.

Table Usage Guide

The aws_dynamodb_metric_account_provisioned_write_capacity_util table in Steampipe provides you with information about the provisioned write capacity utilization metrics at the account level within Amazon DynamoDB. This table allows you, as a DevOps engineer, to query details related to the provisioned write capacity, such as the average, maximum, and minimum write capacity units consumed by all tables in your account. You can utilize this table to monitor the utilization of provisioned write capacity, ensuring optimal performance and identifying potential bottlenecks or over-provisioning. The schema outlines the various attributes of the metric, including your account id, region, timestamp, and the provisioned write capacity units.

Examples

Basic info

Determine the areas in which your AWS DynamoDB is being utilized by understanding the provisioned write capacity over time. This query can help you manage resources more efficiently by identifying peak usage times and patterns.

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

Intervals where throughput exceeds 80 percent

Determine the instances where the provisioned write capacity of your AWS DynamoDB exceeds 80 percent. This can be useful to identify periods of high demand and potentially optimize your resource allocation for improved performance.

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

Schema for aws_dynamodb_metric_account_provisioned_write_capacity_util

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
averagedouble precisionThe average of the metric values that correspond to the data point.
maximumdouble precisionThe maximum metric value for the data point.
metric_nametextThe name of the metric.
minimumdouble precisionThe minimum metric value for the data point.
namespacetextThe metric namespace.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sample_countdouble precisionThe number of metric values that contributed to the aggregate value of this data point.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sumdouble precisionThe sum of the metric values for the data point.
timestamptimestamp with time zoneThe time stamp used for the data point.
unittextThe 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_write_capacity_util