steampipe plugin install aws

Table: aws_servicequotas_service_quota - Query AWS Service Quotas using SQL

The AWS Service Quotas is a service that allows you to view and manage your quotas for AWS services from a central location. Quotas, also referred to as limits, are the maximum number of resources that you can create in your AWS account. With Service Quotas, you can easily see the quotas for the AWS services that are most relevant to you, request quota increases, and track the status of your requests.

Table Usage Guide

The aws_servicequotas_service_quota table in Steampipe provides you with information about service quotas within AWS Service Quotas. This table allows you, as a DevOps engineer, to query quota-specific details, including quota value, default value, and whether it's adjustable. You can utilize this table to gather insights on service quotas, such as identifying quotas nearing their limit, understanding default and custom quota values, and determining which quotas can be adjusted. The schema outlines the various attributes of the service quota for you, including the quota ARN, quota code, service code, and associated metadata.

Examples

Basic info

Analyze the settings to understand the quotas set for various AWS services. This can help manage resources more effectively by identifying services that are nearing their quota limits, thus preventing service disruptions due to exceeded quotas.

select
quota_name,
quota_code,
quota_arn,
service_name,
service_code,
value
from
aws_servicequotas_service_quota;
select
quota_name,
quota_code,
quota_arn,
service_name,
service_code,
value
from
aws_servicequotas_service_quota;

List global service quotas

Explore which global service quotas are in place in your AWS environment. This can help manage service usage and avoid hitting service limit caps, thus ensuring smooth operation of your applications.

select
quota_name,
quota_code,
quota_arn,
service_name,
service_code,
value
from
aws_servicequotas_service_quota
where
global_quota;
select
quota_name,
quota_code,
quota_arn,
service_name,
service_code,
value
from
aws_servicequotas_service_quota
where
global_quota = 1;

List service quotas for a specific service

Explore the set limits for a particular service to manage resource usage effectively. This can be particularly useful when planning resource allocation or troubleshooting resource limitations.

select
quota_name,
quota_code,
quota_arn,
service_name,
service_code,
value
from
aws_servicequotas_service_quota
where
service_code = 'athena';
select
quota_name,
quota_code,
quota_arn,
service_name,
service_code,
value
from
aws_servicequotas_service_quota
where
service_code = 'athena';

Schema for aws_servicequotas_service_quota

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
adjustablebooleanIndicates whether the quota value can be increased.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
error_reasonjsonbThe error code and error reason.
global_quotabooleanIndicates whether the quota is global.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
periodjsonbThe period of time for the quota.
quota_arntextThe arn of the service quota.
quota_codetext=The quota code.
quota_nametextThe quota name.
regiontextThe AWS Region in which the resource is located.
service_codetext=The service identifier.
service_nametextThe service name.
tagsjsonbA map of tags for the resource.
tags_srcjsonbThe list of tags associated with the service quota.
titletextTitle of the resource.
unittextThe unit of measurement.
usage_metricjsonbInformation about the measurement.
valuebigintThe quota value.

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_servicequotas_service_quota