steampipe plugin install aws

Table: aws_account_contact - Query AWS Account Contact using SQL

The AWS Account Contact is a resource that stores contact information associated with an AWS account. This information can include the account holder's name, email address, and phone number. It is essential for communication purposes, especially for receiving important notifications and alerts related to the AWS services and resources.

Table Usage Guide

The aws_account_contact table in Steampipe provides you with information about contact details associated with an AWS account. This table allows you, as a DevOps engineer, to query contact-specific details, including email, mobile, and address information. You can utilize this table to gather insights on AWS account contact details, such as verification of contact information, understanding the geographical distribution of accounts, and more. The schema outlines the various attributes of the AWS account contact for you, including the account ID, address, email, fax, and phone number.

Important Notes This table supports the optional list key column linked_account_id, with the following requirements:

  • The caller must be an identity in the organization's management account or a delegated administrator account.
  • The specified account ID must also be a member account in the same organization.
  • The organization must have all features enabled.
  • The organization must have trusted access enabled for the Account Management service.
  • If using AWS' ReadOnlyAccess policy, this policy does not include the account:GetContactInformation permission, so you will need to add it to use this table.

Examples

Basic info

This query allows you to explore the basic contact information linked to your AWS account. The practical application of this query is to quickly identify and review your account details, ensuring they're accurate and up-to-date.

select
full_name,
company_name,
city,
phone_number,
postal_code,
state_or_region,
website_url
from
aws_account_contact;
select
full_name,
company_name,
city,
phone_number,
postal_code,
state_or_region,
website_url
from
aws_account_contact;

Get contact details for an account in the organization (using credentials from the management account)

Gain insights into the contact information associated with a specific account in your organization. This can be particularly useful for administrators who need to communicate with account holders or verify account details.

select
full_name,
company_name,
city,
phone_number,
postal_code,
state_or_region,
website_url
from
aws_account_contact
where
linked_account_id = '123456789012';
select
full_name,
company_name,
city,
phone_number,
postal_code,
state_or_region,
website_url
from
aws_account_contact
where
linked_account_id = '123456789012';

Schema for aws_account_contact

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
address_line_1textThe first line of the primary contact address
address_line_2textThe second line of the primary contact address, if any.
address_line_3textThe third line of the primary contact address, if any.
citytextThe city of the primary contact address.
company_nametextThe name of the company associated with the primary contact information, if any.
country_codetextThe ISO-3166 two-letter country code for the primary contact address.
district_or_countytextThe district or county of the primary contact address, if any.
full_nametextThe full name of the primary contact address.
linked_account_idtext=Account ID to get contact details for.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
phone_numbertextThe phone number of the primary contact information. The number will be validated and, in some countries, checked for activation.
postal_codetextThe postal code of the primary contact address.
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
state_or_regiontextThe state or region of the primary contact address. This field is required in selected countries.
titletextTitle of the resource.
website_urltextThe URL of the website associated with the primary contact information, if any.

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_account_contact