Skip to content

aws.mediatailor.list_channels

Example SQL Queries

SELECT * FROM
aws.mediatailor.list_channels;

Description

Retrieves information about the channels that are associated with the current AWS account.

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.

arn

The ARN of the channel.

VARCHAR
audiences

The list of audiences defined in channel.

VARCHAR[]
Show child fields
audiences[]
channel_name

The name of the channel.

VARCHAR
channel_state

Returns the state whether the channel is running or not.

VARCHAR
creation_time

The timestamp of when the channel was created.

TIMESTAMP_S
filler_slate

The slate used to fill gaps between programs in the schedule. You must configure filler slate if your channel uses the LINEAR PlaybackMode. MediaTailor doesn't support filler slate for channels using the LOOP PlaybackMode.

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.

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 type of playback mode for this channel.

LINEAR - Programs play back-to-back only once.

LOOP - Programs play back-to-back in an endless loop. When the last program in the schedule plays, playback loops back to the first program in the schedule.

VARCHAR
tags

The tags to assign 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 tier for this channel. STANDARD tier channels can contain live programs.

VARCHAR