Skip to content

aws.codecommit.get_pull_request

Example SQL Queries

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

Description

Gets information about a pull request in a specified repository.

Table Definition

Column NameColumn Data Type
pull_request_id Required Input Column

The system-generated ID of the pull request. To get this ID, use ListPullRequests.

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
pull_request

Information about the specified pull request.

STRUCT(
"pull_request_id" VARCHAR,
"title" VARCHAR,
"description" VARCHAR,
"last_activity_date" TIMESTAMP_S,
"creation_date" TIMESTAMP_S,
"pull_request_status" VARCHAR,
"author_arn" VARCHAR,
"pull_request_targets" STRUCT(
"repository_name" VARCHAR,
"source_reference" VARCHAR,
"destination_reference" VARCHAR,
"destination_commit" VARCHAR,
"source_commit" VARCHAR,
"merge_base" VARCHAR,
"merge_metadata" STRUCT(
"is_merged" BOOLEAN,
"merged_by" VARCHAR,
"merge_commit_id" VARCHAR,
"merge_option" VARCHAR
)
)[],
"client_request_token" VARCHAR,
"revision_id" VARCHAR,
"approval_rules" STRUCT(
"approval_rule_id" VARCHAR,
"approval_rule_name" VARCHAR,
"approval_rule_content" VARCHAR,
"rule_content_sha256" VARCHAR,
"last_modified_date" TIMESTAMP_S,
"creation_date" TIMESTAMP_S,
"last_modified_user" VARCHAR,
"origin_approval_rule_template" STRUCT(
"approval_rule_template_id" VARCHAR,
"approval_rule_template_name" VARCHAR
)
)[]
)
Show child fields
pull_request.approval_rules[]
Show child fields
pull_request.approval_rules[].approval_rule_content

The content of the approval rule.

pull_request.approval_rules[].approval_rule_id

The system-generated ID of the approval rule.

pull_request.approval_rules[].approval_rule_name

The name of the approval rule.

pull_request.approval_rules[].creation_date

The date the approval rule was created, in timestamp format.

pull_request.approval_rules[].last_modified_date

The date the approval rule was most recently changed, in timestamp format.

pull_request.approval_rules[].last_modified_user

The Amazon Resource Name (ARN) of the user who made the most recent changes to the approval rule.

pull_request.approval_rules[].origin_approval_rule_template

The approval rule template used to create the rule.

Show child fields
pull_request.approval_rules[].origin_approval_rule_template.approval_rule_template_id

The ID of the template that created the approval rule.

pull_request.approval_rules[].origin_approval_rule_template.approval_rule_template_name

The name of the template that created the approval rule.

pull_request.approval_rules[].rule_content_sha256

The SHA-256 hash signature for the content of the approval rule.

pull_request.author_arn

The Amazon Resource Name (ARN) of the user who created the pull request.

pull_request.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.

pull_request.creation_date

The date and time the pull request was originally created, in timestamp format.

pull_request.description

The user-defined description of the pull request. This description can be used to clarify what should be reviewed and other details of the request.

pull_request.last_activity_date

The day and time of the last user or system activity on the pull request, in timestamp format.

pull_request.pull_request_id

The system-generated ID of the pull request.

pull_request.pull_request_status

The status of the pull request. Pull request status can only change from OPEN to CLOSED.

pull_request.pull_request_targets[]
Show child fields
pull_request.pull_request_targets[].destination_commit

The full commit ID that is the tip of the destination branch. This is the commit where the pull request was or will be merged.

pull_request.pull_request_targets[].destination_reference

The branch of the repository where the pull request changes are merged. Also known as the destination branch.

pull_request.pull_request_targets[].merge_base

The commit ID of the most recent commit that the source branch and the destination branch have in common.

pull_request.pull_request_targets[].merge_metadata

Returns metadata about the state of the merge, including whether the merge has been made.

Show child fields
pull_request.pull_request_targets[].merge_metadata.is_merged

A Boolean value indicating whether the merge has been made.

pull_request.pull_request_targets[].merge_metadata.merge_commit_id

The commit ID for the merge commit, if any.

pull_request.pull_request_targets[].merge_metadata.merge_option

The merge strategy used in the merge.

pull_request.pull_request_targets[].merge_metadata.merged_by

The Amazon Resource Name (ARN) of the user who merged the branches.

pull_request.pull_request_targets[].repository_name

The name of the repository that contains the pull request source and destination branches.

pull_request.pull_request_targets[].source_commit

The full commit ID of the tip of the source branch used to create the pull request. If the pull request branch is updated by a push while the pull request is open, the commit ID changes to reflect the new tip of the branch.

pull_request.pull_request_targets[].source_reference

The branch of the repository that contains the changes for the pull request. Also known as the source branch.

pull_request.revision_id

The system-generated revision ID for the pull request.

pull_request.title

The user-defined title of the pull request. This title is displayed in the list of pull requests to other repository users.