Skip to content
AWS for Query.Farm

aws.cloudfront.get_streaming_distribution_config

Example SQL Queries

SELECT * FROM
aws.cloudfront.get_streaming_distribution_config
WHERE
"id" = 'VALUE';

Description

Get the configuration information about a streaming distribution.

Table Definition

Column NameColumn Data Type
id Required Input Column

The streaming distribution's ID.

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.

e_tag

The current version of the configuration. For example: E2QWRUHAPOMQZL. 

VARCHAR
streaming_distribution_config

The streaming distribution's configuration information.

STRUCT(
    "caller_reference" VARCHAR,
    "s3_origin" STRUCT(
        "domain_name" VARCHAR,
        "origin_access_identity" VARCHAR
    ),
    "aliases" STRUCT(
        "quantity" BIGINT,
        "items" VARCHAR[]
    ),
    "comment" VARCHAR,
    "logging" STRUCT(
        "enabled" BOOLEAN,
        "bucket" VARCHAR,
        "prefix" VARCHAR
    ),
    "trusted_signers" STRUCT(
        "enabled" BOOLEAN,
        "quantity" BIGINT,
        "items" VARCHAR[]
    ),
    "price_class" VARCHAR,
    "enabled" BOOLEAN
)
Show child fields
streaming_distribution_config.aliases

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

Show child fields
streaming_distribution_config.aliases.items[]
streaming_distribution_config.aliases.quantity

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

streaming_distribution_config.caller_reference

A unique value (for example, a date-time stamp) that ensures that the request can't be replayed.

If the value of CallerReference is new (regardless of the content of the StreamingDistributionConfig object), CloudFront creates a new distribution.

If CallerReference is a value that you already sent in a previous request to create a distribution, CloudFront returns a DistributionAlreadyExists error.

streaming_distribution_config.comment

Any comments you want to include about the streaming distribution.

streaming_distribution_config.enabled

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

streaming_distribution_config.logging

A complex type that controls whether access logs are written for the streaming distribution.

Show child fields
streaming_distribution_config.logging.bucket

The Amazon S3 bucket to store the access logs in, for example, myawslogbucket.s3.amazonaws.com.

streaming_distribution_config.logging.enabled

Specifies whether you want CloudFront to save access logs to an Amazon S3 bucket. If you don't want to enable logging when you create a streaming distribution or if you want to disable logging for an existing streaming distribution, specify false for Enabled, and specify empty Bucket and Prefix elements. If you specify false for Enabled but you specify values for Bucket and Prefix, the values are automatically deleted.

streaming_distribution_config.logging.prefix

An optional string that you want CloudFront to prefix to the access log filenames for this streaming distribution, for example, myprefix/. If you want to enable logging, but you don't want to specify a prefix, you still must include an empty Prefix element in the Logging element.

streaming_distribution_config.price_class

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

streaming_distribution_config.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.

Show child fields
streaming_distribution_config.s3_origin.domain_name

The DNS name of the Amazon S3 origin.

streaming_distribution_config.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.

streaming_distribution_config.trusted_signers

A complex type that specifies any Amazon Web Services accounts that you want to permit to create signed URLs for private content. If you want the distribution to use signed URLs, include this element; if you want the distribution to use public URLs, remove this element. For more information, see Serving Private Content through CloudFront in the Amazon CloudFront Developer Guide.

Show child fields
streaming_distribution_config.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.

streaming_distribution_config.trusted_signers.items[]
streaming_distribution_config.trusted_signers.quantity

The number of Amazon Web Services accounts in the list.