Skip to content
AWS for Query.Farm

aws.mediapackage_vod.list_packaging_configurations

Example SQL Queries

SELECT * FROM
aws.mediapackage_vod.list_packaging_configurations;

Description

Returns a collection of MediaPackage VOD PackagingConfiguration resources.

Table Definition

Column NameColumn Data Type
packaging_group_id Input Column

The ID of a PackagingGroup.

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
arn

The ARN of the PackagingConfiguration.

VARCHAR
cmaf_package

A CMAF packaging configuration.

STRUCT(
    "encryption" STRUCT(
        "constant_initialization_vector" VARCHAR,
        "speke_key_provider" STRUCT(
            "encryption_contract_configuration" STRUCT(
                "preset_speke20_audio" VARCHAR,
                "preset_speke20_video" VARCHAR
            ),
            "role_arn" VARCHAR,
            "system_ids" VARCHAR[],
            "url" VARCHAR
        )
    ),
    "hls_manifests" STRUCT(
        "ad_markers" VARCHAR,
        "include_iframe_only_stream" BOOLEAN,
        "manifest_name" VARCHAR,
        "program_date_time_interval_seconds" BIGINT,
        "repeat_ext_x_key" BOOLEAN,
        "stream_selection" STRUCT(
            "max_video_bits_per_second" BIGINT,
            "min_video_bits_per_second" BIGINT,
            "stream_order" VARCHAR
        )
    )[],
    "include_encoder_configuration_in_segments" BOOLEAN,
    "segment_duration_seconds" BIGINT
)
Show child fields
cmaf_package.encryption

A CMAF encryption configuration.

Show child fields
cmaf_package.encryption.constant_initialization_vector

An optional 128-bit, 16-byte hex value represented by a 32-character string, used in conjunction with the key for encrypting blocks. If you don't specify a value, then MediaPackage creates the constant initialization vector (IV).

cmaf_package.encryption.speke_key_provider

A configuration for accessing an external Secure Packager and Encoder Key Exchange (SPEKE) service that will provide encryption keys.

Show child fields
cmaf_package.encryption.speke_key_provider.encryption_contract_configuration

Use encryptionContractConfiguration to configure one or more content encryption keys for your endpoints that use SPEKE 2.0. The encryption contract defines which content keys are used to encrypt the audio and video tracks in your stream. To configure the encryption contract, specify which audio and video encryption presets to use. Note the following considerations when using encryptionContractConfiguration: encryptionContractConfiguration can be used for DASH endpoints that use SPEKE 2.0. SPEKE 2.0 relies on the CPIX 2.3 specification. You must disable key rotation for this endpoint by setting keyRotationIntervalSeconds to 0.

Show child fields
cmaf_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_audio

A collection of audio encryption presets.

cmaf_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_video

A collection of video encryption presets.

cmaf_package.encryption.speke_key_provider.role_arn

An Amazon Resource Name (ARN) of an IAM role that AWS Elemental MediaPackage will assume when accessing the key provider service.

cmaf_package.encryption.speke_key_provider.system_ids[]
cmaf_package.encryption.speke_key_provider.url

The URL of the external key provider service.

cmaf_package.hls_manifests[]
Show child fields
cmaf_package.hls_manifests[].ad_markers

This setting controls how ad markers are included in the packaged OriginEndpoint. "NONE" will omit all SCTE-35 ad markers from the output. "PASSTHROUGH" causes the manifest to contain a copy of the SCTE-35 ad markers (comments) taken directly from the input HTTP Live Streaming (HLS) manifest. "SCTE35_ENHANCED" generates ad markers and blackout tags based on SCTE-35 messages in the input source.

cmaf_package.hls_manifests[].include_iframe_only_stream

When enabled, an I-Frame only stream will be included in the output.

cmaf_package.hls_manifests[].manifest_name

An optional string to include in the name of the manifest.

cmaf_package.hls_manifests[].program_date_time_interval_seconds

The interval (in seconds) between each EXT-X-PROGRAM-DATE-TIME tag inserted into manifests. Additionally, when an interval is specified ID3Timed Metadata messages will be generated every 5 seconds using the ingest time of the content. If the interval is not specified, or set to 0, then no EXT-X-PROGRAM-DATE-TIME tags will be inserted into manifests and no ID3Timed Metadata messages will be generated. Note that irrespective of this parameter, if any ID3 Timed Metadata is found in HTTP Live Streaming (HLS) input, it will be passed through to HLS output.

cmaf_package.hls_manifests[].repeat_ext_x_key

When enabled, the EXT-X-KEY tag will be repeated in output manifests.

cmaf_package.hls_manifests[].stream_selection

