Skip to content

aws.signer.get_signing_profile

Example SQL Queries

SELECT * FROM
aws.signer.get_signing_profile
WHERE
"profile_name" = 'VALUE';

Description

Returns information on a specific signing profile.

Table Definition

Column NameColumn Data Type
profile_name Required Input Column

The name of the target signing profile.

VARCHAR
profile_owner Input Column

The AWS account ID of the profile owner.

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
arn

The Amazon Resource Name (ARN) for the signing profile.

VARCHAR
overrides

A list of overrides applied by the target signing profile for signing operations.

STRUCT(
"signing_configuration" STRUCT(
"encryption_algorithm" VARCHAR,
"hash_algorithm" VARCHAR
),
"signing_image_format" VARCHAR
)
Show child fields
overrides.signing_configuration

A signing configuration that overrides the default encryption or hash algorithm of a signing job.

Show child fields
overrides.signing_configuration.encryption_algorithm

A specified override of the default encryption algorithm that is used in a code-signing job.

overrides.signing_configuration.hash_algorithm

A specified override of the default hash algorithm that is used in a code-signing job.

overrides.signing_image_format

A signed image is a JSON object. When overriding the default signing platform configuration, a customer can select either of two signing formats, JSONEmbedded or JSONDetached. (A third format value, JSON, is reserved for future use.) With JSONEmbedded, the signing image has the payload embedded in it. With JSONDetached, the payload is not be embedded in the signing image.

platform_display_name

A human-readable name for the signing platform associated with the signing profile.

VARCHAR
platform_id

The ID of the platform that is used by the target signing profile.

VARCHAR
profile_version

The current version of the signing profile.

VARCHAR
profile_version_arn

The signing profile ARN, including the profile version.

VARCHAR
revocation_record

Revocation information for a signing profile.

STRUCT(
"revocation_effective_from" TIMESTAMP_S,
"revoked_at" TIMESTAMP_S,
"revoked_by" VARCHAR
)
Show child fields
revocation_record.revocation_effective_from

The time when revocation becomes effective.

revocation_record.revoked_at

The time when the signing profile was revoked.

revocation_record.revoked_by

The identity of the revoker.

signature_validity_period

The validity period for a signing job.

STRUCT(
"value" BIGINT,
"type" VARCHAR
)
Show child fields
signature_validity_period.type

The time unit for signature validity.

signature_validity_period.value

The numerical value of the time unit for signature validity.

signing_material

The ARN of the certificate that the target profile uses for signing operations.

STRUCT(
"certificate_arn" VARCHAR
)
Show child fields
signing_material.certificate_arn

The Amazon Resource Name (ARN) of the certificates that is used to sign your code.

signing_parameters

A map of key-value pairs for signing operations that is attached to the target signing profile.

MAP(VARCHAR, VARCHAR)
status

The status of the target signing profile.

VARCHAR
status_reason

Reason for the status of the target signing profile.

VARCHAR
tags

A list of tags associated with the signing profile.

MAP(VARCHAR, VARCHAR)