Skip to content
AWS for Query.Farm

aws.cloudfront.list_field_level_encryption_profiles

Example SQL Queries

SELECT * FROM
aws.cloudfront.list_field_level_encryption_profiles;

Description

Request a list of field-level encryption profiles that have been created in CloudFront for this account.

Table Definition

Column NameColumn Data Type
marker Input Column

Use this when paginating results to indicate where to begin in your list of profiles. The results include profiles in the list that occur after the marker. To get the next page of results, set the Marker to the value of the NextMarker from the current page's response (which is also the ID of the last profile on that page).

VARCHAR
max_items Input Column

The maximum number of field-level encryption profiles you want in the response body. 

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.

field_level_encryption_profile_list

Returns a list of the field-level encryption profiles that have been created in CloudFront for this account.

STRUCT(
    "next_marker" VARCHAR,
    "max_items" BIGINT,
    "quantity" BIGINT,
    "items" STRUCT(
        "id" VARCHAR,
        "last_modified_time" TIMESTAMP_S,
        "name" VARCHAR,
        "encryption_entities" STRUCT(
            "quantity" BIGINT,
            "items" STRUCT(
                "public_key_id" VARCHAR,
                "provider_id" VARCHAR,
                "field_patterns" STRUCT(
                    "quantity" BIGINT,
                    "items" VARCHAR[]
                )
            )[]
        ),
        "comment" VARCHAR
    )[]
)
Show child fields
field_level_encryption_profile_list.items[]
Show child fields
field_level_encryption_profile_list.items[].comment

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

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

The number of field-level encryption field patterns.

field_level_encryption_profile_list.items[].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_list.items[].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_list.items[].encryption_entities.quantity

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

field_level_encryption_profile_list.items[].id

ID for the field-level encryption profile summary.

field_level_encryption_profile_list.items[].last_modified_time

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

field_level_encryption_profile_list.items[].name

Name for the field-level encryption profile summary.

field_level_encryption_profile_list.max_items

The maximum number of field-level encryption profiles you want in the response body.

field_level_encryption_profile_list.next_marker

If there are more elements to be listed, this element is present and contains the value that you can use for the Marker request parameter to continue listing your profiles where you left off.

field_level_encryption_profile_list.quantity

The number of field-level encryption profiles.