steampipe plugin install aws

Table: aws_media_store_container - Query AWS MediaStore Container using SQL

The AWS MediaStore Container is a high-performance storage service for media data. It offers the performance, consistency, and low latency required to deliver live streaming video content. MediaStore Container is designed to enable you to deliver video content to consumers more quickly and reliably.

Table Usage Guide

The aws_media_store_container table in Steampipe provides you with information about containers within AWS Elemental MediaStore. This table allows you, as a DevOps engineer, to query container-specific details, such as ARN, creation time, status, and access logging details. You can utilize this table to gather insights on containers, such as the container's lifecycle policy, CORS policy, and more. The schema outlines the various attributes of the MediaStore container for you, including the container ARN, creation time, status, access logging details, and associated tags.

Examples

Basic info

Explore the status and settings of your AWS Media Store containers to assess their accessibility and operational status. This is beneficial in understanding the overall health and configuration of your media storage infrastructure.

select
name,
arn,
status,
access_logging_enabled,
creation_time,
endpoint
from
aws_media_store_container;
select
name,
arn,
status,
access_logging_enabled,
creation_time,
endpoint
from
aws_media_store_container;

List containers which are in 'CREATING' state

Identify instances where AWS Media Store containers are still in the process of being created. This can be useful in managing resources and troubleshooting potential issues with container creation.

select
name,
arn,
status,
access_logging_enabled,
creation_time,
endpoint
from
aws_media_store_container
where
status = 'CREATING';
select
name,
arn,
status,
access_logging_enabled,
creation_time,
endpoint
from
aws_media_store_container
where
status = 'CREATING';

List policy details for the containers

Gain insights into the policy details associated with your containers to better understand their configuration and ensure adherence to your organization's security standards. This can be particularly useful for auditing purposes or to identify any potential areas of risk.

select
name,
jsonb_pretty(policy) as policy,
jsonb_pretty(policy_std) as policy_std
from
aws_media_store_container;
select
name,
policy,
policy_std
from
aws_media_store_container;

List containers with access logging enabled

Identify instances where access logging is enabled for AWS Media Store containers. This could be beneficial for auditing purposes or to ensure compliance with data access policies.

select
name,
arn,
access_logging_enabled
from
aws_media_store_container
where
access_logging_enabled;
select
name,
arn,
access_logging_enabled
from
aws_media_store_container
where
access_logging_enabled = 1;

Schema for aws_media_store_container

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
access_logging_enabledbooleanThe state of access logging on the container. This value is false by default, indicating that AWS Elemental MediaStore does not send access logs to Amazon CloudWatch Logs. When you enable access logging on the container, MediaStore changes this value to true, indicating that the service delivers access logs for objects stored in that container to CloudWatch Logs.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) of the container.
creation_timetimestamp with time zoneThe Unix timestamp that the container was created.
endpointtextThe DNS endpoint of the container.
nametext=The name of the container.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
policyjsonbThe contents of the access policy.
policy_stdjsonbContains the contents of the access policy in a canonical form for easier searching.
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe status of container creation or deletion. The status is one of the following: 'CREATING', 'ACTIVE', or 'DELETING'.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags associated with the container
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_media_store_container