Skip to content
AWS for Query.Farm

aws.mediapackagev2.get_origin_endpoint

Example SQL Queries

SELECT * FROM
aws.mediapackagev2.get_origin_endpoint
WHERE
"channel_group_name" = 'VALUE'
AND "channel_name" = 'VALUE'
AND "origin_endpoint_name" = 'VALUE';

Description

Retrieves the specified origin endpoint that's configured in AWS Elemental MediaPackage to obtain its playback URL and to view the packaging settings that it's currently using.

Table Definition

Column NameColumn Data Type
channel_group_name Required Input Column

The name that describes the channel group. The name is the primary identifier for the channel group, and must be unique for your account in the AWS Region.

VARCHAR
channel_name Required Input Column

The name that describes the channel. The name is the primary identifier for the channel, and must be unique for your account in the AWS Region and channel group.

VARCHAR
origin_endpoint_name Required Input Column

The name that describes the origin endpoint. The name is the primary identifier for the origin endpoint, and and must be unique for your account in the AWS Region and 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.

_aws_region Input Column

The AWS region to use.

VARCHAR
arn

The Amazon Resource Name (ARN) associated with the resource.

VARCHAR
container_type

The type of container attached to this origin endpoint.

VARCHAR
created_at

The date and time the origin endpoint was created.

TIMESTAMP_S
dash_manifests

A DASH manifest configuration.

STRUCT(
    "manifest_name" VARCHAR,
    "url" VARCHAR,
    "manifest_window_seconds" BIGINT,
    "filter_configuration" STRUCT(
        "manifest_filter" VARCHAR,
        "start" TIMESTAMP_S,
        "end" TIMESTAMP_S,
        "time_delay_seconds" BIGINT
    ),
    "min_update_period_seconds" BIGINT,
    "min_buffer_time_seconds" BIGINT,
    "suggested_presentation_delay_seconds" BIGINT,
    "segment_template_format" VARCHAR,
    "period_triggers" VARCHAR[],
    "scte_dash" STRUCT(
        "ad_marker_dash" VARCHAR
    ),
    "drm_signaling" VARCHAR,
    "utc_timing" STRUCT(
        "timing_mode" VARCHAR,
        "timing_source" VARCHAR
    )
)[]
Show child fields
dash_manifests[]
Show child fields
dash_manifests[].drm_signaling

Determines how the DASH manifest signals the DRM content.

dash_manifests[].filter_configuration

Filter configuration includes settings for manifest filtering, start and end times, and time delay that apply to all of your egress requests for this manifest.

Show child fields
dash_manifests[].filter_configuration.end

Optionally specify the end time for all of your manifest egress requests. When you include end time, note that you cannot use end time query parameters for this manifest's endpoint URL.

dash_manifests[].filter_configuration.manifest_filter

Optionally specify one or more manifest filters for all of your manifest egress requests. When you include a manifest filter, note that you cannot use an identical manifest filter query parameter for this manifest's endpoint URL.

dash_manifests[].filter_configuration.start

Optionally specify the start time for all of your manifest egress requests. When you include start time, note that you cannot use start time query parameters for this manifest's endpoint URL.

dash_manifests[].filter_configuration.time_delay_seconds

Optionally specify the time delay for all of your manifest egress requests. Enter a value that is smaller than your endpoint's startover window. When you include time delay, note that you cannot use time delay query parameters for this manifest's endpoint URL.

dash_manifests[].manifest_name

A short string that's appended to the endpoint URL. The manifest name creates a unique path to this endpoint. If you don't enter a value, MediaPackage uses the default manifest name, index.

dash_manifests[].manifest_window_seconds

The total duration (in seconds) of the manifest's content.

dash_manifests[].min_buffer_time_seconds

Minimum amount of content (in seconds) that a player must keep available in the buffer.

dash_manifests[].min_update_period_seconds

Minimum amount of time (in seconds) that the player should wait before requesting updates to the manifest.

dash_manifests[].period_triggers[]
dash_manifests[].scte_dash

The SCTE configuration.

Show child fields
dash_manifests[].scte_dash.ad_marker_dash

Choose how ad markers are included in the packaged content. If you include ad markers in the content stream in your upstream encoders, then you need to inform MediaPackage what to do with the ad markers in the output.

