Table: aws_codecommit_repository - Query AWS CodeCommit Repositories using SQL

The AWS CodeCommit Repository is a fully-managed source control service that hosts secure Git-based repositories. It makes it easy for teams to collaborate on code in a secure and highly scalable ecosystem. CodeCommit eliminates the need to operate your own source control system or worry about scaling its infrastructure.

Table Usage Guide

The aws_codecommit_repository table in Steampipe provides you with information about repositories within AWS CodeCommit. This table allows you, as a DevOps engineer, to query repository-specific details, including repository name, ARN, description, clone URL, last modified date, and other related details. You can utilize this table to gather insights on repositories, such as repositories with specific ARNs, the last modified date of repositories, verification of clone URLs, and more. The schema outlines the various attributes of the CodeCommit repository for you, including the repository name, ARN, clone URL, and associated metadata.

Examples

Basic info

This query allows you to explore the details of your AWS CodeCommit repositories, including their names, IDs, creation dates, and regions. It's useful for gaining insights into your repository usage and organization across different regions.

select
  repository_name,
  repository_id,
  arn,
  creation_date,
  region
from
  aws_codecommit_repository;

select
  repository_name,
  repository_id,
  arn,
  creation_date,
  region
from
  aws_codecommit_repository;

Query examples

Schema for aws_codecommit_repository

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.
arn	text		The Amazon Resource Name (ARN) of the repository.
clone_url_http	text		The URL to use for cloning the repository over HTTPS.
clone_url_ssh	text		The URL to use for cloning the repository over SSH.
creation_date	timestamp with time zone		The date and time the repository was created.
default_branch	text		The repository's default branch name.
description	text		A comment or description about the repository.
kms_key_id	text		The ID of the Key Management Service encryption key used to encrypt and decrypt the repository.
last_modified_date	timestamp with time zone		The date and time the repository was last modified.
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.
repository_id	text		The ID of the repository.
repository_name	text		The repository's name.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
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_codecommit_repository