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

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 AWS SES identity.
identity	text		The email identity.
notification_attributes	jsonb		Represents the notification attributes of an identity.
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.
title	text		Title of the resource.
verification_status	text		The verification status of the 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