Value description:

  • Binary - The SCTE-35 marker is expressed as a hex-string (Base64 string) rather than full XML.

  • XML - The SCTE marker is expressed fully in XML.

dash_manifests[].segment_template_format

Determines the type of variable used in the media URL of the SegmentTemplate tag in the manifest. Also specifies if segment timeline information is included in SegmentTimeline or SegmentTemplate.

Value description:

  • NUMBER_WITH_TIMELINE - The $Number$ variable is used in the media URL. The value of this variable is the sequential number of the segment. A full SegmentTimeline object is presented in each SegmentTemplate.

dash_manifests[].suggested_presentation_delay_seconds

The amount of time (in seconds) that the player should be from the end of the manifest.

dash_manifests[].url

The egress domain URL for stream delivery from MediaPackage.

dash_manifests[].utc_timing

Determines the type of UTC timing included in the DASH Media Presentation Description (MPD).

Show child fields
dash_manifests[].utc_timing.timing_mode

The UTC timing mode.

dash_manifests[].utc_timing.timing_source

The the method that the player uses to synchronize to coordinated universal time (UTC) wall clock time.

description

The description for your origin endpoint.

VARCHAR
e_tag

The current Entity Tag (ETag) associated with this resource. The entity tag can be used to safely make concurrent updates to the resource.

VARCHAR
force_endpoint_error_configuration

The failover settings for the endpoint.

STRUCT(
    "endpoint_error_conditions" VARCHAR[]
)
Show child fields
force_endpoint_error_configuration.endpoint_error_conditions[]
hls_manifests

An HTTP live streaming (HLS) manifest configuration.

STRUCT(
    "manifest_name" VARCHAR,
    "url" VARCHAR,
    "child_manifest_name" VARCHAR,
    "manifest_window_seconds" BIGINT,
    "program_date_time_interval_seconds" BIGINT,
    "scte_hls" STRUCT(
        "ad_marker_hls" VARCHAR
    ),
    "filter_configuration" STRUCT(
        "manifest_filter" VARCHAR,
        "start" TIMESTAMP_S,
        "end" TIMESTAMP_S,
        "time_delay_seconds" BIGINT
    )
)[]
Show child fields
hls_manifests[]
Show child fields
hls_manifests[].child_manifest_name

A short string that's appended to the endpoint URL. The child manifest name creates a unique path to this endpoint. If you don't enter a value, MediaPackage uses the default child manifest name, index_1. The manifestName on the HLSManifest object overrides the manifestName you provided on the originEndpoint object.

hls_manifests[].filter_configuration

Filter configuration includes settings for manifest filtering, start and end times, and time delay that apply to all of your egress requests for this manifest.

Show child fields
hls_manifests[].filter_configuration.end

Optionally specify the end time for all of your manifest egress requests. When you include end time, note that you cannot use end time query parameters for this manifest's endpoint URL.

hls_manifests[].filter_configuration.manifest_filter

Optionally specify one or more manifest filters for all of your manifest egress requests. When you include a manifest filter, note that you cannot use an identical manifest filter query parameter for this manifest's endpoint URL.

hls_manifests[].filter_configuration.start

Optionally specify the start time for all of your manifest egress requests. When you include start time, note that you cannot use start time query parameters for this manifest's endpoint URL.

hls_manifests[].filter_configuration.time_delay_seconds

Optionally specify the time delay for all of your manifest egress requests. Enter a value that is smaller than your endpoint's startover window. When you include time delay, note that you cannot use time delay query parameters for this manifest's endpoint URL.

hls_manifests[].manifest_name

A short short string that's appended to the endpoint URL. The manifest name creates a unique path to this endpoint. If you don't enter a value, MediaPackage uses the default manifest name, index. MediaPackage automatically inserts the format extension, such as .m3u8. You can't use the same manifest name if you use HLS manifest and low-latency HLS manifest. The manifestName on the HLSManifest object overrides the manifestName you provided on the originEndpoint object.

hls_manifests[].manifest_window_seconds

The total duration (in seconds) of the manifest's content.

hls_manifests[].program_date_time_interval_seconds

