Skip to content
AWS for Query.Farm

aws.pinpoint_email.get_account

Example SQL Queries

SELECT * FROM
aws.pinpoint_email.get_account;

Description

Obtain information about the email-sending status and capabilities of your Amazon Pinpoint account in the current AWS 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
enforcement_status

The reputation status of your Amazon Pinpoint 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 some issues with your Amazon Pinpoint 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 AWS 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. Additionally, the maximum number of emails you can send in a 24-hour period (your sending quota) is 200, and the maximum number of emails you can send per second (your maximum sending rate) is 1.

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 Pinpoint account in the current AWS 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 AWS Region over a 24-hour period. This value is also called your sending quota.

send_quota.max_send_rate

The maximum number of emails that you can send per second in the current AWS 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 Pinpoint account in the current AWS Region over the past 24 hours.

sending_enabled

Indicates whether or not email sending is enabled for your Amazon Pinpoint account in the current AWS Region.

BOOLEAN