Skip to content

aws.mediatailor.describe_channel

Example SQL Queries

SELECT * FROM
aws.mediatailor.describe_channel
WHERE
"channel_name" = 'VALUE';

Description

Describes a channel. For information about MediaTailor channels, see Working with channels in the MediaTailor User Guide.

Table Definition

Column NameColumn Data Type
channel_name Required Input Column

The name of the channel.

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.

arn

The ARN of the channel.

VARCHAR
audiences

The list of audiences defined in channel.

VARCHAR[]
Show child fields
audiences[]
channel_state

Indicates whether the channel is in a running state or not.

VARCHAR
creation_time

The timestamp of when the channel was created.

TIMESTAMP_S
filler_slate

Contains information about the slate used to fill gaps between programs in the schedule.

STRUCT(
"source_location_name" VARCHAR,
"vod_source_name" VARCHAR
)
Show child fields
filler_slate.source_location_name

The name of the source location where the slate VOD source is stored.

filler_slate.vod_source_name

The slate VOD source name. The VOD source must already exist in a source location before it can be used for slate.

last_modified_time

The timestamp of when the channel was last modified.

TIMESTAMP_S
log_configuration

The log configuration for the channel.

STRUCT(
"log_types" VARCHAR[]
)
Show child fields
log_configuration.log_types[]
outputs

The channel's output properties.

STRUCT(
"dash_playlist_settings" STRUCT(
"manifest_window_seconds" BIGINT,
"min_buffer_time_seconds" BIGINT,
"min_update_period_seconds" BIGINT,
"suggested_presentation_delay_seconds" BIGINT
),
"hls_playlist_settings" STRUCT(
"ad_markup_type" VARCHAR[],
"manifest_window_seconds" BIGINT
),
"manifest_name" VARCHAR,
"playback_url" VARCHAR,
"source_group" VARCHAR
)[]
Show child fields
outputs[]
Show child fields
outputs[].dash_playlist_settings

DASH manifest configuration settings.

Show child fields
outputs[].dash_playlist_settings.manifest_window_seconds

The total duration (in seconds) of each manifest. Minimum value: 30 seconds. Maximum value: 3600 seconds.

outputs[].dash_playlist_settings.min_buffer_time_seconds

Minimum amount of content (measured in seconds) that a player must keep available in the buffer. Minimum value: 2 seconds. Maximum value: 60 seconds.

outputs[].dash_playlist_settings.min_update_period_seconds

Minimum amount of time (in seconds) that the player should wait before requesting updates to the manifest. Minimum value: 2 seconds. Maximum value: 60 seconds.

outputs[].dash_playlist_settings.suggested_presentation_delay_seconds

Amount of time (in seconds) that the player should be from the live point at the end of the manifest. Minimum value: 2 seconds. Maximum value: 60 seconds.

outputs[].hls_playlist_settings

HLS manifest configuration settings.

Show child fields
outputs[].hls_playlist_settings.ad_markup_type[]
outputs[].hls_playlist_settings.manifest_window_seconds

The total duration (in seconds) of each manifest. Minimum value: 30 seconds. Maximum value: 3600 seconds.

outputs[].manifest_name

The name of the manifest for the channel that will appear in the channel output's playback URL.

outputs[].playback_url

The URL used for playback by content players.

outputs[].source_group

A string used to associate a package configuration source group with a channel output.

playback_mode

The channel's playback mode.

VARCHAR
tags

The tags assigned to the channel. Tags are key-value pairs that you can associate with Amazon resources to help with organization, access control, and cost tracking. For more information, see Tagging AWS Elemental MediaTailor Resources.

MAP(VARCHAR, VARCHAR)
tier

The channel's tier.

VARCHAR
time_shift_configuration

The time-shifted viewing configuration for the channel.

STRUCT(
"max_time_delay_seconds" BIGINT
)
Show child fields
time_shift_configuration.max_time_delay_seconds

The maximum time delay for time-shifted viewing. The minimum allowed maximum time delay is 0 seconds, and the maximum allowed maximum time delay is 21600 seconds (6 hours).