Inserts EXT-X-PROGRAM-DATE-TIME tags in the output manifest at the interval that you specify. If you don't enter an interval, EXT-X-PROGRAM-DATE-TIME tags aren't included in the manifest. The tags sync the stream to the wall clock so that viewers can seek to a specific time in the playback timeline on the player. ID3Timed metadata messages generate every 5 seconds whenever the content is ingested.

Irrespective of this parameter, if any ID3Timed metadata is in the HLS input, it is passed through to the HLS output.

hls_manifests[].scte_hls

The SCTE configuration.

Show child fields
hls_manifests[].scte_hls.ad_marker_hls

Ad markers indicate when ads should be inserted during playback. If you include ad markers in the content stream in your upstream encoders, then you need to inform MediaPackage what to do with the ad markers in the output. Choose what you want MediaPackage to do with the ad markers.

Value description:

  • DATERANGE - Insert EXT-X-DATERANGE tags to signal ad and program transition events in TS and CMAF manifests. If you use DATERANGE, you must set a programDateTimeIntervalSeconds value of 1 or higher. To learn more about DATERANGE, see SCTE-35 Ad Marker EXT-X-DATERANGE.

hls_manifests[].url

The egress domain URL for stream delivery from MediaPackage.

low_latency_hls_manifests

A low-latency HLS manifest configuration.

STRUCT(
    "manifest_name" VARCHAR,
    "url" VARCHAR,
    "child_manifest_name" VARCHAR,
    "manifest_window_seconds" BIGINT,
    "program_date_time_interval_seconds" BIGINT,
    "scte_hls" STRUCT(
        "ad_marker_hls" VARCHAR
    ),
    "filter_configuration" STRUCT(
        "manifest_filter" VARCHAR,
        "start" TIMESTAMP_S,
        "end" TIMESTAMP_S,
        "time_delay_seconds" BIGINT
    )
)[]
Show child fields
low_latency_hls_manifests[]
Show child fields
low_latency_hls_manifests[].child_manifest_name

A short string that's appended to the endpoint URL. The child manifest name creates a unique path to this endpoint. If you don't enter a value, MediaPackage uses the default child manifest name, index_1. The manifestName on the HLSManifest object overrides the manifestName you provided on the originEndpoint object.

low_latency_hls_manifests[].filter_configuration

Filter configuration includes settings for manifest filtering, start and end times, and time delay that apply to all of your egress requests for this manifest.

Show child fields
low_latency_hls_manifests[].filter_configuration.end

Optionally specify the end time for all of your manifest egress requests. When you include end time, note that you cannot use end time query parameters for this manifest's endpoint URL.

low_latency_hls_manifests[].filter_configuration.manifest_filter

Optionally specify one or more manifest filters for all of your manifest egress requests. When you include a manifest filter, note that you cannot use an identical manifest filter query parameter for this manifest's endpoint URL.

low_latency_hls_manifests[].filter_configuration.start

Optionally specify the start time for all of your manifest egress requests. When you include start time, note that you cannot use start time query parameters for this manifest's endpoint URL.

low_latency_hls_manifests[].filter_configuration.time_delay_seconds

Optionally specify the time delay for all of your manifest egress requests. Enter a value that is smaller than your endpoint's startover window. When you include time delay, note that you cannot use time delay query parameters for this manifest's endpoint URL.

low_latency_hls_manifests[].manifest_name

A short short string that's appended to the endpoint URL. The manifest name creates a unique path to this endpoint. If you don't enter a value, MediaPackage uses the default manifest name, index. MediaPackage automatically inserts the format extension, such as .m3u8. You can't use the same manifest name if you use HLS manifest and low-latency HLS manifest. The manifestName on the HLSManifest object overrides the manifestName you provided on the originEndpoint object.

low_latency_hls_manifests[].manifest_window_seconds

The total duration (in seconds) of the manifest's content.

low_latency_hls_manifests[].program_date_time_interval_seconds

Inserts EXT-X-PROGRAM-DATE-TIME tags in the output manifest at the interval that you specify. If you don't enter an interval, EXT-X-PROGRAM-DATE-TIME tags aren't included in the manifest. The tags sync the stream to the wall clock so that viewers can seek to a specific time in the playback timeline on the player. ID3Timed metadata messages generate every 5 seconds whenever the content is ingested.

