Skip to main content
Version: 0.0.25

Table: distribution

Table to query for all AWS CloudFront distributions in the system. Amazon CloudFront is a web service that speeds up distribution of your static and dynamic web content, such as .html, .css, .js, and image files, to your users.

You create a CloudFront distribution to tell CloudFront where you want content to be delivered from, and the details about how to track and manage content delivery.


 INSERT INTO distribution (caller_reference, comment, enabled, is_ipv6_enabled, default_cache_behavior, origins ) VALUES ('s3-bucket-ref', 'a comment', true, false, "{
TargetOriginId: s3-caller,
ViewerProtocolPolicy: 'allow-all',
CachePolicyId: 'cache-policy-id',
}"", '[
DomainName: ``,
Id: s3OriginId,
S3OriginConfig: { OriginAccessIdentity: '' },

SELECT * FROM distribution WHERE caller_reference='s3-bucket-ref';
DELETE FROM distribution WHERE caller_reference = 's3-bucket-ref';



Optional caller_reference: string

An unique value to identify the CloudFront distribution

Optional comment: string

Internal comments to describe the distribution

default_cache_behavior: Object

A complex type that describes the default cache behavior


Type declaration

cache_policy_idundefined | string
target_origin_idundefined | string

Optional distribution_id: string

AWS ID for the CloudFront distribution

Optional domain_name: string

Domain name assigned to the distribution by CloudFront

Optional e_tag: string

The current version of the distribution's information

Optional enabled: boolean

Whether the distribution is enabled or not

Optional is_ipv6_enabled: boolean

Whether to enable IPV6 for this distribution

origins: { custom_origin_config: undefined | { http_port: undefined | number ; https_port: undefined | number ; origin_protocol_policy: origin_protocol_policy } ; domain_name: undefined | string ; id: undefined | string ; origin_shield: any ; s3_origin_config: undefined | { origin_access_identity: undefined | string } }[]

A complex type that contains information about origins for this distribution.


Optional status: string

The distribution’s status. When the status is Deployed, the distribution’s information is fully propagated to all CloudFront edge locations.

Optional web_acl_id: string

A unique identifier that specifies the WAF web ACL, if any, to associate with this distribution