steampipe plugin install aws

Table: aws_codedeploy_app - Query AWS CodeDeploy Applications using SQL

The AWS CodeDeploy service automates code deployments to any instance, including Amazon EC2 instances and instances running on-premises. An Application in AWS CodeDeploy is a name that uniquely identifies the application you want to deploy. AWS CodeDeploy uses this name, which functions like a container, to ensure the correct combination of revision, deployment configuration, and deployment group are referenced during a deployment.

Table Usage Guide

The aws_codedeploy_app table in Steampipe provides you with information about applications within AWS CodeDeploy. This table allows you, as a DevOps engineer, to query application-specific details, including application name, compute platform, and linked deployment groups. You can utilize this table to gather insights on applications, such as their deployment configurations, linked deployment groups, and compute platforms. The schema outlines the various attributes of the CodeDeploy application for you, including the application name, application ID, and the linked deployment groups.

Examples

Basic info

Explore the deployment applications in your AWS environment to understand their creation time and associated computing platform. This is beneficial for tracking the history and configuration of your applications across different regions.

select
arn,
application_id,
application_name compute_platform,
create_time,
region
from
aws_codedeploy_app;
select
arn,
application_id,
application_name,
compute_platform,
create_time,
region
from
aws_codedeploy_app;

Get total applications deployed on each platform

Explore the distribution of applications across various platforms to better understand your deployment strategy. This can assist in identifying platforms that are heavily utilized for deploying applications, aiding in resource allocation and management decisions.

select
count(arn) as application_count,
compute_platform
from
aws_codedeploy_app
group by
compute_platform;
select
count(arn) as application_count,
compute_platform
from
aws_codedeploy_app
group by
compute_platform;

List applications linked to GitHub

Identify instances where applications are linked to GitHub within the AWS CodeDeploy service. This is useful for gaining insights into the integration between your applications and GitHub, which can help in managing and troubleshooting your deployment processes.

select
arn,
application_id,
compute_platform,
create_time,
github_account_name
from
aws_codedeploy_app
where
linked_to_github;
select
arn,
application_id,
compute_platform,
create_time,
github_account_name
from
aws_codedeploy_app
where
linked_to_github = 1;

Schema for aws_codedeploy_app

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
application_idtextThe application ID.
application_nametext=The application name.
arntextThe Amazon Resource Name (ARN) specifying the application.
compute_platformtextThe destination platform type for deployment of the application (Lambda or Server).
create_timetimestamp with time zoneThe time at which the application was created.
github_account_nametextThe name for a connection to a GitHub account.
linked_to_githubbooleanTrue if the user has authenticated with GitHub for the specified application. Otherwise, false.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tag key and value pairs associated with this application.
titletextTitle of the resource.

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_codedeploy_app