Irrespective of this parameter, if any ID3Timed metadata is in the HLS input, it is passed through to the HLS output.

low_latency_hls_manifests[].scte_hls

The SCTE configuration.

Show child fields
low_latency_hls_manifests[].scte_hls.ad_marker_hls

Ad markers indicate when ads should be inserted during playback. If you include ad markers in the content stream in your upstream encoders, then you need to inform MediaPackage what to do with the ad markers in the output. Choose what you want MediaPackage to do with the ad markers.

Value description:

  • DATERANGE - Insert EXT-X-DATERANGE tags to signal ad and program transition events in TS and CMAF manifests. If you use DATERANGE, you must set a programDateTimeIntervalSeconds value of 1 or higher. To learn more about DATERANGE, see SCTE-35 Ad Marker EXT-X-DATERANGE.

low_latency_hls_manifests[].url

The egress domain URL for stream delivery from MediaPackage.

modified_at

The date and time the origin endpoint was modified.

TIMESTAMP_S
segment

The segment configuration, including the segment name, duration, and other configuration values.

STRUCT(
    "segment_duration_seconds" BIGINT,
    "segment_name" VARCHAR,
    "ts_use_audio_rendition_group" BOOLEAN,
    "include_iframe_only_streams" BOOLEAN,
    "ts_include_dvb_subtitles" BOOLEAN,
    "scte" STRUCT(
        "scte_filter" VARCHAR[]
    ),
    "encryption" STRUCT(
        "constant_initialization_vector" VARCHAR,
        "encryption_method" STRUCT(
            "ts_encryption_method" VARCHAR,
            "cmaf_encryption_method" VARCHAR
        ),
        "key_rotation_interval_seconds" BIGINT,
        "speke_key_provider" STRUCT(
            "encryption_contract_configuration" STRUCT(
                "preset_speke20_audio" VARCHAR,
                "preset_speke20_video" VARCHAR
            ),
            "resource_id" VARCHAR,
            "drm_systems" VARCHAR[],
            "role_arn" VARCHAR,
            "url" VARCHAR
        )
    )
)
Show child fields
segment.encryption

The parameters for encrypting content.

Show child fields
segment.encryption.constant_initialization_vector

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

segment.encryption.encryption_method

The encryption method to use.

Show child fields
segment.encryption.encryption_method.cmaf_encryption_method

The encryption method to use.

segment.encryption.encryption_method.ts_encryption_method

The encryption method to use.

segment.encryption.key_rotation_interval_seconds

The frequency (in seconds) of key changes for live workflows, in which content is streamed real time. The service retrieves content keys before the live content begins streaming, and then retrieves them as needed over the lifetime of the workflow. By default, key rotation is set to 300 seconds (5 minutes), the minimum rotation interval, which is equivalent to setting it to 300. If you don't enter an interval, content keys aren't rotated.

The following example setting causes the service to rotate keys every thirty minutes: 1800

segment.encryption.speke_key_provider

The parameters for the SPEKE key provider.

Show child fields
segment.encryption.speke_key_provider.drm_systems[]
segment.encryption.speke_key_provider.encryption_contract_configuration

Configure one or more content encryption keys for your endpoints that use SPEKE Version 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.

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

A collection of audio encryption presets.

Value description:

  • PRESET-AUDIO-1 - Use one content key to encrypt all of the audio tracks in your stream.

  • PRESET-AUDIO-2 - Use one content key to encrypt all of the stereo audio tracks and one content key to encrypt all of the multichannel audio tracks.

  • PRESET-AUDIO-3 - Use one content key to encrypt all of the stereo audio tracks, one content key to encrypt all of the multichannel audio tracks with 3 to 6 channels, and one content key to encrypt all of the multichannel audio tracks with more than 6 channels.

  • SHARED - Use the same content key for all of the audio and video tracks in your stream.

  • UNENCRYPTED - Don't encrypt any of the audio tracks in your stream.

segment.encryption.speke_key_provider.encryption_contract_configuration.preset_speke20_video

A collection of video encryption presets.

