steampipe plugin install awssteampipe plugin install aws

aws_accessanalyzer_analyzer aws_account aws_acm_certificate aws_api_gateway_api_key aws_api_gateway_authorizer aws_api_gateway_rest_api aws_api_gateway_stage aws_api_gateway_usage_plan aws_api_gatewayv2_api aws_api_gatewayv2_domain_name aws_api_gatewayv2_integration aws_api_gatewayv2_stage aws_appautoscaling_target aws_auditmanager_assessment aws_auditmanager_control aws_auditmanager_evidence aws_auditmanager_evidence_folder aws_auditmanager_framework aws_availability_zone aws_backup_plan aws_backup_selection aws_backup_vault aws_cloudformation_stack aws_cloudfront_cache_policy aws_cloudfront_distribution aws_cloudfront_origin_access_identity aws_cloudfront_origin_request_policy aws_cloudtrail_trail aws_cloudwatch_alarm aws_cloudwatch_log_group aws_cloudwatch_log_metric_filter aws_cloudwatch_log_stream aws_codebuild_project aws_codebuild_source_credential aws_codecommit_repository aws_codepipeline_pipeline aws_config_configuration_recorder aws_config_conformance_pack aws_config_rule aws_cost_by_account_daily aws_cost_by_account_monthly aws_cost_by_service_daily aws_cost_by_service_monthly aws_cost_by_service_usage_type_daily aws_cost_by_service_usage_type_monthly aws_cost_forecast_daily aws_cost_forecast_monthly aws_cost_usage aws_dax_cluster aws_dms_replication_instance aws_dynamodb_backup aws_dynamodb_global_table aws_dynamodb_metric_account_provisioned_read_capacity_util aws_dynamodb_metric_account_provisioned_write_capacity_util aws_dynamodb_table aws_ebs_snapshot aws_ebs_volume aws_ebs_volume_metric_read_ops aws_ebs_volume_metric_read_ops_daily aws_ebs_volume_metric_read_ops_hourly aws_ebs_volume_metric_write_ops aws_ebs_volume_metric_write_ops_daily aws_ebs_volume_metric_write_ops_hourly aws_ec2_ami aws_ec2_ami_shared aws_ec2_application_load_balancer aws_ec2_autoscaling_group aws_ec2_classic_load_balancer aws_ec2_gateway_load_balancer aws_ec2_instance aws_ec2_instance_availability aws_ec2_instance_metric_cpu_utilization aws_ec2_instance_metric_cpu_utilization_daily aws_ec2_instance_metric_cpu_utilization_hourly aws_ec2_instance_type aws_ec2_key_pair aws_ec2_launch_configuration aws_ec2_load_balancer_listener aws_ec2_network_interface aws_ec2_network_load_balancer aws_ec2_regional_settings aws_ec2_ssl_policy aws_ec2_target_group aws_ec2_transit_gateway aws_ec2_transit_gateway_route_table aws_ec2_transit_gateway_vpc_attachment aws_ecr_repository aws_ecrpublic_repository aws_ecs_cluster aws_ecs_container_instance aws_ecs_service aws_ecs_task_definition aws_efs_access_point aws_efs_file_system aws_efs_mount_target aws_eks_addon aws_eks_addon_version aws_eks_cluster aws_elastic_beanstalk_application aws_elastic_beanstalk_environment aws_elasticache_cluster aws_elasticache_parameter_group aws_elasticache_replication_group aws_elasticache_subnet_group aws_elasticsearch_domain aws_emr_cluster aws_eventbridge_rule aws_glacier_vault aws_glue_catalog_database aws_guardduty_detector aws_guardduty_finding aws_guardduty_ipset aws_guardduty_threat_intel_set aws_iam_access_advisor aws_iam_access_key aws_iam_account_password_policy aws_iam_account_summary aws_iam_action aws_iam_credential_report aws_iam_group aws_iam_policy aws_iam_policy_simulator aws_iam_role aws_iam_server_certificate aws_iam_user aws_iam_virtual_mfa_device aws_inspector_assessment_target aws_inspector_assessment_template aws_kinesis_consumer aws_kinesis_firehose_delivery_stream aws_kinesis_stream aws_kinesis_video_stream aws_kinesisanalyticsv2_application aws_kms_key aws_lambda_alias aws_lambda_function aws_lambda_version aws_macie2_classification_job aws_rds_db_cluster aws_rds_db_cluster_parameter_group aws_rds_db_cluster_snapshot aws_rds_db_instance aws_rds_db_instance_metric_connections aws_rds_db_instance_metric_connections_daily aws_rds_db_instance_metric_connections_hourly aws_rds_db_instance_metric_cpu_utilization aws_rds_db_instance_metric_cpu_utilization_daily aws_rds_db_instance_metric_cpu_utilization_hourly aws_rds_db_instance_metric_read_iops aws_rds_db_instance_metric_read_iops_daily aws_rds_db_instance_metric_read_iops_hourly aws_rds_db_instance_metric_write_iops aws_rds_db_instance_metric_write_iops_daily aws_rds_db_instance_metric_write_iops_hourly aws_rds_db_option_group aws_rds_db_parameter_group aws_rds_db_snapshot aws_rds_db_subnet_group aws_redshift_cluster aws_redshift_event_subscription aws_redshift_parameter_group aws_redshift_snapshot aws_redshift_subnet_group aws_region aws_route53_domain aws_route53_record aws_route53_resolver_endpoint aws_route53_resolver_rule aws_route53_zone aws_s3_access_point aws_s3_account_settings aws_s3_bucket aws_sagemaker_endpoint_configuration aws_sagemaker_model aws_sagemaker_notebook_instance aws_sagemaker_training_job aws_secretsmanager_secret aws_securityhub_hub aws_securityhub_product aws_sns_topic aws_sns_topic_subscription aws_sqs_queue aws_ssm_association aws_ssm_document aws_ssm_maintenance_window aws_ssm_managed_instance aws_ssm_managed_instance_compliance aws_ssm_parameter aws_ssm_patch_baseline aws_vpc aws_vpc_customer_gateway aws_vpc_dhcp_options aws_vpc_egress_only_internet_gateway aws_vpc_eip aws_vpc_endpoint aws_vpc_endpoint_service aws_vpc_flow_log aws_vpc_internet_gateway aws_vpc_nat_gateway aws_vpc_network_acl aws_vpc_route aws_vpc_route_table aws_vpc_security_group aws_vpc_security_group_rule aws_vpc_subnet aws_vpc_vpn_connection aws_vpc_vpn_gateway aws_waf_rate_based_rule aws_waf_rule aws_wafv2_ip_set aws_wafv2_regex_pattern_set aws_wafv2_rule_group aws_wafv2_web_acl aws_wellarchitected_workload

