Table: aws_servicequotas_service - Query AWS Service Quota Services 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. AWS services that integrate with the Service Quotas service each have a code and name.

Table Usage Guide

The aws_servicequotas_service table in Steampipe provides you with information about services within AWS Service Quotas. With the service's service code, you can then query service quotas for that specific service, including default values,

Examples

Basic info

Explore the services supported by the Service Quotas service.

select
  distinct service_code,
  service_name
from
  aws_servicequotas_service;

select
  distinct service_code,
  service_name
from
  aws_servicequotas_service;

Get a service code for a a specific service

Get the service code for a specific service.

select
  distinct service_code
from
  aws_servicequotas_service
where
  service_name = 'AWS CloudTrail';

select
  distinct service_code
from
  aws_servicequotas_service
where
  service_name = 'AWS CloudTrail';

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