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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
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