Skip to content
AWS for Query.Farm

aws.mediatailor.list_source_locations

Example SQL Queries

SELECT * FROM
aws.mediatailor.list_source_locations;

Description

Lists the source locations for a channel. A source location defines the host server URL, and contains a list of sources.

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.

access_configuration

The access configuration for the source location.

STRUCT(
    "access_type" VARCHAR,
    "secrets_manager_access_token_configuration" STRUCT(
        "header_name" VARCHAR,
        "secret_arn" VARCHAR,
        "secret_string_key" VARCHAR
    )
)
Show child fields
access_configuration.access_type

The type of authentication used to access content from HttpConfiguration::BaseUrl on your source location.

S3_SIGV4 - AWS Signature Version 4 authentication for Amazon S3 hosted virtual-style access. If your source location base URL is an Amazon S3 bucket, MediaTailor can use AWS Signature Version 4 (SigV4) authentication to access the bucket where your source content is stored. Your MediaTailor source location baseURL must follow the S3 virtual hosted-style request URL format. For example, https://bucket-name.s3.Region.amazonaws.com/key-name.

Before you can use S3_SIGV4, you must meet these requirements:

• You must allow MediaTailor to access your S3 bucket by granting mediatailor.amazonaws.com principal access in IAM. For information about configuring access in IAM, see Access management in the IAM User Guide.

• The mediatailor.amazonaws.com service principal must have permissions to read all top level manifests referenced by the VodSource packaging configurations.

• The caller of the API must have s3:GetObject IAM permissions to read all top level manifests referenced by your MediaTailor VodSource packaging configurations.

AUTODETECT_SIGV4 - AWS Signature Version 4 authentication for a set of supported services: MediaPackage Version 2 and Amazon S3 hosted virtual-style access. If your source location base URL is a MediaPackage Version 2 endpoint or an Amazon S3 bucket, MediaTailor can use AWS Signature Version 4 (SigV4) authentication to access the resource where your source content is stored.

Before you can use AUTODETECT_SIGV4 with a MediaPackage Version 2 endpoint, you must meet these requirements:

• You must grant MediaTailor access to your MediaPackage endpoint by granting mediatailor.amazonaws.com principal access in an Origin Access policy on the endpoint.

• Your MediaTailor source location base URL must be a MediaPackage V2 endpoint.

• The caller of the API must have mediapackagev2:GetObject IAM permissions to read all top level manifests referenced by the MediaTailor source packaging configurations.

Before you can use AUTODETECT_SIGV4 with an Amazon S3 bucket, you must meet these requirements:

• You must grant MediaTailor access to your S3 bucket by granting mediatailor.amazonaws.com principal access in IAM. For more information about configuring access in IAM, see Access management in the IAM User Guide..

• The mediatailor.amazonaws.com service principal must have permissions to read all top-level manifests referenced by the VodSource packaging configurations.

• The caller of the API must have s3:GetObject IAM permissions to read all top level manifests referenced by your MediaTailor VodSource packaging configurations.

access_configuration.secrets_manager_access_token_configuration

AWS Secrets Manager access token configuration parameters.

Show child fields
access_configuration.secrets_manager_access_token_configuration.header_name

The name of the HTTP header used to supply the access token in requests to the source location.

access_configuration.secrets_manager_access_token_configuration.secret_arn

The Amazon Resource Name (ARN) of the AWS Secrets Manager secret that contains the access token.

access_configuration.secrets_manager_access_token_configuration.secret_string_key

The AWS Secrets Manager SecretString key associated with the access token. MediaTailor uses the key to look up SecretString key and value pair containing the access token.

arn

The ARN of the SourceLocation.

VARCHAR
creation_time

The timestamp that indicates when the source location was created.

TIMESTAMP_S
default_segment_delivery_configuration

The default segment delivery configuration.

STRUCT(
    "base_url" VARCHAR
)
Show child fields
default_segment_delivery_configuration.base_url

The hostname of the server that will be used to serve segments. This string must include the protocol, such as https://.

http_configuration

The HTTP configuration for the source location.

STRUCT(
    "base_url" VARCHAR
)
Show child fields
http_configuration.base_url

The base URL for the source location host server. This string must include the protocol, such as https://.

last_modified_time

The timestamp that indicates when the source location was last modified.

TIMESTAMP_S
segment_delivery_configurations

The segment delivery configurations for the source location.

STRUCT(
    "base_url" VARCHAR,
    "name" VARCHAR
)[]
Show child fields
segment_delivery_configurations[]
Show child fields
segment_delivery_configurations[].base_url

The base URL of the host or path of the segment delivery server that you're using to serve segments. This is typically a content delivery network (CDN). The URL can be absolute or relative. To use an absolute URL include the protocol, such as https://example.com/some/path. To use a relative URL specify the relative path, such as /some/path*.

segment_delivery_configurations[].name

A unique identifier used to distinguish between multiple segment delivery configurations in a source location.

source_location_name

The name of the source location.

VARCHAR
tags

The tags assigned to the source location. 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)