Table: twilio_account - Query Twilio Accounts using SQL

Twilio Accounts is a resource within Twilio that allows users to manage their account details, status, and usage. It provides a centralized way to monitor and manage account balance, activity, and other related details. Twilio Accounts helps users stay informed about their account status and take appropriate actions when necessary.

Table Usage Guide

The twilio_account table provides insights into the Twilio Accounts. As a developer or account manager, explore account-specific details through this table, including status, balance, and activity. Utilize it to uncover information about account usage and manage the account more effectively.

Examples

Basic info

Explore which Twilio accounts are sub-accounts and their current status. This is useful to understand the hierarchy and health of your Twilio account setup.

select
  friendly_name,
  status,
  is_sub_account
from
  twilio_account;

select
  friendly_name,
  status,
  is_sub_account
from
  twilio_account;

List trial accounts

Discover the segments that are utilizing trial accounts in your Twilio services. This can help assess the elements within your business that are testing or experimenting with Twilio's features, aiding in resource allocation and strategic planning.

select
  sid,
  friendly_name,
  type,
  status,
  is_sub_account
from
  twilio_account
where
  type = 'Trial';

select
  sid,
  friendly_name,
  type,
  status,
  is_sub_account
from
  twilio_account
where
  type = 'Trial';

Schema for twilio_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_sid	text	=, !=, ~~, ~~, !~~, !~~	The SID of the Account that created the resource.
auth_token	text		The authorization token for this account.
date_created	timestamp with time zone		The date and time that the account was created.
date_updated	timestamp with time zone		The date and time that the account was last updated.
friendly_name	text		A human readable description of this account.
is_sub_account	boolean		Indicates whether this account is a sub-account, or not.
owner_account_sid	text		The unique string representing the parent of this account.
sid	text		The unique string that identifies the resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of this account.
sub_resource_uris	jsonb		A list of account instance sub-resources.
title	text		Title of the resource.
type	text		The type of this account.
uri	text		The URI for this resource, relative to 'https://api.twilio.com'.

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