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

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.
application_id	text		The application ID.
application_name	text	=	The application name.
arn	text		The Amazon Resource Name (ARN) specifying the application.
compute_platform	text		The destination platform type for deployment of the application (Lambda or Server).
create_time	timestamp with time zone		The time at which the application was created.
github_account_name	text		The name for a connection to a GitHub account.
linked_to_github	boolean		True if the user has authenticated with GitHub for the specified application. Otherwise, false.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		A list of tag key and value pairs associated with this application.
title	text		Title 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