A StreamSelection configuration.

Show child fields
cmaf_package.hls_manifests[].stream_selection.max_video_bits_per_second

The maximum video bitrate (bps) to include in output.

cmaf_package.hls_manifests[].stream_selection.min_video_bits_per_second

The minimum video bitrate (bps) to include in output.

cmaf_package.hls_manifests[].stream_selection.stream_order

A directive that determines the order of streams in the output.

cmaf_package.include_encoder_configuration_in_segments

When includeEncoderConfigurationInSegments is set to true, MediaPackage places your encoder's Sequence Parameter Set (SPS), Picture Parameter Set (PPS), and Video Parameter Set (VPS) metadata in every video segment instead of in the init fragment. This lets you use different SPS/PPS/VPS settings for your assets during content playback.

cmaf_package.segment_duration_seconds

Duration (in seconds) of each fragment. Actual fragments will be rounded to the nearest multiple of the source fragment duration.

created_at

The time the PackagingConfiguration was created.

VARCHAR
dash_package

A Dynamic Adaptive Streaming over HTTP (DASH) packaging configuration.

STRUCT(
    "dash_manifests" STRUCT(
        "manifest_layout" VARCHAR,
        "manifest_name" VARCHAR,
        "min_buffer_time_seconds" BIGINT,
        "profile" VARCHAR,
        "scte_markers_source" VARCHAR,
        "stream_selection" STRUCT(
            "max_video_bits_per_second" BIGINT,
            "min_video_bits_per_second" BIGINT,
            "stream_order" VARCHAR
        )
    )[],
    "encryption" STRUCT(
        "speke_key_provider" STRUCT(
            "encryption_contract_configuration" STRUCT(
                "preset_speke20_audio" VARCHAR,
                "preset_speke20_video" VARCHAR
            ),
            "role_arn" VARCHAR,
            "system_ids" VARCHAR[],
            "url" VARCHAR
        )
    ),
    "include_encoder_configuration_in_segments" BOOLEAN,
    "include_iframe_only_stream" BOOLEAN,
    "period_triggers" VARCHAR[],
    "segment_duration_seconds" BIGINT,
    "segment_template_format" VARCHAR
)
Show child fields
dash_package.dash_manifests[]
Show child fields
dash_package.dash_manifests[].manifest_layout

Determines the position of some tags in the Media Presentation Description (MPD). When set to FULL, elements like SegmentTemplate and ContentProtection are included in each Representation. When set to COMPACT, duplicate elements are combined and presented at the AdaptationSet level.

dash_package.dash_manifests[].manifest_name

An optional string to include in the name of the manifest.

dash_package.dash_manifests[].min_buffer_time_seconds

Minimum duration (in seconds) that a player will buffer media before starting the presentation.

dash_package.dash_manifests[].profile

The Dynamic Adaptive Streaming over HTTP (DASH) profile type. When set to "HBBTV_1_5", HbbTV 1.5 compliant output is enabled.

dash_package.dash_manifests[].scte_markers_source

The source of scte markers used. When set to SEGMENTS, the scte markers are sourced from the segments of the ingested content. When set to MANIFEST, the scte markers are sourced from the manifest of the ingested content.

dash_package.dash_manifests[].stream_selection

A StreamSelection configuration.

Show child fields
dash_package.dash_manifests[].stream_selection.max_video_bits_per_second

The maximum video bitrate (bps) to include in output.

dash_package.dash_manifests[].stream_selection.min_video_bits_per_second

The minimum video bitrate (bps) to include in output.

dash_package.dash_manifests[].stream_selection.stream_order

A directive that determines the order of streams in the output.

dash_package.encryption

A Dynamic Adaptive Streaming over HTTP (DASH) encryption configuration.

Show child fields
dash_package.encryption.speke_key_provider

A configuration for accessing an external Secure Packager and Encoder Key Exchange (SPEKE) service that will provide encryption keys.

Show child fields
dash_package.encryption.speke_key_provider.encryption_contract_configuration

Use encryptionContractConfiguration to configure one or more content encryption keys for your endpoints that use SPEKE 2.0. The encryption contract defines which content keys are used to encrypt the audio and video tracks in your stream. To configure the encryption contract, specify which audio and video encryption presets to use. Note the following considerations when using encryptionContractConfiguration: encryptionContractConfiguration can be used for DASH endpoints that use SPEKE 2.0. SPEKE 2.0 relies on the CPIX 2.3 specification. You must disable key rotation for this endpoint by setting keyRotationIntervalSeconds to 0.

Show child fields
dash_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_audio

A collection of audio encryption presets.

dash_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_video

A collection of video encryption presets.