Table: aws_elastic_beanstalk_application

AWS Elastic Beanstalk offers the fastest and simplest way to deploy developer's applications without worrying about the infrastructure while maintaining high availability.

Examples

Basic info

select
  name,
  arn,
  description,
  date_created,
  date_updated,
  versions
from
  aws_elastic_beanstalk_application;

Get resource life cycle configuration details for each application

select
  name,
  resource_lifecycle_config ->> 'ServiceRole' as role,
  resource_lifecycle_config -> 'VersionLifecycleConfig' ->> 'MaxAgeRule' as max_age_rule,
  resource_lifecycle_config -> 'VersionLifecycleConfig' ->> 'MaxCountRule' as max_count_rule
from
  aws_elastic_beanstalk_application;

.inspect aws_elastic_beanstalk_application

AWS Elastic Beanstalk Application

Name	Type	Description
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.
arn	text	The Amazon Resource Name (ARN) of the application.
configuration_templates	jsonb	The names of the configuration templates associated with this application.
date_created	timestamp without time zone	The date when the application was created.
date_updated	timestamp without time zone	The date when the application was last modified.
description	text	User-defined description of the application.
name	text	The name of the application.
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.
resource_lifecycle_config	jsonb	The lifecycle settings for the application.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags assigned to the application.
title	text	Title of the resource.
versions	jsonb	The names of the versions for this application.