steampipe plugin install aws

Table: aws_ses_email_identity - Query AWS SES Email Identity using SQL

The AWS Simple Email Service (SES) Email Identity is a resource that represents the identity of an email sender. This identity can either be an email address or a domain from which the email is sent. It provides a way to verify email sending sources and to configure email sending settings, improving email deliverability.

Table Usage Guide

The aws_ses_email_identity table in Steampipe provides you with information about email identities that are verified with Amazon Simple Email Service (SES). This table allows you, as a DevOps engineer, to query specific details about these identities, such as the identity type (email or domain), verification status, feedback forwarding status, and more. You can utilize this table to gain insights on the verified email identities, their DKIM attributes, and the policies applied to them. The schema outlines various attributes of the email identity for you, including the identity name, verification status, bounce topic, complaint topic, delivery topic, and associated tags.

Examples

Basic info

Explore which AWS Simple Email Service (SES) email identities are active in a specific region to manage and optimize your email sending activities. This can help in identifying potential issues or inefficiencies in your email distribution.

select
identity,
arn,
region,
akas
from
aws_ses_email_identity;
select
identity,
arn,
region,
akas
from
aws_ses_email_identity;

List email identities which failed verification

Explore which email identities failed the verification process in the AWS Simple Email Service. This is useful for troubleshooting and identifying potential issues with email delivery.

select
identity,
region,
verification_status
from
aws_ses_email_identity
where
verification_status = 'Failed';
select
identity,
region,
verification_status
from
aws_ses_email_identity
where
verification_status = 'Failed';

Schema for aws_ses_email_identity

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.
arntextThe ARN of the AWS SES identity.
identitytextThe email identity.
notification_attributesjsonbRepresents the notification attributes of an identity.
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.
titletextTitle of the resource.
verification_statustextThe verification status of the identity.
verification_tokentext[DEPRECATED] This column has been deprecated and will be removed in a future release. The verification token for a domain identity.

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_ses_email_identity