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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
adjustable	boolean		Indicates whether the quota value can be increased.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
error_reason	jsonb		The error code and error reason.
global_quota	boolean		Indicates whether the quota is global.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
period	jsonb		The period of time for the quota.
quota_applied_at_level	text		Specifies at which level of granularity that the quota value is applied.
quota_arn	text		The arn of the service quota.
quota_code	text	=	The quota code.
quota_context	jsonb		The context for this service quota.
quota_name	text		The quota name.
region	text		The AWS Region in which the resource is located.
service_code	text	=	The service identifier.
service_name	text		The service name.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		The list of tags associated with the service quota.
title	text		Title of the resource.
unit	text		The unit of measurement.
usage_metric	jsonb		Information about the measurement.
value	bigint		The 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