Value description:

  • PRESET-VIDEO-1 - Use one content key to encrypt all of the video tracks in your stream.

  • PRESET-VIDEO-2 - Use one content key to encrypt all of the SD video tracks and one content key for all HD and higher resolutions video tracks.

  • PRESET-VIDEO-3 - Use one content key to encrypt all of the SD video tracks, one content key for HD video tracks and one content key for all UHD video tracks.

  • PRESET-VIDEO-4 - Use one content key to encrypt all of the SD video tracks, one content key for HD video tracks, one content key for all UHD1 video tracks and one content key for all UHD2 video tracks.

  • PRESET-VIDEO-5 - Use one content key to encrypt all of the SD video tracks, one content key for HD1 video tracks, one content key for HD2 video tracks, one content key for all UHD1 video tracks and one content key for all UHD2 video tracks.

  • PRESET-VIDEO-6 - Use one content key to encrypt all of the SD video tracks, one content key for HD1 video tracks, one content key for HD2 video tracks and one content key for all UHD video tracks.

  • PRESET-VIDEO-7 - Use one content key to encrypt all of the SD+HD1 video tracks, one content key for HD2 video tracks and one content key for all UHD video tracks.

  • PRESET-VIDEO-8 - Use one content key to encrypt all of the SD+HD1 video tracks, one content key for HD2 video tracks, one content key for all UHD1 video tracks and one content key for all UHD2 video tracks.

  • SHARED - Use the same content key for all of the video and audio tracks in your stream.

  • UNENCRYPTED - Don't encrypt any of the video tracks in your stream.

segment.encryption.speke_key_provider.resource_id

The unique identifier for the content. The service sends this to the key server to identify the current endpoint. How unique you make this depends on how fine-grained you want access controls to be. The service does not permit you to use the same ID for two simultaneous encryption processes. The resource ID is also known as the content ID.

The following example shows a resource ID: MovieNight20171126093045

segment.encryption.speke_key_provider.role_arn

The ARN for the IAM role granted by the key provider that provides access to the key provider API. This role must have a trust policy that allows MediaPackage to assume the role, and it must have a sufficient permissions policy to allow access to the specific key retrieval URL. Get this from your DRM solution provider.

Valid format: arn:aws:iam::{accountID}:role/{name}. The following example shows a role ARN: arn:aws:iam::444455556666:role/SpekeAccess

segment.encryption.speke_key_provider.url

The URL of the API Gateway proxy that you set up to talk to your key server. The API Gateway proxy must reside in the same AWS Region as MediaPackage and must start with https://.

The following example shows a URL: https://1wm2dx1f33.execute-api.us-west-2.amazonaws.com/SpekeSample/copyProtection

segment.include_iframe_only_streams

When selected, the stream set includes an additional I-frame only stream, along with the other tracks. If false, this extra stream is not included. MediaPackage generates an I-frame only stream from the first rendition in the manifest. The service inserts EXT-I-FRAMES-ONLY tags in the output manifest, and then generates and includes an I-frames only playlist in the stream. This playlist permits player functionality like fast forward and rewind.

segment.scte

The SCTE configuration options in the segment settings.

Show child fields
segment.scte.scte_filter[]
segment.segment_duration_seconds

The duration (in seconds) of each segment. Enter a value equal to, or a multiple of, the input segment duration. If the value that you enter is different from the input segment duration, MediaPackage rounds segments to the nearest multiple of the input segment duration.

segment.segment_name

The name that describes the segment. The name is the base name of the segment used in all content manifests inside of the endpoint. You can't use spaces in the name.

segment.ts_include_dvb_subtitles

By default, MediaPackage excludes all digital video broadcasting (DVB) subtitles from the output. When selected, MediaPackage passes through DVB subtitles into the output.

segment.ts_use_audio_rendition_group

When selected, MediaPackage bundles all audio tracks in a rendition group. All other tracks in the stream can be used with any audio rendition from the group.

startover_window_seconds

The size of the window (in seconds) to create a window of the live stream that's available for on-demand viewing. Viewers can start-over or catch-up on content that falls within the window.

BIGINT
tags

The comma-separated list of tag key:value pairs assigned to the origin endpoint.

MAP(VARCHAR, VARCHAR)