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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
arn	text	=	The ARN of the sink.
id	text		The random ID string that Amazon Web Service generates as part of the sink ARN.
name	text		The name of the sink.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
title	text		Title 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