Skip to content

aws.cloudfront.get_streaming_distribution

Example SQL Queries

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

Description

Gets information about a specified RTMP distribution, including the distribution configuration.

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 streaming distribution's information. For example: E2QWRUHAPOMQZL.

VARCHAR
streaming_distribution

The streaming distribution's information.

STRUCT(
"id" VARCHAR,
"arn" VARCHAR,
"status" VARCHAR,
"last_modified_time" TIMESTAMP_S,
"domain_name" VARCHAR,
"active_trusted_signers" STRUCT(
"enabled" BOOLEAN,
"quantity" BIGINT,
"items" STRUCT(
"aws_account_number" VARCHAR,
"key_pair_ids" STRUCT(
"quantity" BIGINT,
"items" VARCHAR[]
)
)[]
),
"streaming_distribution_config" 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.active_trusted_signers

A complex type that lists the Amazon Web Services accounts, if any, that you included in the TrustedSigners complex type for this distribution. These are the accounts that you want to allow to create signed URLs for private content.

The Signer complex type lists the Amazon Web Services account number of the trusted signer or self if the signer is the Amazon Web Services account that created the distribution. The Signer element also includes the IDs of any active CloudFront key pairs that are associated with the trusted signer's Amazon Web Services account. If no KeyPairId element appears for a Signer, that signer can't create signed URLs.

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

Show child fields
streaming_distribution.active_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.active_trusted_signers.items[]
Show child fields
streaming_distribution.active_trusted_signers.items[].aws_account_number

An Amazon Web Services account number that contains active CloudFront key pairs that CloudFront can use to verify the signatures of signed URLs and signed cookies. If the Amazon Web Services account that owns the key pairs is the same account that owns the CloudFront distribution, the value of this field is self.

streaming_distribution.active_trusted_signers.items[].key_pair_ids

A list of CloudFront key pair identifiers.

Show child fields
streaming_distribution.active_trusted_signers.items[].key_pair_ids.items[]
streaming_distribution.active_trusted_signers.items[].key_pair_ids.quantity

The number of key pair identifiers in the list.

streaming_distribution.active_trusted_signers.quantity

The number of Amazon Web Services accounts in the list.

streaming_distribution.arn

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

streaming_distribution.domain_name

The domain name that corresponds to the streaming distribution, for example, s5c39gqb8ow64r.cloudfront.net.

streaming_distribution.id

The identifier for the RTMP distribution. For example: EGTXBD79EXAMPLE.

streaming_distribution.last_modified_time

The date and time that the distribution was last modified.

streaming_distribution.status

The current status of the RTMP distribution. When the status is Deployed, the distribution's information is propagated to all CloudFront edge locations.

streaming_distribution.streaming_distribution_config

The current configuration information for the RTMP distribution.

Show child fields
streaming_distribution.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.streaming_distribution_config.aliases.items[]
streaming_distribution.streaming_distribution_config.aliases.quantity

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

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

Any comments you want to include about the streaming distribution.

streaming_distribution.streaming_distribution_config.enabled

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

streaming_distribution.streaming_distribution_config.logging

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

Show child fields
streaming_distribution.streaming_distribution_config.logging.bucket

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

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

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

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

The DNS name of the Amazon S3 origin.

streaming_distribution.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.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.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.streaming_distribution_config.trusted_signers.items[]
streaming_distribution.streaming_distribution_config.trusted_signers.quantity

The number of Amazon Web Services accounts in the list.