Table: aws_account_alternate_contacts

This table shows data for Account Alternate Contacts.

https://docs.aws.amazon.com/accounts/latest/reference/API_AlternateContact.html (opens in a new tab)

The composite primary key for this table is (account_id, alternate_contact_type).

Columns

Name	Type
_cq_id	`uuid`
_cq_parent_id	`uuid`
account_id (PK)	`utf8`
alternate_contact_type (PK)	`utf8`
email_address	`utf8`
name	`utf8`
phone_number	`utf8`
title	`utf8`

Example Queries

These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.

Security contact information should be provided for an AWS account

SELECT
  'Security contact information should be provided for an AWS account' AS title,
  aws_iam_accounts.account_id,
  CASE WHEN alternate_contact_type IS NULL THEN 'fail' ELSE 'pass' END AS status
FROM
  aws_iam_accounts
  LEFT JOIN (
      SELECT
        *
      FROM
        aws_account_alternate_contacts
      WHERE
        alternate_contact_type = 'SECURITY'
    )
      AS account_security_contacts ON
      aws_iam_accounts.account_id = account_security_contacts.account_id;