steampipe plugin install awssteampipe plugin install aws

Table: aws_api_gatewayv2_stage

A stage is a named reference to a deployment, which is a snapshot of the API.

Examples

List of API gateway V2 stages which does not send logs to cloud watch log

select
  stage_name,
  api_id,
  default_route_data_trace_enabled
from
  aws_api_gatewayv2_stage
where
  not default_route_data_trace_enabled;

Default route settings info of each API gateway V2 stage

select
  stage_name,
  api_id,
  default_route_data_trace_enabled,
  default_route_detailed_metrics_enabled,
  default_route_throttling_burst_limit,
  default_route_throttling_rate_limit
from
  aws_api_gatewayv2_stage;

Count of API gateway V2 stages by APIs

select
  api_id,
  count(stage_name) stage_count
from
  aws_api_gatewayv2_stage
group by
  api_id;

Get access log settings of API gateway V2 stages

select
  stage_name,
  api_id,
  default_route_data_trace_enabled,
  jsonb_pretty(access_log_settings) as access_log_settings
from
  aws_api_gatewayv2_stage;

Query examples

.inspect aws_api_gatewayv2_stage

AWS API Gateway Version 2 Stage

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
access_log_settings	jsonb	Access log settings of the stage.
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.
api_gateway_managed	boolean	Specifies whether a stage is managed by API Gateway
api_id	text	The id of the api which contains this stage
auto_deploy	boolean	Specifies whether updates to an API automatically trigger a new deployment
client_certificate_id	text	The identifier of a client certificate for a Stage. Supported only for WebSocket APIs
created_date	text	The timestamp when the stage was created
default_route_data_trace_enabled	boolean	Specifies whether (true) or not (false) data trace logging is enabled for this route. This property affects the log entries pushed to Amazon CloudWatch Logs. Supported only for WebSocket APIs
default_route_detailed_metrics_enabled	boolean	Specifies whether detailed metrics are enabled
default_route_logging_level	text	Specifies the logging level for this route: INFO, ERROR, or OFF. This property affects the log entries pushed to Amazon CloudWatch Logs. Supported only for WebSocket APIs
default_route_throttling_burst_limit	bigint	Throttling burst limit for default route settings
default_route_throttling_rate_limit	double precision	Throttling rate limit for default route settings
deployment_id	text	The identifier of the Deployment that the Stage is associated with
description	text	The stage's description
last_deployment_status_message	text	Describes the status of the last deployment of a stage. Supported only for stages with autoDeploy enabled
last_updated_date	text	The timestamp when the stage was last updated
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
stage_name	text	The name of the stage
stage_variables	jsonb	A map that defines the stage variables for a stage resource
tags	jsonb	A map of tags for the resource.
title	text	Title of the resource.

turbot/aws

Table: aws_api_gatewayv2_stage

Examples

List of API gateway V2 stages which does not send logs to cloud watch log

Default route settings info of each API gateway V2 stage

Count of API gateway V2 stages by APIs

Get access log settings of API gateway V2 stages

Query examples

.inspect aws_api_gatewayv2_stage

Steampipe

Resources

Community