Table: twilio_account_bundle - Query Twilio Account Bundles using SQL

Twilio Account Bundles are collections of resources that are grouped together and billed as a single unit. Each bundle is associated with a specific account and can include various types of resources, such as phone numbers, messaging services, and more. Account Bundles provide a consolidated view of resource usage and costs, simplifying billing and resource management for Twilio users.

Table Usage Guide

The twilio_account_bundle table provides insights into account bundles within Twilio. As a DevOps engineer or a cloud accountant, explore bundle-specific details through this table, including the types of resources included in each bundle, their status, and associated costs. Utilize it to monitor resource usage, manage costs, and optimize resource allocation across your Twilio account.

Examples

Basic info

Explore which Twilio account bundles are active and when they will expire. This can help in managing and optimizing your Twilio services effectively.

select
  sid account_sid,
  friendly_name,
  email,
  regulation_sid,
  url,
  valid_until
from
  twilio_account_bundle;

select
  sid,
  account_sid,
  friendly_name,
  email,
  regulation_sid,
  url,
  valid_until
from
  twilio_account_bundle;

List bundles in draft status

Discover the segments that contain draft status bundles in your Twilio account. This is useful for assessing which bundles are yet to be finalized and may require further editing or approval.

select
  sid account_sid,
  friendly_name,
  email,
  regulation_sid,
  url,
  valid_until
from
  twilio_account_bundle
where
  status = 'draft';

select
  sid,
  account_sid,
  friendly_name,
  email,
  regulation_sid,
  url,
  valid_until
from
  twilio_account_bundle
where
  status = 'draft';

Schema for twilio_account_bundle

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_sid	text	=, !=, ~~, ~~, !~~, !~~	The SID of the Account that created the Bundle resource.
date_created	timestamp with time zone		The date and time that the bundle was created.
date_updated	timestamp with time zone		The date and time that the bundle was last updated.
email	text		The email address that will receive updates when the Bundle resource changes status.
friendly_name	text		The string that you assigned to describe the resource.
regulation_sid	text		The unique string of a regulation that is associated to the Bundle resource.
sid	text		The unique string that we created to identify the Bundle resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The verification status of the Bundle resource.
status_callback	text		The URL we call to inform your application of status changes.
url	text		The absolute URL of the Bundle resource.
valid_until	text		The date and time when the resource will be valid until.

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_bundle