Skip to content

aws.codecommit.get_comments_for_compared_commit

Example SQL Queries

SELECT * FROM
aws.codecommit.get_comments_for_compared_commit
WHERE
"repository_name" = 'VALUE'
AND "after_commit_id" = 'VALUE';

Description

Returns information about comments made on the comparison between two commits.

Reaction counts might include numbers from user identities who were deleted after the reaction was made. For a count of reactions from active identities, use GetCommentReactions.

Table Definition

Column NameColumn Data Type
after_commit_id Required Input Column

The full commit ID of the commit used to establish the after of the comparison.

VARCHAR
repository_name Required Input Column

The name of the repository that contains the compared commits.

VARCHAR
before_commit_id Input Column

The full commit ID of the commit used to establish the before of the comparison.

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
after_blob_id

The full blob ID of the commit used to establish the after of the comparison.

VARCHAR
before_blob_id

The full blob ID of the commit used to establish the before of the comparison.

VARCHAR
comments

An array of comment objects. Each comment object contains information about a comment on the comparison between commits.

STRUCT(
"comment_id" VARCHAR,
"content" VARCHAR,
"in_reply_to" VARCHAR,
"creation_date" TIMESTAMP_S,
"last_modified_date" TIMESTAMP_S,
"author_arn" VARCHAR,
"deleted" BOOLEAN,
"client_request_token" VARCHAR,
"caller_reactions" VARCHAR[],
"reaction_counts" MAP(VARCHAR, BIGINT)
)[]
Show child fields
comments[]
Show child fields
comments[].author_arn

The Amazon Resource Name (ARN) of the person who posted the comment.

comments[].caller_reactions[]
comments[].client_request_token

A unique, client-generated idempotency token that, when provided in a request, ensures the request cannot be repeated with a changed parameter. If a request is received with the same parameters and a token is included, the request returns information about the initial request that used that token.

comments[].comment_id

The system-generated comment ID.

comments[].content

The content of the comment.

comments[].creation_date

The date and time the comment was created, in timestamp format.

comments[].deleted

A Boolean value indicating whether the comment has been deleted.

comments[].in_reply_to

The ID of the comment for which this comment is a reply, if any.

comments[].last_modified_date

The date and time the comment was most recently modified, in timestamp format.

comments[].reaction_counts

A string to integer map that represents the number of individual users who have responded to a comment with the specified reactions.

location

Location information about the comment on the comparison, including the file name, line number, and whether the version of the file where the comment was made is BEFORE or AFTER.

STRUCT(
"file_path" VARCHAR,
"file_position" BIGINT,
"relative_file_version" VARCHAR
)
Show child fields
location.file_path

The name of the file being compared, including its extension and subdirectory, if any.

location.file_position

The position of a change in a compared file, in line number format.

location.relative_file_version

In a comparison of commits or a pull request, whether the change is in the before or after of that comparison.