Skip to content

aws.medialive.describe_multiplex_program

Example SQL Queries

SELECT * FROM
aws.medialive.describe_multiplex_program
WHERE
"multiplex_id" = 'VALUE'
AND "program_name" = 'VALUE';

Description

Get the details for a program in a multiplex.

Table Definition

Column NameColumn Data Type
multiplex_id Required Input Column

The ID of the multiplex that the program belongs to.

VARCHAR
program_name Required Input Column

The name of the multiplex program.

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.

_aws_region Input Column

The AWS region to use.

VARCHAR
channel_id

The MediaLive channel associated with the program.

VARCHAR
multiplex_program_settings

The settings for this multiplex program.

STRUCT(
"preferred_channel_pipeline" VARCHAR,
"program_number" BIGINT,
"service_descriptor" STRUCT(
"provider_name" VARCHAR,
"service_name" VARCHAR
),
"video_settings" STRUCT(
"constant_bitrate" BIGINT,
"statmux_settings" STRUCT(
"maximum_bitrate" BIGINT,
"minimum_bitrate" BIGINT,
"priority" BIGINT
)
)
)
Show child fields
multiplex_program_settings.preferred_channel_pipeline

Indicates which pipeline is preferred by the multiplex for program ingest.

multiplex_program_settings.program_number

Unique program number.

multiplex_program_settings.service_descriptor

Transport stream service descriptor configuration for the Multiplex program.

Show child fields
multiplex_program_settings.service_descriptor.provider_name

Name of the provider.

multiplex_program_settings.service_descriptor.service_name

Name of the service.

multiplex_program_settings.video_settings

Program video settings configuration.

Show child fields
multiplex_program_settings.video_settings.constant_bitrate

The constant bitrate configuration for the video encode. When this field is defined, StatmuxSettings must be undefined.

multiplex_program_settings.video_settings.statmux_settings

Statmux rate control settings. When this field is defined, ConstantBitrate must be undefined.

Show child fields
multiplex_program_settings.video_settings.statmux_settings.maximum_bitrate

Maximum statmux bitrate.

multiplex_program_settings.video_settings.statmux_settings.minimum_bitrate

Minimum statmux bitrate.

multiplex_program_settings.video_settings.statmux_settings.priority

The purpose of the priority is to use a combination of the\nmultiplex rate control algorithm and the QVBR capability of the\nencoder to prioritize the video quality of some channels in a\nmultiplex over others. Channels that have a higher priority will\nget higher video quality at the expense of the video quality of\nother channels in the multiplex with lower priority.

packet_identifiers_map

The packet identifier map for this multiplex program.

STRUCT(
"audio_pids" BIGINT[],
"dvb_sub_pids" BIGINT[],
"dvb_teletext_pid" BIGINT,
"etv_platform_pid" BIGINT,
"etv_signal_pid" BIGINT,
"klv_data_pids" BIGINT[],
"pcr_pid" BIGINT,
"pmt_pid" BIGINT,
"private_metadata_pid" BIGINT,
"scte27_pids" BIGINT[],
"scte35_pid" BIGINT,
"timed_metadata_pid" BIGINT,
"video_pid" BIGINT,
"arib_captions_pid" BIGINT,
"dvb_teletext_pids" BIGINT[],
"ecm_pid" BIGINT,
"smpte2038_pid" BIGINT
)
Show child fields
packet_identifiers_map.arib_captions_pid

Placeholder documentation for __integer

packet_identifiers_map.audio_pids[]
packet_identifiers_map.dvb_sub_pids[]
packet_identifiers_map.dvb_teletext_pid

Placeholder documentation for __integer

packet_identifiers_map.dvb_teletext_pids[]
packet_identifiers_map.ecm_pid

Placeholder documentation for __integer

packet_identifiers_map.etv_platform_pid

Placeholder documentation for __integer

packet_identifiers_map.etv_signal_pid

Placeholder documentation for __integer

packet_identifiers_map.klv_data_pids[]
packet_identifiers_map.pcr_pid

Placeholder documentation for __integer

packet_identifiers_map.pmt_pid

Placeholder documentation for __integer

packet_identifiers_map.private_metadata_pid

Placeholder documentation for __integer

packet_identifiers_map.scte27_pids[]
packet_identifiers_map.scte35_pid

Placeholder documentation for __integer

packet_identifiers_map.smpte2038_pid

Placeholder documentation for __integer

packet_identifiers_map.timed_metadata_pid

Placeholder documentation for __integer

packet_identifiers_map.video_pid

Placeholder documentation for __integer

pipeline_details

Contains information about the current sources for the specified program in the specified multiplex. Keep in mind that each multiplex pipeline connects to both pipelines in a given source channel (the channel identified by the program). But only one of those channel pipelines is ever active at one time.

STRUCT(
"active_channel_pipeline" VARCHAR,
"pipeline_id" VARCHAR
)[]
Show child fields
pipeline_details[]
Show child fields
pipeline_details[].active_channel_pipeline

Identifies the channel pipeline that is currently active for the pipeline (identified by PipelineId) in the multiplex.

pipeline_details[].pipeline_id

Identifies a specific pipeline in the multiplex.