steampipe plugin install awssteampipe plugin install aws

Table: aws_codebuild_project

AWS CodeBuild is a fully managed build service in the cloud. CodeBuild compiles your source code, runs unit tests, and produces artifacts that are ready to deploy. CodeBuild eliminates the need to provision, manage, and scale your own build servers. It provides prepackaged build environments for the most popular programming languages and build tools, such as Apache Maven, Gradle, and more.

Examples

Basic info

select
  arn,
  id,
  build_complete,
  timeout_in_minutes,
  project_name,
  build_status,
  encryption_key,
  end_time,
  region
from
  aws_codebuild_build;

List encrypted build output artifacts

select
  arn,
  id,
  encryption_key
from
  aws_codebuild_build
where
  encryption_key is not null;

List complete builds

select
  id,
  arn,
  artifacts,
  build_complete
from
  aws_codebuild_build
where
  build_complete;

List VPC configuration details of builds

select
  id,
  arn,
  vpc_config ->> 'SecurityGroupIds' as security_group_id,
  vpc_config ->> 'Subnets' as subnets,
  vpc_config ->> 'VpcId' as vpc_id
from
  aws_codebuild_build;

List artifact details of builds

select
  id,
  arn,
  artifacts ->> 'ArtifactIdentifier' as artifact_id,
  artifacts ->> 'BucketOwnerAccess' as bucket_owner_access,
  artifacts ->> 'EncryptionDisabled' as encryption_disabled,
  artifacts ->> 'OverrideArtifactName' as override_artifact_name
from
  aws_codebuild_build;

Get environment details of builds

select
  id,
  environment ->> 'Certificate' as environment_certificate,
  environment ->> 'ComputeType' as environment_compute_type,
  environment ->> 'EnvironmentVariables' as environment_variables,
  environment ->> 'Image' as environment_image,
  environment ->> 'ImagePullCredentialsType' as environment_image_pull_credentials_type,
  environment ->> 'PrivilegedMode' as environment_privileged_mode,
  environment ->> 'RegistryCredential' as environment_registry_credential,
  environment ->> 'Type' as environment_type
from
  aws_codebuild_build;

Get log details of builds

select
  id,
  logs -> 'S3Logs' ->> 'Status' as s3_log_status,
  logs -> 'S3Logs' ->> 'Location' as s3_log_location,
  logs -> 'S3Logs' ->> 'BucketOwnerAccess' as s3_log_bucket_owner_access,
  logs -> 'S3Logs' ->> 'EncryptionDisabled' as s3_log_encryption_disabled,
  logs ->> 'DeepLink' as deep_link,
  logs ->> 'GroupName' as group_name,
  logs ->> 'S3LogsArn' as s3_logs_arn,
  logs ->> 'S3DeepLink' as s3_deep_link,
  logs ->> 'StreamName' as stream_name,
  logs ->> 'CloudWatchLogsArn' as cloud_watch_logs_arn,
  logs -> 'CloudWatchLogs' ->> 'Status' as cloud_watch_logs_status,
  logs -> 'CloudWatchLogs' ->> 'GroupName' as cloud_watch_logs_group_name,
  logs -> 'CloudWatchLogs' ->> 'StreamName' as cloud_watch_logs_stream_name
from
  aws_codebuild_build;

Get network interface details of builds

select
  id,
  network_interfaces ->> 'NetworkInterfaceId' as network_interface_id,
  network_interfaces ->> 'SubnetId' as subnet_id,
from
  aws_codebuild_build;

List phase details of builds

select
  id,
  p ->> 'EndTime' as end_time,
  p ->> 'Contexts' as contexts,
  p ->> 'PhaseType' as phase_type,
  p ->> 'StartTime' as start_time,
  p ->> 'DurationInSeconds' as duration_in_seconds,
  p ->> 'PhaseStatus' as phase_status
from
  aws_codebuild_build,
  jsonb_array_elements(phases) as p;

Get source details of builds

select
  id,
  source ->> 'Auth' as source_auth,
  source ->> 'BuildStatusConfig' as source_BuildStatusConfig,
  source ->> 'Buildspec' as source_buildspec,
  source ->> 'GitCloneDepth' as source_git_clone_depth,
  source ->> 'GitSubmodulesConfig' as source_git_submodules_config,
  source ->> 'GitCloneDepth' as source_git_clone_depth,
  source ->> 'InsecureSsl' as source_insecure_ssl,
  source ->> 'Location' as source_location,
  source ->> 'ReportBuildStatus' as source_report_build_status,
  source ->> 'SourceIdentifier' as source_identifier,
  source ->> 'Type' as source_type
from
  aws_codebuild_build;

List file system location details of builds

select
  id,
  f ->> 'Identifier' as file_system_identifier,
  f ->> 'Location' as file_system_location,
  f ->> 'MountOptions' as file_system_mount_options,
  f ->> 'MountPoint' as file_system_mount_point,
  f ->> 'Type' as file_system_type
from
  aws_codebuild_build,
  jsonb_array_elements(file_system_locations) as f;

.inspect aws_codebuild_build

AWS CodeBuild Build

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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 ARN of the build.
artifacts	jsonb	A BuildArtifacts object the defines the build artifacts for this build.
build_batch_arn	text	The ARN of the batch build that this build is a member of, if applicable.
build_complete	boolean	Indicates if the build is complete.
build_number	bigint	The number of the build.
build_status	jsonb	The status of the build.
cache	jsonb	Information about the cache for the build.
current_phase	text	The current build phase.
debug_session	jsonb	Contains information about the debug session for this build.
encryption_key	text	The Key Management Service customer master key (CMK) to be used for encrypting the build output artifacts.
end_time	timestamp with time zone	The date and time that the build process ended, expressed in Unix time format.
environment	jsonb	Information about the build environment for this build project.
exported_environment_variables	jsonb	A list of exported environment variables for this build.
file_system_locations	jsonb	An array of ProjectFileSystemLocation objects for a CodeBuild build project.
id	text	The unique identifier of the build.
initiator	text	The entity that started the build.
logs	jsonb	Information about the build's logs in CloudWatch Logs.
network_interfaces	jsonb	Describes a network interface.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
phases	jsonb	Information about all previous build phases that are complete and information about any current build phase that is not yet complete.
project_name	text	The name of the build project.
queued_timeout_in_minutes	bigint	Specifies the amount of time, in minutes, that a build is allowed to be queued before it times out.
region	text	The AWS Region in which the resource is located.
report_arns	jsonb	An array of the ARNs associated with this build's reports.
resolved_source_version	text	The identifier of the resolved version of this build's source code.
secondary_artifacts	jsonb	An array of BuildArtifacts objects the define the build artifacts for this build.
secondary_source_versions	jsonb	An array of ProjectSourceVersion objects.
secondary_sources	jsonb	An array of ProjectSource objects that define the sources for the build.
source	jsonb	Information about the build input source code for the build project.
source_version	text	The identifier of the version of the source code to be built.
start_time	timestamp with time zone	The date and time that the build started.
timeout_in_minutes	bigint	How long, in minutes, for CodeBuild to wait before timing out this build if it does not get marked as completed.
title	text	Title of the resource.
vpc_config	jsonb	Information about the VPC configuration that CodeBuild accesses.

turbot/aws