Skip to content
AWS for Query.Farm

aws.ses.get_send_statistics

Example SQL Queries

SELECT * FROM
aws.ses.get_send_statistics;

Description

Provides sending statistics for the current Amazon Web Services Region. The result is a list of data points, representing the last two weeks of sending activity. Each data point in the list contains statistics for a 15-minute period of time.

You can execute this operation no more than once per second.

Table Definition

Column NameColumn Data Type
send_data_points

A list of data points, each of which represents 15 minutes of activity.

STRUCT(
    "timestamp" TIMESTAMP_S,
    "delivery_attempts" BIGINT,
    "bounces" BIGINT,
    "complaints" BIGINT,
    "rejects" BIGINT
)[]
Show child fields
send_data_points[]
Show child fields
send_data_points[].bounces

Number of emails that have bounced.

send_data_points[].complaints

Number of unwanted emails that were rejected by recipients.

send_data_points[].delivery_attempts

Number of emails that have been sent.

send_data_points[].rejects

Number of emails rejected by Amazon SES.

send_data_points[].timestamp

Time of the data point.