Skip to content
AWS for Query.Farm

aws.codecommit.get_comments_for_pull_request

Example SQL Queries

SELECT * FROM
aws.codecommit.get_comments_for_pull_request
WHERE
"pull_request_id" = 'VALUE';

Description

Returns comments made on a pull request.

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
pull_request_id Required Input Column

The system-generated ID of the pull request.

VARCHAR
after_commit_id Input Column

The full commit ID of the commit that was the tip of the source branch at the time the comment was made. 

VARCHAR
before_commit_id Input Column

The full commit ID of the commit that was the tip of the destination branch when the pull request was created. This commit is superceded by the after commit in the source branch when and if you merge the source branch into the destination branch.

VARCHAR
repository_name Input Column

The name of the repository that contains the pull request.

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 file on which you want to comment on the source commit.

VARCHAR
before_blob_id

The full blob ID of the file on which you want to comment on the destination commit.

VARCHAR
comments

An array of comment objects. Each comment object contains information about a comment on the pull request.

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 pull request, including the file name, line number, and whether the version of the file where the comment was made is BEFORE (destination branch) or AFTER (source branch).

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.