Table: aws_servicequotas_service_quota_change_request - Query AWS Service Quotas using SQL

The AWS Service Quotas allows you to view and manage your quotas for AWS services from a central location. Service Quotas provides a unified view of the quotas for AWS services, and it allows you to request quota increases for the services that support it. It offers the ability to manage quotas for the number of resources that you can create in an AWS account.

Table Usage Guide

The aws_servicequotas_service_quota_change_request table in Steampipe provides you with information about service quota change requests within AWS Service Quotas. This table enables you, as a DevOps engineer, to query request-specific details, including the status of the request, the requested value, and the associated metadata. You can utilize this table to gather insights on service quota change requests, such as pending requests, details of requested increases in service quotas, and more. The schema outlines the various attributes of the service quota change request for you, including the service name, quota name, request id, and associated tags.

Examples

Basic info

Identify instances where changes have been requested for AWS service quotas. This is particularly useful for understanding and managing resource allocation and usage limits within your AWS environment.

select
  id,
  case_id,
  status,
  quota_name,
  quota_code,
  desired_value
from
  aws_servicequotas_service_quota_change_request;

select
  id,
  case_id,
  status,
  quota_name,
  quota_code,
  desired_value
from
  aws_servicequotas_service_quota_change_request;

List denied service quota change requests

Explore which service quota change requests have been denied in your AWS environment. This could be used to identify potential bottlenecks or limitations in your resource allocation.

select
  id,
  case_id,
  status,
  quota_name,
  quota_code,
  desired_value
from
  aws_servicequotas_service_quota_change_request
where
  status = 'DENIED';

select
  id,
  case_id,
  status,
  quota_name,
  quota_code,
  desired_value
from
  aws_servicequotas_service_quota_change_request
where
  status = 'DENIED';

List service quota change requests for a specific service

Determine the status of requests to change service quotas for a specific service. This is useful for tracking any modifications to service limits, particularly for services that are heavily utilized or critical to operations.

select
  id,
  case_id,
  status,
  quota_name,
  quota_code,
  desired_value
from
  aws_servicequotas_service_quota_change_request
where
  service_code = 'athena';

select
  id,
  case_id,
  status,
  quota_name,
  quota_code,
  desired_value
from
  aws_servicequotas_service_quota_change_request
where
  service_code = 'athena';

Schema for aws_servicequotas_service_quota_change_request

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
case_id	text		The case ID.
created	timestamp with time zone		The date and time when the quota increase request was received and the case ID was created.
desired_value	double precision		The increased value for the quota.
global_quota	boolean		Indicates whether the quota is global.
id	text	=	The unique identifier.
last_updated	timestamp with time zone		The date and time of the most recent change.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
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.
quota_requested_at_level	text		Specifies at which level of granularity that the quota value is requested.
region	text		The AWS Region in which the resource is located.
requester	text		The IAM identity of the requester.
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.
status	text	=	The state of the quota increase request.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		The list of tags associated with the change request.
title	text		Title of the resource.
unit	text		The unit of measurement.

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_change_request