Skip to content
AWS for Query.Farm

aws.codecommit.get_commit

Example SQL Queries

SELECT * FROM
aws.codecommit.get_commit
WHERE
"repository_name" = 'VALUE'
AND "commit_id" = 'VALUE';

Description

Returns information about a commit, including commit message and committer information.

Table Definition

Column NameColumn Data Type
commit_id Required Input Column

The commit ID. Commit IDs are the full SHA ID of the commit.

VARCHAR
repository_name Required Input Column

The name of the repository to which the commit was made.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
commit

A commit data type object that contains information about the specified commit.

STRUCT(
    "commit_id" VARCHAR,
    "tree_id" VARCHAR,
    "parents" VARCHAR[],
    "message" VARCHAR,
    "author" STRUCT(
        "name" VARCHAR,
        "email" VARCHAR,
        "date" VARCHAR
    ),
    "committer" STRUCT(
        "name" VARCHAR,
        "email" VARCHAR,
        "date" VARCHAR
    ),
    "additional_data" VARCHAR
)
Show child fields
commit.additional_data

Any other data associated with the specified commit.

commit.author

Information about the author of the specified commit. Information includes the date in timestamp format with GMT offset, the name of the author, and the email address for the author, as configured in Git.

Show child fields
commit.author.date

The date when the specified commit was commited, in timestamp format with GMT offset.

commit.author.email

The email address associated with the user who made the commit, if any.

commit.author.name

The name of the user who made the specified commit.

commit.commit_id

The full SHA ID of the specified commit.

commit.committer

Information about the person who committed the specified commit, also known as the committer. Information includes the date in timestamp format with GMT offset, the name of the committer, and the email address for the committer, as configured in Git.

For more information about the difference between an author and a committer in Git, see Viewing the Commit History in Pro Git by Scott Chacon and Ben Straub.

Show child fields
commit.committer.date

The date when the specified commit was commited, in timestamp format with GMT offset.

commit.committer.email

The email address associated with the user who made the commit, if any.

commit.committer.name

The name of the user who made the specified commit.

commit.message

The commit message associated with the specified commit.

commit.parents[]
commit.tree_id

Tree information for the specified commit.