Skip to content
AWS for Query.Farm

aws.cloudfront.get_field_level_encryption_profile

Example SQL Queries

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

Description

Get the field-level encryption profile information.

Table Definition

Column NameColumn Data Type
id Required Input Column

Get the ID for the field-level encryption profile 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. For example: E2QWRUHAPOMQZL.

VARCHAR
field_level_encryption_profile

Return the field-level encryption profile information.

STRUCT(
    "id" VARCHAR,
    "last_modified_time" TIMESTAMP_S,
    "field_level_encryption_profile_config" 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.field_level_encryption_profile_config

A complex data type that includes the profile name and the encryption entities for the field-level encryption profile.

Show child fields
field_level_encryption_profile.field_level_encryption_profile_config.caller_reference

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

field_level_encryption_profile.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.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.field_level_encryption_profile_config.encryption_entities.items[]
Show child fields
field_level_encryption_profile.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.field_level_encryption_profile_config.encryption_entities.items[].field_patterns.items[]
field_level_encryption_profile.field_level_encryption_profile_config.encryption_entities.items[].field_patterns.quantity

The number of field-level encryption field patterns.

field_level_encryption_profile.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.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.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.field_level_encryption_profile_config.name

Profile name for the field-level encryption profile.

field_level_encryption_profile.id

The ID for a field-level encryption profile configuration which includes a set of profiles that specify certain selected data fields to be encrypted by specific public keys.

field_level_encryption_profile.last_modified_time

The last time the field-level encryption profile was updated.