Table: aws_ses_domain_identity - Query Amazon Simple Email Service Domain Identities using SQL

The Amazon Simple Email Service (SES) Domain Identity is an entity that you use to send email. It represents the domain that you use for sending email, and is verified by Amazon SES. Once verified, you can send email from any address on the specified domain.

Table Usage Guide

The aws_ses_domain_identity table in Steampipe provides you with information about domain identities within Amazon Simple Email Service (SES). This table allows you, as a DevOps engineer, to query domain-specific details, including verification status, DKIM attributes, and associated metadata. You can utilize this table to gather insights on domain identities, such as verification status, DKIM tokens, and more. The schema outlines the various attributes of the SES domain identity for you, including the identity name, verification status, DKIM enabled status, and DKIM tokens.

Examples

Basic info

Determine the areas in which your AWS Simple Email Service (SES) domain identities are located. This allows you to gain insights into the regional distribution of your SES domain identities, which can be useful for optimizing email delivery and managing regional compliance requirements.

select
  identity,
  arn,
  region,
  akas
from
  aws_ses_domain_identity;

select
  identity,
  arn,
  region,
  akas
from
  aws_ses_domain_identity;

List domain identities which failed verification

Discover the segments that have failed the verification process within your domain identities. This query is useful for identifying potential issues with your SES domain identities across different regions.

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

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

Schema for aws_ses_domain_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.
dkim_attributes	jsonb		The DKIM attributes for an email address or a domain.
identity	text		The domain identity.
identity_mail_from_domain_attributes	jsonb		The custom MAIL FROM attributes for a list of identities.
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.
verification_token	text		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_domain_identity