dash_package.encryption.speke_key_provider.role_arn

An Amazon Resource Name (ARN) of an IAM role that AWS Elemental MediaPackage will assume when accessing the key provider service.

dash_package.encryption.speke_key_provider.system_ids[]
dash_package.encryption.speke_key_provider.url

The URL of the external key provider service.

dash_package.include_encoder_configuration_in_segments

When includeEncoderConfigurationInSegments is set to true, MediaPackage places your encoder's Sequence Parameter Set (SPS), Picture Parameter Set (PPS), and Video Parameter Set (VPS) metadata in every video segment instead of in the init fragment. This lets you use different SPS/PPS/VPS settings for your assets during content playback.

dash_package.include_iframe_only_stream

When enabled, an I-Frame only stream will be included in the output.

dash_package.period_triggers[]
dash_package.segment_duration_seconds

Duration (in seconds) of each segment. Actual segments will be rounded to the nearest multiple of the source segment duration.

dash_package.segment_template_format

Determines the type of SegmentTemplate included in the Media Presentation Description (MPD). When set to NUMBER_WITH_TIMELINE, a full timeline is presented in each SegmentTemplate, with $Number$ media URLs. When set to TIME_WITH_TIMELINE, a full timeline is presented in each SegmentTemplate, with $Time$ media URLs. When set to NUMBER_WITH_DURATION, only a duration is included in each SegmentTemplate, with $Number$ media URLs.

hls_package

An HTTP Live Streaming (HLS) packaging configuration.

STRUCT(
    "encryption" STRUCT(
        "constant_initialization_vector" VARCHAR,
        "encryption_method" VARCHAR,
        "speke_key_provider" STRUCT(
            "encryption_contract_configuration" STRUCT(
                "preset_speke20_audio" VARCHAR,
                "preset_speke20_video" VARCHAR
            ),
            "role_arn" VARCHAR,
            "system_ids" VARCHAR[],
            "url" VARCHAR
        )
    ),
    "hls_manifests" STRUCT(
        "ad_markers" VARCHAR,
        "include_iframe_only_stream" BOOLEAN,
        "manifest_name" VARCHAR,
        "program_date_time_interval_seconds" BIGINT,
        "repeat_ext_x_key" BOOLEAN,
        "stream_selection" STRUCT(
            "max_video_bits_per_second" BIGINT,
            "min_video_bits_per_second" BIGINT,
            "stream_order" VARCHAR
        )
    )[],
    "include_dvb_subtitles" BOOLEAN,
    "segment_duration_seconds" BIGINT,
    "use_audio_rendition_group" BOOLEAN
)
Show child fields
hls_package.encryption

An HTTP Live Streaming (HLS) encryption configuration.

Show child fields
hls_package.encryption.constant_initialization_vector

A constant initialization vector for encryption (optional). When not specified the initialization vector will be periodically rotated.

hls_package.encryption.encryption_method

The encryption method to use.

hls_package.encryption.speke_key_provider

A configuration for accessing an external Secure Packager and Encoder Key Exchange (SPEKE) service that will provide encryption keys.

Show child fields
hls_package.encryption.speke_key_provider.encryption_contract_configuration

Use encryptionContractConfiguration to configure one or more content encryption keys for your endpoints that use SPEKE 2.0. The encryption contract defines which content keys are used to encrypt the audio and video tracks in your stream. To configure the encryption contract, specify which audio and video encryption presets to use. Note the following considerations when using encryptionContractConfiguration: encryptionContractConfiguration can be used for DASH endpoints that use SPEKE 2.0. SPEKE 2.0 relies on the CPIX 2.3 specification. You must disable key rotation for this endpoint by setting keyRotationIntervalSeconds to 0.

Show child fields
hls_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_audio

A collection of audio encryption presets.

hls_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_video

A collection of video encryption presets.

hls_package.encryption.speke_key_provider.role_arn

An Amazon Resource Name (ARN) of an IAM role that AWS Elemental MediaPackage will assume when accessing the key provider service.

hls_package.encryption.speke_key_provider.system_ids[]
hls_package.encryption.speke_key_provider.url

The URL of the external key provider service.

hls_package.hls_manifests[]
Show child fields
hls_package.hls_manifests[].ad_markers

This setting controls how ad markers are included in the packaged OriginEndpoint. "NONE" will omit all SCTE-35 ad markers from the output. "PASSTHROUGH" causes the manifest to contain a copy of the SCTE-35 ad markers (comments) taken directly from the input HTTP Live Streaming (HLS) manifest. "SCTE35_ENHANCED" generates ad markers and blackout tags based on SCTE-35 messages in the input source.

hls_package.hls_manifests[].include_iframe_only_stream

