steampipe plugin install awssteampipe plugin install aws

Table: aws_cloudfront_cache_policy

CloudFront provides a set of managed cache policies that you can attach to any of your distribution’s cache behaviors. With a managed cache policy, you don’t need to write or maintain your own cache policy. The managed policies use settings that are optimized for specific use cases. However you can write your own cache policy also if required.

Examples

Basic info

select
  id,
  name,
  comment,
  min_ttl,
  etag,
  last_modified_time
from
  aws_cloudfront_cache_policy;

List cache policies where Gzip compression format is not enabled

select
  id,
  name,
  parameters_in_cache_key_and_forwarded_to_origin ->> 'EnableAcceptEncodingGzip' as enable_gzip
from
  aws_cloudfront_cache_policy
where
  parameters_in_cache_key_and_forwarded_to_origin ->> 'EnableAcceptEncodingGzip' <> 'true';

List cache policies where Brotli compression format is not enabled

select
  id,
  name,
  parameters_in_cache_key_and_forwarded_to_origin ->> 'EnableAcceptEncodingBrotli' as enable_brotli
from
  aws_cloudfront_cache_policy
where
  parameters_in_cache_key_and_forwarded_to_origin ->> 'EnableAcceptEncodingBrotli' <> 'true';

.inspect aws_cloudfront_cache_policy

AWS CloudFront Cache Policy

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
comment	text	A comment to describe the cache policy.
default_ttl	bigint	The default amount of time, in seconds, that you want objects to stay in the CloudFront cache before CloudFront sends another request to the origin to see if the object has been updated.
etag	text	The current version of the cache policy.
id	text	The unique identifier for the cache policy.
last_modified_time	timestamp with time zone	The date and time when the cache policy was last modified.
max_ttl	bigint	The maximum amount of time, in seconds, that you want objects to stay in the CloudFront cache before CloudFront sends another request to the origin to see if the object has been updated.
min_ttl	bigint	The minimum amount of time, in seconds, that you want objects to stay in the CloudFront cache before CloudFront sends another request to the origin to see if the object has been updated.
name	text	A unique name to identify the cache policy.
parameters_in_cache_key_and_forwarded_to_origin	jsonb	The HTTP headers, cookies, and URL query strings to include in the cache key. The values included in the cache key are automatically included in requests that CloudFront sends to the origin.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
title	text	Title of the resource.

turbot/aws

Table: aws_cloudfront_cache_policy

Examples

Basic info

List cache policies where Gzip compression format is not enabled

List cache policies where Brotli compression format is not enabled

.inspect aws_cloudfront_cache_policy

Steampipe

Resources

Community