steampipe plugin install aws

Table: aws_oam_sink - Query AWS OAM Sink using SQL

The AWS OAM (Operational Application Management) Sink is a component of the AWS Distro for OpenTelemetry (ADOT) that collects, processes, and exports telemetry data. It enables you to understand the performance of your applications and services, troubleshoot operational issues, and gain insights into customer behavior. As a managed service, OAM Sink simplifies the process of gathering and analyzing high-volume, high-velocity data generated by your AWS resources and applications.

Table Usage Guide

The aws_oam_sink table in Steampipe provides you with information about each OAM Sink within AWS Operational Application Manager (OAM). This table allows you as a DevOps engineer to query Sink-specific details, including the Sink ARN, creation date, Sink status, and associated metadata. You can utilize this table to gather insights on Sinks, such as Sinks with specific statuses, verification of Sink properties, and more. The schema outlines the various attributes of the OAM Sink for you, including the Sink ARN, creation date, status, and associated tags.

Examples

Basic info

Determine the areas in which specific resources in your AWS environment are tagged or titled, allowing for efficient organization and management of resources.

select
name,
id,
arn,
tags,
title
from
aws_oam_sink;
select
name,
id,
arn,
tags,
title
from
aws_oam_sink;

Get sink by ID

Determine the specific details of a unique resource within your AWS environment. This is particularly useful when you need to quickly access information about a single resource based on its unique identifier.

select
name,
id,
arn
from
aws_oam_sink
where
id = 'hfj44c81-7bdf-3847-r7i3-5dfc61b17483';
select
name,
id,
arn
from
aws_oam_sink
where
id = 'hfj44c81-7bdf-3847-r7i3-5dfc61b17483';

Schema for aws_oam_sink

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntext=The ARN of the sink.
idtextThe random ID string that Amazon Web Service generates as part of the sink ARN.
nametextThe name of the sink.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
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_oam_sink