Skip to content
AWS for Query.Farm

aws.medialive.list_inputs

Example SQL Queries

SELECT * FROM
aws.medialive.list_inputs;

Description

Produces list of inputs that have been created

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.

_aws_region Input Column

The AWS region to use.

VARCHAR
arn

The Unique ARN of the input (generated, immutable).

VARCHAR
attached_channels

A list of channel IDs that that input is attached to (currently an input can only be attached to one channel).

VARCHAR[]
Show child fields
attached_channels[]
destinations

A list of the destinations of the input (PUSH-type).

STRUCT(
    "ip" VARCHAR,
    "port" VARCHAR,
    "url" VARCHAR,
    "vpc" STRUCT(
        "availability_zone" VARCHAR,
        "network_interface_id" VARCHAR
    )
)[]
Show child fields
destinations[]
Show child fields
destinations[].ip

The system-generated static IP address of endpoint. It remains fixed for the lifetime of the input.

destinations[].port

The port number for the input.

destinations[].url

This represents the endpoint that the customer stream will be pushed to.

destinations[].vpc

The properties for a VPC type input destination.

Show child fields
destinations[].vpc.availability_zone

The availability zone of the Input destination.

destinations[].vpc.network_interface_id

The network interface ID of the Input destination in the VPC.

id

The generated ID of the input (unique for user account, immutable).

VARCHAR
input_class

STANDARD - MediaLive expects two sources to be connected to this input. If the channel is also STANDARD, both sources will be ingested. If the channel is SINGLE_PIPELINE, only the first source will be ingested; the second source will always be ignored, even if the first source fails. SINGLE_PIPELINE - You can connect only one source to this input. If the ChannelClass is also SINGLE_PIPELINE, this value is valid. If the ChannelClass is STANDARD, this value is not valid because the channel requires two sources in the input.

VARCHAR
input_devices

Settings for the input devices.

STRUCT(
    "id" VARCHAR
)[]
Show child fields
input_devices[]
Show child fields
input_devices[].id

The unique ID for the device.

input_partner_ids

A list of IDs for all Inputs which are partners of this one.

VARCHAR[]
Show child fields
input_partner_ids[]
input_source_type

Certain pull input sources can be dynamic, meaning that they can have their URL's dynamically changes during input switch actions. Presently, this functionality only works with MP4_FILE and TS_FILE inputs.

VARCHAR
media_connect_flows

A list of MediaConnect Flows for this input.

STRUCT(
    "flow_arn" VARCHAR
)[]
Show child fields
media_connect_flows[]
Show child fields
media_connect_flows[].flow_arn

The unique ARN of the MediaConnect Flow being used as a source.

name

The user-assigned name (This is a mutable value).

VARCHAR
role_arn

The Amazon Resource Name (ARN) of the role this input assumes during and after creation.

VARCHAR
security_groups

A list of IDs for all the Input Security Groups attached to the input.

VARCHAR[]
Show child fields
security_groups[]
sources

A list of the sources of the input (PULL-type).

STRUCT(
    "password_param" VARCHAR,
    "url" VARCHAR,
    "username" VARCHAR
)[]
Show child fields
sources[]
Show child fields
sources[].password_param

The key used to extract the password from EC2 Parameter store.

sources[].url

This represents the customer's source URL where stream is pulled from.

sources[].username

The username for the input source.

srt_settings

The settings associated with an SRT input.

STRUCT(
    "srt_caller_sources" STRUCT(
        "decryption" STRUCT(
            "algorithm" VARCHAR,
            "passphrase_secret_arn" VARCHAR
        ),
        "minimum_latency" BIGINT,
        "srt_listener_address" VARCHAR,
        "srt_listener_port" VARCHAR,
        "stream_id" VARCHAR
    )[]
)
Show child fields
srt_settings.srt_caller_sources[]
Show child fields
srt_settings.srt_caller_sources[].decryption

The decryption settings for the SRT caller source. Present only if the source has decryption enabled.

Show child fields
srt_settings.srt_caller_sources[].decryption.algorithm

The algorithm used to encrypt content.

srt_settings.srt_caller_sources[].decryption.passphrase_secret_arn

The ARN for the secret in Secrets Manager. Someone in your organization must create a secret and provide you with its ARN. The secret holds the passphrase that MediaLive uses to decrypt the source content.

srt_settings.srt_caller_sources[].minimum_latency

The preferred latency (in milliseconds) for implementing packet loss and recovery. Packet recovery is a key feature of SRT.

srt_settings.srt_caller_sources[].srt_listener_address

The IP address at the upstream system (the listener) that MediaLive (the caller) connects to.

srt_settings.srt_caller_sources[].srt_listener_port

The port at the upstream system (the listener) that MediaLive (the caller) connects to.

srt_settings.srt_caller_sources[].stream_id

The stream ID, if the upstream system uses this identifier.

state

Placeholder documentation for InputState

VARCHAR
tags

A collection of key-value pairs.

MAP(VARCHAR, VARCHAR)
type

The different types of inputs that AWS Elemental MediaLive supports.

VARCHAR