Skip to content

aws.sesv2.get_account

Example SQL Queries

SELECT * FROM
aws.sesv2.get_account;

Description

Obtain information about the email-sending status and capabilities of your Amazon SES account in the current Amazon Web Services Region.

Table Definition

Column NameColumn Data Type
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

dedicated_ip_auto_warmup_enabled

Indicates whether or not the automatic warm-up feature is enabled for dedicated IP addresses that are associated with your account.

BOOLEAN
details

An object that defines your account details.

STRUCT(
"mail_type" VARCHAR,
"website_url" VARCHAR,
"contact_language" VARCHAR,
"use_case_description" VARCHAR,
"additional_contact_email_addresses" VARCHAR[],
"review_details" STRUCT(
"status" VARCHAR,
"case_id" VARCHAR
)
)
Show child fields
details.additional_contact_email_addresses[]
details.contact_language

The language you would prefer for the case. The contact language can be one of ENGLISH or JAPANESE.

details.mail_type

The type of email your account is sending. The mail type can be one of the following:

  • MARKETING – Most of your sending traffic is to keep your customers informed of your latest offering.

  • TRANSACTIONAL – Most of your sending traffic is to communicate during a transaction with a customer.

details.review_details

Information about the review of the latest details you submitted.

Show child fields
details.review_details.case_id

The associated support center case ID (if any).

details.review_details.status

The status of the latest review of your account. The status can be one of the following:

  • PENDING – We have received your appeal and are in the process of reviewing it.

  • GRANTED – Your appeal has been reviewed and your production access has been granted.

  • DENIED – Your appeal has been reviewed and your production access has been denied.

  • FAILED – An internal error occurred and we didn't receive your appeal. You can submit your appeal again.

details.use_case_description

A description of the types of email that you plan to send.

details.website_url

The URL of your website. This information helps us better understand the type of content that you plan to send.

enforcement_status

The reputation status of your Amazon SES account. The status can be one of the following:

  • HEALTHY – There are no reputation-related issues that currently impact your account.

  • PROBATION – We've identified potential issues with your Amazon SES account. We're placing your account under review while you work on correcting these issues.

  • SHUTDOWN – Your account's ability to send email is currently paused because of an issue with the email sent from your account. When you correct the issue, you can contact us and request that your account's ability to send email is resumed.

VARCHAR
production_access_enabled

Indicates whether or not your account has production access in the current Amazon Web Services Region.

If the value is false, then your account is in the sandbox. When your account is in the sandbox, you can only send email to verified identities.

If the value is true, then your account has production access. When your account has production access, you can send email to any address. The sending quota and maximum sending rate for your account vary based on your specific use case.

BOOLEAN
send_quota

An object that contains information about the per-day and per-second sending limits for your Amazon SES account in the current Amazon Web Services Region.

STRUCT(
"max24_hour_send" DOUBLE,
"max_send_rate" DOUBLE,
"sent_last24_hours" DOUBLE
)
Show child fields
send_quota.max24_hour_send

The maximum number of emails that you can send in the current Amazon Web Services Region over a 24-hour period. A value of -1 signifies an unlimited quota. (This value is also referred to as your sending quota.)

send_quota.max_send_rate

The maximum number of emails that you can send per second in the current Amazon Web Services Region. This value is also called your maximum sending rate or your maximum TPS (transactions per second) rate.

send_quota.sent_last24_hours

The number of emails sent from your Amazon SES account in the current Amazon Web Services Region over the past 24 hours.

sending_enabled

Indicates whether or not email sending is enabled for your Amazon SES account in the current Amazon Web Services Region.

BOOLEAN
suppression_attributes

An object that contains information about the email address suppression preferences for your account in the current Amazon Web Services Region.

STRUCT(
"suppressed_reasons" VARCHAR[]
)
Show child fields
suppression_attributes.suppressed_reasons[]
vdm_attributes

The VDM attributes that apply to your Amazon SES account.

STRUCT(
"vdm_enabled" VARCHAR,
"dashboard_attributes" STRUCT(
"engagement_metrics" VARCHAR
),
"guardian_attributes" STRUCT(
"optimized_shared_delivery" VARCHAR
)
)
Show child fields
vdm_attributes.dashboard_attributes

Specifies additional settings for your VDM configuration as applicable to the Dashboard.

Show child fields
vdm_attributes.dashboard_attributes.engagement_metrics

Specifies the status of your VDM engagement metrics collection. Can be one of the following:

  • ENABLED – Amazon SES enables engagement metrics for your account.

  • DISABLED – Amazon SES disables engagement metrics for your account.

vdm_attributes.guardian_attributes

Specifies additional settings for your VDM configuration as applicable to the Guardian.

Show child fields
vdm_attributes.guardian_attributes.optimized_shared_delivery

Specifies the status of your VDM optimized shared delivery. Can be one of the following:

  • ENABLED – Amazon SES enables optimized shared delivery for your account.

  • DISABLED – Amazon SES disables optimized shared delivery for your account.

vdm_attributes.vdm_enabled

Specifies the status of your VDM configuration. Can be one of the following:

  • ENABLED – Amazon SES enables VDM for your account.

  • DISABLED – Amazon SES disables VDM for your account.