When enabled, an I-Frame only stream will be included in the output.

hls_package.hls_manifests[].manifest_name

An optional string to include in the name of the manifest.

hls_package.hls_manifests[].program_date_time_interval_seconds

The interval (in seconds) between each EXT-X-PROGRAM-DATE-TIME tag inserted into manifests. Additionally, when an interval is specified ID3Timed Metadata messages will be generated every 5 seconds using the ingest time of the content. If the interval is not specified, or set to 0, then no EXT-X-PROGRAM-DATE-TIME tags will be inserted into manifests and no ID3Timed Metadata messages will be generated. Note that irrespective of this parameter, if any ID3 Timed Metadata is found in HTTP Live Streaming (HLS) input, it will be passed through to HLS output.

hls_package.hls_manifests[].repeat_ext_x_key

When enabled, the EXT-X-KEY tag will be repeated in output manifests.

hls_package.hls_manifests[].stream_selection

A StreamSelection configuration.

Show child fields
hls_package.hls_manifests[].stream_selection.max_video_bits_per_second

The maximum video bitrate (bps) to include in output.

hls_package.hls_manifests[].stream_selection.min_video_bits_per_second

The minimum video bitrate (bps) to include in output.

hls_package.hls_manifests[].stream_selection.stream_order

A directive that determines the order of streams in the output.

hls_package.include_dvb_subtitles

When enabled, MediaPackage passes through digital video broadcasting (DVB) subtitles into the output.

hls_package.segment_duration_seconds

Duration (in seconds) of each fragment. Actual fragments will be rounded to the nearest multiple of the source fragment duration.

hls_package.use_audio_rendition_group

When enabled, audio streams will be placed in rendition groups in the output.

id

The ID of the PackagingConfiguration.

VARCHAR
mss_package

A Microsoft Smooth Streaming (MSS) PackagingConfiguration.

STRUCT(
    "encryption" STRUCT(
        "speke_key_provider" STRUCT(
            "encryption_contract_configuration" STRUCT(
                "preset_speke20_audio" VARCHAR,
                "preset_speke20_video" VARCHAR
            ),
            "role_arn" VARCHAR,
            "system_ids" VARCHAR[],
            "url" VARCHAR
        )
    ),
    "mss_manifests" STRUCT(
        "manifest_name" VARCHAR,
        "stream_selection" STRUCT(
            "max_video_bits_per_second" BIGINT,
            "min_video_bits_per_second" BIGINT,
            "stream_order" VARCHAR
        )
    )[],
    "segment_duration_seconds" BIGINT
)
Show child fields
mss_package.encryption

A Microsoft Smooth Streaming (MSS) encryption configuration.

Show child fields
mss_package.encryption.speke_key_provider

A configuration for accessing an external Secure Packager and Encoder Key Exchange (SPEKE) service that will provide encryption keys.

Show child fields
mss_package.encryption.speke_key_provider.encryption_contract_configuration

Use encryptionContractConfiguration to configure one or more content encryption keys for your endpoints that use SPEKE 2.0. The encryption contract defines which content keys are used to encrypt the audio and video tracks in your stream. To configure the encryption contract, specify which audio and video encryption presets to use. Note the following considerations when using encryptionContractConfiguration: encryptionContractConfiguration can be used for DASH endpoints that use SPEKE 2.0. SPEKE 2.0 relies on the CPIX 2.3 specification. You must disable key rotation for this endpoint by setting keyRotationIntervalSeconds to 0.

Show child fields
mss_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_audio

A collection of audio encryption presets.

mss_package.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_video

A collection of video encryption presets.

mss_package.encryption.speke_key_provider.role_arn

An Amazon Resource Name (ARN) of an IAM role that AWS Elemental MediaPackage will assume when accessing the key provider service.

mss_package.encryption.speke_key_provider.system_ids[]
mss_package.encryption.speke_key_provider.url

The URL of the external key provider service.

mss_package.mss_manifests[]
Show child fields
mss_package.mss_manifests[].manifest_name

An optional string to include in the name of the manifest.

mss_package.mss_manifests[].stream_selection

A StreamSelection configuration.

Show child fields
mss_package.mss_manifests[].stream_selection.max_video_bits_per_second

The maximum video bitrate (bps) to include in output.

mss_package.mss_manifests[].stream_selection.min_video_bits_per_second

The minimum video bitrate (bps) to include in output.

mss_package.mss_manifests[].stream_selection.stream_order

A directive that determines the order of streams in the output.

mss_package.segment_duration_seconds

The duration (in seconds) of each segment.

tags

A collection of tags associated with a resource

MAP(VARCHAR, VARCHAR)