Skip to content
AWS for Query.Farm

aws.cloudfront.list_origin_request_policies

Example SQL Queries

SELECT * FROM
aws.cloudfront.list_origin_request_policies;

Description

Gets a list of origin request policies.

You can optionally apply a filter to return only the managed policies created by Amazon Web Services, or only the custom policies created in your Amazon Web Services account.

You can optionally specify the maximum number of items to receive in the response. If the total number of items in the list exceeds the maximum that you specify, or the default maximum, the response is paginated. To get the next page of items, send a subsequent request that specifies the NextMarker value from the current response as the Marker value in the subsequent request.

Table Definition

Column NameColumn Data Type
marker Input Column

Use this field when paginating results to indicate where to begin in your list of origin request policies. The response includes origin request policies in the list that occur after the marker. To get the next page of the list, set this field's value to the value of NextMarker from the current page's response.

VARCHAR
max_items Input Column

The maximum number of origin request policies that you want in the response.

VARCHAR
type Input Column

A filter to return only the specified kinds of origin request policies. Valid values are:

  • managed – Returns only the managed policies created by Amazon Web Services.

  • custom – Returns only the custom policies created in your Amazon Web Services account.

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.

origin_request_policy_list

A list of origin request policies.

STRUCT(
    "next_marker" VARCHAR,
    "max_items" BIGINT,
    "quantity" BIGINT,
    "items" STRUCT(
        "type" VARCHAR,
        "origin_request_policy" STRUCT(
            "id" VARCHAR,
            "last_modified_time" TIMESTAMP_S,
            "origin_request_policy_config" STRUCT(
                "comment" VARCHAR,
                "name" VARCHAR,
                "headers_config" STRUCT(
                    "header_behavior" VARCHAR,
                    "headers" STRUCT(
                        "quantity" BIGINT,
                        "items" VARCHAR[]
                    )
                ),
                "cookies_config" STRUCT(
                    "cookie_behavior" VARCHAR,
                    "cookies" STRUCT(
                        "quantity" BIGINT,
                        "items" VARCHAR[]
                    )
                ),
                "query_strings_config" STRUCT(
                    "query_string_behavior" VARCHAR,
                    "query_strings" STRUCT(
                        "quantity" BIGINT,
                        "items" VARCHAR[]
                    )
                )
            )
        )
    )[]
)
Show child fields
origin_request_policy_list.items[]
Show child fields
origin_request_policy_list.items[].origin_request_policy

The origin request policy.

Show child fields
origin_request_policy_list.items[].origin_request_policy.id

The unique identifier for the origin request policy.

origin_request_policy_list.items[].origin_request_policy.last_modified_time

The date and time when the origin request policy was last modified.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config

The origin request policy configuration.

Show child fields
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.comment

A comment to describe the origin request policy. The comment cannot be longer than 128 characters.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.cookies_config

The cookies from viewer requests to include in origin requests.

Show child fields
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.cookies_config.cookie_behavior

Determines whether cookies in viewer requests are included in requests that CloudFront sends to the origin. Valid values are:

  • none – No cookies in viewer requests are included in requests that CloudFront sends to the origin. Even when this field is set to none, any cookies that are listed in a CachePolicy are included in origin requests.

  • whitelist – Only the cookies in viewer requests that are listed in the CookieNames type are included in requests that CloudFront sends to the origin.

  • all – All cookies in viewer requests are included in requests that CloudFront sends to the origin.

  • allExcept – All cookies in viewer requests are included in requests that CloudFront sends to the origin, except for those listed in the CookieNames type, which are not included.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.cookies_config.cookies

Contains a list of cookie names.

Show child fields
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.cookies_config.cookies.items[]
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.cookies_config.cookies.quantity

The number of cookie names in the Items list.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.headers_config

The HTTP headers to include in origin requests. These can include headers from viewer requests and additional headers added by CloudFront.

Show child fields
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.headers_config.header_behavior

Determines whether any HTTP headers are included in requests that CloudFront sends to the origin. Valid values are:

  • none – No HTTP headers in viewer requests are included in requests that CloudFront sends to the origin. Even when this field is set to none, any headers that are listed in a CachePolicy are included in origin requests.

  • whitelist – Only the HTTP headers that are listed in the Headers type are included in requests that CloudFront sends to the origin.

  • allViewer – All HTTP headers in viewer requests are included in requests that CloudFront sends to the origin.

  • allViewerAndWhitelistCloudFront – All HTTP headers in viewer requests and the additional CloudFront headers that are listed in the Headers type are included in requests that CloudFront sends to the origin. The additional headers are added by CloudFront.

  • allExcept – All HTTP headers in viewer requests are included in requests that CloudFront sends to the origin, except for those listed in the Headers type, which are not included.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.headers_config.headers

Contains a list of HTTP header names.

Show child fields
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.headers_config.headers.items[]
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.headers_config.headers.quantity

The number of header names in the Items list.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.name

A unique name to identify the origin request policy.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.query_strings_config

The URL query strings from viewer requests to include in origin requests.

Show child fields
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.query_strings_config.query_string_behavior

Determines whether any URL query strings in viewer requests are included in requests that CloudFront sends to the origin. Valid values are:

  • none – No query strings in viewer requests are included in requests that CloudFront sends to the origin. Even when this field is set to none, any query strings that are listed in a CachePolicy are included in origin requests.

  • whitelist – Only the query strings in viewer requests that are listed in the QueryStringNames type are included in requests that CloudFront sends to the origin.

  • all – All query strings in viewer requests are included in requests that CloudFront sends to the origin.

  • allExcept – All query strings in viewer requests are included in requests that CloudFront sends to the origin, except for those listed in the QueryStringNames type, which are not included.

origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.query_strings_config.query_strings

Contains the specific query strings in viewer requests that either are or are not included in requests that CloudFront sends to the origin. The behavior depends on whether the QueryStringBehavior field in the OriginRequestPolicyQueryStringsConfig type is set to whitelist (the listed query strings are included) or allExcept (the listed query strings are not included, but all other query strings are).

Show child fields
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.query_strings_config.query_strings.items[]
origin_request_policy_list.items[].origin_request_policy.origin_request_policy_config.query_strings_config.query_strings.quantity

The number of query string names in the Items list.

origin_request_policy_list.items[].type

The type of origin request policy, either managed (created by Amazon Web Services) or custom (created in this Amazon Web Services account).

origin_request_policy_list.max_items

The maximum number of origin request policies requested.

origin_request_policy_list.next_marker

If there are more items in the list than are in this response, this element is present. It contains the value that you should use in the Marker field of a subsequent request to continue listing origin request policies where you left off.

origin_request_policy_list.quantity

The total number of origin request policies returned in the response.