Skip to content

aws.cloudfront.list_streaming_distributions

Example SQL Queries

SELECT * FROM
aws.cloudfront.list_streaming_distributions;

Description

List streaming distributions.

Table Definition

Column NameColumn Data Type
_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.

aliases

A complex type that contains information about CNAMEs (alternate domain names), if any, for this streaming distribution.

STRUCT(
"quantity" BIGINT,
"items" VARCHAR[]
)
Show child fields
aliases.items[]
aliases.quantity

The number of CNAME aliases, if any, that you want to associate with this distribution.

arn

The ARN (Amazon Resource Name) for the streaming distribution. For example: arn:aws:cloudfront::123456789012:streaming-distribution/EDFDVBD632BHDS5, where 123456789012 is your Amazon Web Services account ID.

VARCHAR
comment

The comment originally specified when this distribution was created.

VARCHAR
domain_name

The domain name corresponding to the distribution, for example, d111111abcdef8.cloudfront.net.

VARCHAR
enabled

Whether the distribution is enabled to accept end user requests for content.

BOOLEAN
id

The identifier for the distribution, for example, EDFDVBD632BHDS5.

VARCHAR
last_modified_time

The date and time the distribution was last modified.

TIMESTAMP_S
price_class

A complex type that contains information about price class for this streaming distribution.

VARCHAR
s3_origin

A complex type that contains information about the Amazon S3 bucket from which you want CloudFront to get your media files for distribution.

STRUCT(
"domain_name" VARCHAR,
"origin_access_identity" VARCHAR
)
Show child fields
s3_origin.domain_name

The DNS name of the Amazon S3 origin.

s3_origin.origin_access_identity

The CloudFront origin access identity to associate with the distribution. Use an origin access identity to configure the distribution so that end users can only access objects in an Amazon S3 bucket through CloudFront.

If you want end users to be able to access objects using either the CloudFront URL or the Amazon S3 URL, specify an empty OriginAccessIdentity element.

To delete the origin access identity from an existing distribution, update the distribution configuration and include an empty OriginAccessIdentity element.

To replace the origin access identity, update the distribution configuration and specify the new origin access identity.

For more information, see Using an Origin Access Identity to Restrict Access to Your Amazon S3 Content in the Amazon CloudFront Developer Guide.

status

Indicates the current status of the distribution. When the status is Deployed, the distribution's information is fully propagated throughout the Amazon CloudFront system.

VARCHAR
trusted_signers

A complex type that specifies the Amazon Web Services accounts, if any, that you want to allow to create signed URLs for private content. If you want to require signed URLs in requests for objects in the target origin that match the PathPattern for this cache behavior, specify true for Enabled, and specify the applicable values for Quantity and Items.If you don't want to require signed URLs in requests for objects that match PathPattern, specify false for Enabled and 0 for Quantity. Omit Items. To add, change, or remove one or more trusted signers, change Enabled to true (if it's currently false), change Quantity as applicable, and specify all of the trusted signers that you want to include in the updated distribution.

For more information, see Serving Private Content through CloudFront in the Amazon CloudFront Developer Guide.

STRUCT(
"enabled" BOOLEAN,
"quantity" BIGINT,
"items" VARCHAR[]
)
Show child fields
trusted_signers.enabled

This field is true if any of the Amazon Web Services accounts in the list are configured as trusted signers. If not, this field is false.

trusted_signers.items[]
trusted_signers.quantity

The number of Amazon Web Services accounts in the list.