Skip to content

aws.codecommit.list_file_commit_history

Example SQL Queries

SELECT * FROM
aws.codecommit.list_file_commit_history
WHERE
"repository_name" = 'VALUE'
AND "file_path" = 'VALUE';

Description

Retrieves a list of commits and changes to a specified file.

Table Definition

Column NameColumn Data Type
file_path Required Input Column

The full path of the file whose history you want to retrieve, including the name of the file.

VARCHAR
repository_name Required Input Column

The name of the repository that contains the file.

VARCHAR
commit_specifier Input Column

The fully quaified reference that identifies the commit that contains the file. For example, you can specify a full commit ID, a tag, a branch name, or a reference such as refs/heads/main. If none is provided, the head commit is used.

VARCHAR
max_results Input Column

A non-zero, non-negative integer used to limit the number of returned results.

BIGINT
next_token Input Column

An enumeration token that can be used to return the next batch of results.

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
revision_dag

An array of FileVersion objects that form a directed acyclic graph (DAG) of the changes to the file made by the commits that changed the file.

STRUCT(
"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
),
"blob_id" VARCHAR,
"path" VARCHAR,
"revision_children" VARCHAR[]
)[]
Show child fields
revision_dag[]
Show child fields
revision_dag[].blob_id

The blob ID of the object that represents the content of the file in this version.

revision_dag[].commit

Returns information about a specific commit.

Show child fields
revision_dag[].commit.additional_data

Any other data associated with the specified commit.

revision_dag[].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
revision_dag[].commit.author.date

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

revision_dag[].commit.author.email

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

revision_dag[].commit.author.name

The name of the user who made the specified commit.

revision_dag[].commit.commit_id

The full SHA ID of the specified commit.

revision_dag[].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
revision_dag[].commit.committer.date

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

revision_dag[].commit.committer.email

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

revision_dag[].commit.committer.name

The name of the user who made the specified commit.

revision_dag[].commit.message

The commit message associated with the specified commit.

revision_dag[].commit.parents[]
revision_dag[].commit.tree_id

Tree information for the specified commit.

revision_dag[].path

The name and path of the file at which this blob is indexed which contains the data for this version of the file. This value will vary between file versions if a file is renamed or if its path changes.

revision_dag[].revision_children[]