Skip to content
AWS for Query.Farm

aws.cloudfront.get_field_level_encryption_profile_config

Example SQL Queries

SELECT * FROM
aws.cloudfront.get_field_level_encryption_profile_config
WHERE
"id" = 'VALUE';

Description

Get the field-level encryption profile configuration information.

Table Definition

Column NameColumn Data Type
id Required Input Column

Get the ID for the field-level encryption profile configuration information.

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.

e_tag

The current version of the field-level encryption profile configuration result. For example: E2QWRUHAPOMQZL.

VARCHAR
field_level_encryption_profile_config

Return the field-level encryption profile configuration information.

STRUCT(
    "name" VARCHAR,
    "caller_reference" VARCHAR,
    "comment" VARCHAR,
    "encryption_entities" STRUCT(
        "quantity" BIGINT,
        "items" STRUCT(
            "public_key_id" VARCHAR,
            "provider_id" VARCHAR,
            "field_patterns" STRUCT(
                "quantity" BIGINT,
                "items" VARCHAR[]
            )
        )[]
    )
)
Show child fields
field_level_encryption_profile_config.caller_reference

A unique number that ensures that the request can't be replayed.

field_level_encryption_profile_config.comment

An optional comment for the field-level encryption profile. The comment cannot be longer than 128 characters.

field_level_encryption_profile_config.encryption_entities

A complex data type of encryption entities for the field-level encryption profile that include the public key ID, provider, and field patterns for specifying which fields to encrypt with this key.

Show child fields
field_level_encryption_profile_config.encryption_entities.items[]
Show child fields
field_level_encryption_profile_config.encryption_entities.items[].field_patterns

Field patterns in a field-level encryption content type profile specify the fields that you want to be encrypted. You can provide the full field name, or any beginning characters followed by a wildcard (*). You can't overlap field patterns. For example, you can't have both ABC* and AB*. Note that field patterns are case-sensitive.

Show child fields
field_level_encryption_profile_config.encryption_entities.items[].field_patterns.items[]
field_level_encryption_profile_config.encryption_entities.items[].field_patterns.quantity

The number of field-level encryption field patterns.

field_level_encryption_profile_config.encryption_entities.items[].provider_id

The provider associated with the public key being used for encryption. This value must also be provided with the private key for applications to be able to decrypt data.

field_level_encryption_profile_config.encryption_entities.items[].public_key_id

The public key associated with a set of field-level encryption patterns, to be used when encrypting the fields that match the patterns.

field_level_encryption_profile_config.encryption_entities.quantity

Number of field pattern items in a field-level encryption content type-profile mapping.

field_level_encryption_profile_config.name

Profile name for the field-level encryption profile.