Table: twilio_account_address - Query Twilio Account Addresses using SQL

Twilio Account Addresses are resources within Twilio that contain the physical address details associated with a Twilio account. These addresses are often used for regulatory compliance and emergency services purposes. They can be customer addresses, or the addresses of the business that owns the Twilio account.

Table Usage Guide

The twilio_account_address table provides insights into the physical addresses associated with a Twilio account. As a DevOps engineer, you can explore address-specific details through this table, including the customer's address or the business's address associated with the Twilio account. Utilize it to uncover information about addresses for regulatory compliance and emergency services purposes.

Important Notes

You must authenticate using either an Auth Token or a Main API Key to query this table.

Examples

Basic info

Explore which Twilio account addresses have been validated. This can help identify instances where incorrect or incomplete information has been provided, allowing for necessary corrections and updates to ensure accurate communication.

select
  sid,
  friendly_name,
  customer_name,
  validated,
  street,
  city,
  region,
  postal_code,
  account_sid
from
  twilio_account_address;

select
  sid,
  friendly_name,
  customer_name,
  validated,
  street,
  city,
  region,
  postal_code,
  account_sid
from
  twilio_account_address;

List unverified addresses

Discover the segments that contain unverified addresses within customer accounts. This is particularly useful for identifying potential inaccuracies or inconsistencies in your customer data.

select
  sid,
  friendly_name,
  customer_name,
  verified,
  street,
  city,
  region,
  postal_code,
  account_sid
from
  twilio_account_address
where
  not verified;

select
  sid,
  friendly_name,
  customer_name,
  verified,
  street,
  city,
  region,
  postal_code,
  account_sid
from
  twilio_account_address
where
  verified = 0;

List emergency addresses

Explore which accounts have emergency addresses enabled to ensure rapid response capabilities in critical situations. This can be particularly beneficial in managing risk and improving safety measures.

select
  sid,
  friendly_name,
  customer_name,
  emergency_enabled,
  street,
  city,
  region,
  postal_code,
  account_sid
from
  twilio_account_address
where
  emergency_enabled;

select
  sid,
  friendly_name,
  customer_name,
  emergency_enabled,
  street,
  city,
  region,
  postal_code,
  account_sid
from
  twilio_account_address
where
  emergency_enabled = 1;

Schema for twilio_account_address

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_sid	text		The SID of the Account that is responsible for the resource.
city	text		The city in which the address is located.
customer_name	text	=	The name associated with the address.
date_created	timestamp with time zone		The date and time that the resource was created.
date_updated	timestamp with time zone		The date and time that the resource was last updated.
emergency_enabled	boolean		Indicates whether emergency calling has been enabled on this number.
friendly_name	text	=	The string that you assigned to describe the resource.
iso_country	text	=	The ISO country code of the address.
postal_code	text		The postal code of the address.
region	text		The state or region of the address.
sid	text	=	The unique string that identifies the resource.
street	text		The number and street address of the address.
uri	text		The URI of the resource, relative to 'https://api.twilio.com'.
validated	boolean		Indicates whether the address has been validated to comply with local regulation.
verified	boolean		Indicates whether the address has been verified to comply with regulation.

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)" -- twilio

You can pass the configuration to the command with the --config argument:

steampipe_export_twilio --config '<your_config>' twilio_account_address