Skip to content
Book a demoStart free
Connectors

Twilio connector

Set up the Twilio connector in Kaivo: authentication, configuration, the 34 BigQuery tables it syncs, and answers to common questions.

Twilio connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Twilio data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your customer support data instead of moving it.

Sync your Twilio calls, messages, and conversations into BigQuery with Kaivo to analyse communications alongside the rest of your data.

CategoryCustomer Service, Tech
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Twilio account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Twilio credentials. You provide:

Field Description
Account ID
Twilio account SID.

| | Auth Token |

Twilio auth token.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

Kaivo syncs 34 tables from Twilio into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

accounts (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
auth_token STRING The authentication token for the account
date_created TIMESTAMP The timestamp when the account was created
date_updated TIMESTAMP The timestamp when the account was last updated
friendly_name STRING A user-defined friendly name for the account
owner_account_sid STRING The SID of the owner account
sid STRING The unique identifier for the account
status STRING The current status of the account
subresource_uris__addresses STRING
subresource_uris__conferences STRING
subresource_uris__signing_keys STRING
subresource_uris__transcriptions STRING
subresource_uris__connect_apps STRING
subresource_uris__sip STRING
subresource_uris__authorized_connect_apps STRING
subresource_uris__usage STRING
subresource_uris__keys STRING
subresource_uris__applications STRING
subresource_uris__recordings STRING
subresource_uris__short_codes STRING
subresource_uris__calls STRING
subresource_uris__notifications STRING
subresource_uris__incoming_phone_numbers STRING
subresource_uris__queues STRING
subresource_uris__messages STRING
subresource_uris__outgoing_caller_ids STRING
subresource_uris__available_phone_numbers STRING
subresource_uris__balance STRING
type STRING The type of the account
uri STRING The URI for accessing the account resource
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
addresses (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier of the account associated with this address.
city STRING The city of the address.
customer_name STRING The name of the customer associated with this address.
date_created TIMESTAMP The date and time when the address was created.
date_updated TIMESTAMP The date and time when the address was last updated.
emergency_enabled BOOL Indicates whether emergency services are enabled for this address.
friendly_name STRING A friendly name or label for the address.
iso_country STRING The ISO 3166-1 alpha-2 country code of the address.
postal_code STRING The postal code of the address.
region STRING The region or state of the address.
sid STRING The unique identifier of the address.
street STRING The street address.
street_secondary STRING Additional information about the street address, such as suite number.
validated BOOL Indicates whether the address has been validated.
verified BOOL Indicates whether the address has been verified.
uri STRING The URI of the address resource.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
alerts (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
log_level STRING The severity level of the alert (info, warning, error)
resource_sid STRING The SID of the specific resource associated with the alert
date_updated TIMESTAMP The date and time when the alert was last updated
account_sid STRING The unique identifier for the account associated with the alert
url STRING The URL or endpoint related to the alert
request_method STRING The method used in the HTTP request that triggered the alert
date_generated TIMESTAMP The date and time when the alert data was generated
alert_text STRING The actual content or text of the alert message
sid STRING The unique identifier (SID) for the alert entry
date_created TIMESTAMP The date and time when the alert was created
request_url STRING The URL that was requested and triggered the alert
service_sid STRING The SID of the Twilio service related to the alert
error_code STRING The code representing the error, if an error occurred
api_version STRING The version of the Twilio API used for the alert
more_info STRING Additional information or details related to the alert
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
applications (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier of the Twilio account associated with the application.
api_version STRING The version of the Twilio API being used for the application.
date_created TIMESTAMP The date and time when the application was created.
date_updated TIMESTAMP The date and time when the application was last updated.
friendly_name STRING A user-friendly name assigned to the application for identification.
message_status_callback STRING The URL where status updates for outgoing messages will be sent.
sid STRING A unique identifier for the application.
sms_fallback_method STRING The HTTP method used to send a fallback URL if an error occurs during SMS delivery.
sms_fallback_url STRING The URL that Twilio will request if an error occurs during SMS delivery.
sms_method STRING The HTTP method used to send SMS messages for the application.
public_application_connect_enabled BOOL Indicates whether public application connect is enabled for the application.
sms_status_callback STRING The URL where status updates for incoming SMS messages will be sent.
sms_url STRING The URL that Twilio will request when receiving an incoming SMS message.
status_callback STRING The URL where status updates for calls will be sent.
status_callback_method STRING The HTTP method used to send status updates for calls.
uri STRING The URI of the application resource.
voice_caller_id_lookup BOOL Indicates whether or not caller ID information will be looked up for incoming calls.
voice_fallback_method STRING The HTTP method used to send a fallback URL if an error occurs during voice call handling.
voice_fallback_url STRING The URL that Twilio will request if an error occurs during voice call handling.
voice_method STRING The HTTP method used for voice call handling.
voice_url STRING The URL that Twilio will request for voice call handling.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
available_phone_number_countries (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
country_code STRING The country code associated with the country.
country STRING The name of the country for which phone number data is provided.
uri STRING The URI to fetch more details about phone numbers in the country.
beta BOOL Whether the phone number country data is in beta phase or not.
subresource_uris__local STRING URI for fetching local phone numbers in the country.
subresource_uris__mobile STRING URI for fetching mobile phone numbers in the country.
subresource_uris__toll_free STRING URI for fetching toll-free phone numbers in the country.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
available_phone_numbers_local (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
friendly_name STRING A user-friendly nickname for the phone number
phone_number STRING The phone number itself
lata STRING Local access and transport area code for the phone number
rate_center STRING Rate center for the phone number
latitude STRING Latitude coordinate of the phone number’s location
longitude STRING Longitude coordinate of the phone number’s location
locality STRING Locality or city associated with the phone number
region STRING Region or state associated with the phone number
postal_code STRING Postal code of the phone number’s location
iso_country STRING ISO country code of the phone number
address_requirements STRING The requirements related to the address associated with the phone number
beta BOOL Indicator showing if the phone number is in beta testing
capabilities__voice BOOL Capability for Voice calls
capabilities__sms BOOL Capability for Short Message Service (Texting)
capabilities__mms BOOL Capability for Multimedia Messaging Service
capabilities__fax BOOL Capability for Facsimile (Faxing)
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
available_phone_numbers_mobile (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
friendly_name STRING A user-friendly name for the phone number
phone_number STRING The phone number in E.164 format
lata STRING Local access and transport area code
rate_center STRING Rate center associated with the phone number
latitude STRING Latitude coordinate of the phone number’s location
longitude STRING Longitude coordinate of the phone number’s location
locality STRING Locality or city where the phone number is based
region STRING Region or state where the phone number is located
postal_code STRING Postal code of the phone number’s area
iso_country STRING The ISO country code for the phone number
address_requirements STRING Address requirements for purchasing the phone number
beta BOOL Indicates if the phone number is in beta testing phase
capabilities__voice BOOL Indicates if voice calling capability is available
capabilities__sms BOOL Indicates if SMS messaging is supported
capabilities__mms BOOL Indicates if MMS messaging is supported
capabilities__fax BOOL Indicates if fax capability is available
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
available_phone_numbers_toll_free (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
friendly_name STRING A user-friendly name associated with the phone number for easy identification.
phone_number STRING The toll-free phone number that can be used for communication.
lata STRING The Local Access and Transport Area code of the phone number’s location.
rate_center STRING The rate center associated with the phone number.
latitude STRING The latitude coordinate of the phone number’s location.
longitude STRING The longitude coordinate of the phone number’s location.
locality STRING The locality (city/town) where the phone number is located.
region STRING The region (state/province) where the phone number is located.
postal_code STRING The postal code of the phone number’s location.
iso_country STRING The ISO country code of the phone number’s location.
address_requirements STRING Specifies the requirements related to the address associated with the phone number.
beta BOOL Indicates if the phone number is in beta testing phase.
capabilities__voice BOOL Indicates if the phone number supports voice calls.
capabilities__sms BOOL Indicates if the phone number supports Short Message Service (text messaging).
capabilities__mms BOOL Indicates if the phone number supports Multimedia Messaging Service.
capabilities__fax BOOL Indicates if the phone number supports fax communication.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
calls (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier for the call.
date_created TIMESTAMP The date and time when the call record was created.
date_updated TIMESTAMP The date and time when the call record was last updated.
parent_call_sid STRING The SID of the parent call if this call is part of a conference.
account_sid STRING The unique identifier for the account associated with the call.
to STRING The phone number that received the call.
to_formatted STRING The formatted version of the ‘to’ phone number.
from STRING The phone number that made the call.
from_formatted STRING The formatted version of the ‘from’ phone number.
phone_number_sid STRING The SID of the phone number used for the call.
status STRING The current status of the call, such as ‘completed’ or ‘in-progress’.
start_time TIMESTAMP The date and time when the call started.
end_time TIMESTAMP The date and time when the call ended.
duration INT64 The duration of the call in seconds.
price FLOAT64 The cost of the call.
price_unit STRING The currency unit of the call cost.
direction STRING The direction of the call, either ‘inbound’ or ‘outbound’.
answered_by STRING The name of the entity or system that answered the call.
annotation STRING Any additional notes or context added to the call.
api_version STRING The version of the Twilio API used for this call.
forwarded_from STRING The phone number that initiated the call forwarding.
group_sid STRING The unique identifier of the call group to which this call belongs.
caller_name STRING The name of the caller as supplied by the caller ID service.
queue_time INT64 The time the call spent in a queue before being answered.
trunk_sid STRING The unique identifier of the trunk used for the call.
uri STRING The URI for this call record.
subresource_uris__recordings STRING URI for call recordings related to this call.
subresource_uris__notifications STRING URI for call notifications related to this call.
subresource_uris__feedback STRING URI for call feedback related to this call.
subresource_uris__payments STRING URI for call payments related to this call.
subresource_uris__siprec STRING URI for call SIP recording related to this call.
subresource_uris__events STRING URI for call events related to this call.
subresource_uris__feedback_summaries STRING URI for call feedback summaries related to this call.
subresource_uris__streams STRING URI for call streams related to this call.
subresource_uris__user_defined_message_subscriptions STRING URI for user-defined message subscriptions related to this call.
subresource_uris__user_defined_messages STRING URI for user-defined messages related to this call.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conference_participants (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier for the Twilio account associated with the conference participant.
call_sid STRING The unique identifier for the call made by the participant.
label STRING A custom label assigned to the participant for identification.
conference_sid STRING The unique identifier for the conference the participant is a part of.
date_created TIMESTAMP The date and time when the participant was added to the conference.
date_updated TIMESTAMP The date and time when the participant’s information was last updated.
end_conference_on_exit BOOL Indicates whether the conference will end when the participant exits.
muted BOOL Indicates whether the participant’s audio is muted.
hold BOOL Indicates whether the participant is on hold.
status STRING The current status of the participant in the conference.
start_conference_on_enter BOOL Indicates whether the conference will start when the participant enters.
coaching BOOL Indicates whether the participant is in coaching mode.
call_sid_to_coach STRING The unique identifier for the call made to the coach.
uri STRING The URI for accessing the details of the conference participant.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conferences (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier of the account associated with the conference.
date_created TIMESTAMP The date and time when the conference was created.
date_updated TIMESTAMP The date and time when the conference was last updated.
api_version STRING The version of the Twilio API used for the conference.
friendly_name STRING A user-defined friendly name for the conference.
region STRING The region where the conference is hosted.
sid STRING The unique identifier (SID) of the conference.
status STRING The current status of the conference.
uri STRING The URI to access the conference resource.
reason_conference_ended STRING The reason for the conference ending, if available.
call_sid_ending_conference STRING The SID of the call that ended the conference, if applicable.
subresource_uris__participants STRING URI to access the participants associated with the conference.
subresource_uris__recordings STRING URI to access the recordings of the conference.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversation_messages (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier of the conversation_message.
account_sid STRING The unique identifier of the account associated with the conversation_messages data.
conversation_sid STRING The unique identifier of the conversation to which the message belongs.
body STRING The textual content of the conversation message.
author STRING The author or sender of the conversation message.
participant_sid STRING The unique identifier of the participant associated with the message.
attributes STRING Additional attributes or metadata related to the conversation message.
date_created STRING The date and time when the message was created.
date_updated STRING The date and time when the message was last updated.
index INT64 The index of the message within the conversation.
delivery__total INT64 Total number of delivery attempts.
delivery__sent STRING Number of successful delivery attempts.
delivery__delivered STRING Whether the message was successfully delivered.
delivery__read STRING Whether the message has been read by the recipient.
delivery__failed STRING Number of failed delivery attempts.
delivery__undelivered STRING Number of undelivered message attempts.
content_sid STRING The unique identifier of the content associated with the conversation message.
url STRING The URL of the conversation message for accessing or viewing.
links__delivery_receipts STRING Receipts and status of message delivery.
links__channel_metadata STRING Metadata specific to the communication channel.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier of the media content.
size INT64 The size of the media content in bytes.
content_type STRING The type of media content attached to the message.
filename STRING The name of the media file.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversation_participants (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The Twilio account SID of the conversation participant.
conversation_sid STRING The SID of the conversation the participant belongs to.
sid STRING The unique SID of the conversation participant.
identity STRING The identity of the participant in the conversation.
attributes STRING Additional attributes related to the conversation participant.
messaging_binding__type STRING The type of the messaging binding (e.g., SMS, email).
messaging_binding__address STRING The address associated with the participant’s messaging binding.
messaging_binding__proxy_address STRING The proxy address for the messaging binding.
role_sid STRING The SID of the role assigned to the participant in the conversation.
date_created TIMESTAMP The date and time when the conversation participant was created.
date_updated TIMESTAMP The date and time when the conversation participant was last updated.
url STRING The URL for accessing more details about the conversation participant.
last_read_message_index STRING The index of the last message that the participant has read.
last_read_timestamp STRING The timestamp when the participant last read a message.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
conversations (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier for the conversation.
account_sid STRING The unique identifier for the account associated with the conversation.
chat_service_sid STRING The SID (Service Identifier) for the chat service to which the conversation belongs.
messaging_service_sid STRING The SID for the messaging service associated with the conversation.
friendly_name STRING A human-readable name assigned to the conversation.
unique_name STRING A unique name assigned to the conversation for easy identification.
attributes STRING Additional attributes or metadata associated with the conversation.
date_created TIMESTAMP The date and time when the conversation was created.
date_updated TIMESTAMP The date and time when the conversation was last updated.
state STRING The current state of the conversation (e.g., active, inactive).
url STRING The URL endpoint for accessing or interacting with the conversation data.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dependent_phone_numbers (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier (SID) for the phone number resource.
account_sid STRING The unique identifier for the account this phone number belongs to.
friendly_name STRING A user-friendly name for the phone number.
phone_number STRING The phone number itself.
voice_url STRING The URL to call when a call comes in to the phone number.
voice_method STRING The HTTP method to use for the voice URL.
voice_fallback_url STRING The URL to call if an error occurs while handling incoming voice calls.
voice_fallback_method STRING The HTTP method to use for the voice fallback URL.
voice_caller_id_lookup BOOL Indicates whether the phone number performs caller ID lookup on incoming calls.
date_created TIMESTAMP The date and time when the phone number was created.
date_updated TIMESTAMP The date and time when the phone number was last updated.
sms_url STRING The URL to call when a message comes in to the phone number.
sms_method STRING The HTTP method to use for the SMS URL.
sms_fallback_url STRING The URL to call if an error occurs while handling incoming SMS messages.
sms_fallback_method STRING The HTTP method to use for the SMS fallback URL.
address_requirements STRING Requirements for the address associated with the phone number.
capabilities__voice BOOL Support for voice calling.
capabilities__sms BOOL Support for text messaging (SMS).
capabilities__mms BOOL Support for multimedia messaging (MMS).
status_callback STRING The URL to send status callbacks to for events related to the phone number.
status_callback_method STRING The HTTP method to use for status callback requests.
api_version STRING The version of the Twilio API being used.
voice_application_sid STRING The SID of the voice application to handle incoming calls.
sms_application_sid STRING The SID of the SMS application to handle incoming messages.
trunk_sid STRING The SID of the Trunk containing this phone number.
emergency_status STRING The emergency status of the phone number.
emergency_address_sid STRING The SID of the emergency address associated with the phone number.
uri STRING The URI of the phone number resource.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
executions (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier for the execution.
account_sid STRING The unique identifier for the account associated with the execution.
flow_sid STRING The unique identifier for the flow associated with the execution.
contact_sid STRING The unique identifier for the contact associated with the execution.
contact_channel_address STRING The contact channel address where the execution is targeted.
status STRING The status of the execution process.
date_created TIMESTAMP The date and time when the execution was created.
date_updated TIMESTAMP The date and time when the execution was last updated.
url STRING The URL endpoint for accessing detailed information about the execution.
links__execution_context STRING Link to the execution context data.
links__steps STRING Link to the steps involved in the execution.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
flows (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING Unique identifier for the flow.
account_sid STRING Unique identifier for the account associated with the flow.
date_created TIMESTAMP Date and time when the flow was created.
date_updated TIMESTAMP Date and time when the flow was last updated.
friendly_name STRING A user-friendly name given to the flow.
status STRING Status of the flow (e.g., active, inactive).
version INT64 Version number of the flow.
url STRING URL endpoint for the flow.
links__steps STRING Link to the steps included in the flow.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
incoming_phone_numbers (40 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The SID of this phone number.
account_sid STRING The SID of the account that owns this phone number.
friendly_name STRING A user-assigned friendly name for this phone number.
phone_number STRING The phone number.
voice_url STRING URL to make requests to when an incoming voice call is received.
voice_method STRING HTTP method to use when making requests to the voice_url.
voice_fallback_url STRING URL to make requests to when an error occurs while processing an incoming voice call.
voice_fallback_method STRING HTTP method to use when making requests to the voice_fallback_url.
voice_caller_id_lookup BOOL Caller ID lookup setting for voice calls made from this phone number.
date_created TIMESTAMP The date and time when this phone number was created.
date_updated TIMESTAMP The date and time when this phone number was last updated.
sms_url STRING URL to make requests to when an incoming SMS message is received.
sms_method STRING HTTP method to use when making requests to the sms_url.
sms_fallback_url STRING URL to make requests to when an error occurs while processing an incoming SMS message.
sms_fallback_method STRING HTTP method to use when making requests to the sms_fallback_url.
address_requirements STRING Indicates the address requirements for this phone number.
beta BOOL Flag indicating beta status of this phone number.
capabilities__voice BOOL Capability for making and receiving voice calls.
capabilities__sms BOOL Capability for sending and receiving SMS messages.
capabilities__mms BOOL Capability for sending and receiving MMS messages.
capabilities__fax BOOL Capability for faxing.
voice_receive_mode STRING Receive mode setting for this phone number.
status_callback STRING URL to make requests to when certain events happen related to this phone number.
status_callback_method STRING HTTP method to use when making requests to the status_callback URL.
api_version STRING The version of the Twilio API being used for this phone number.
voice_application_sid STRING The SID of the application to handle incoming voice calls for this phone number.
sms_application_sid STRING The SID of the application to handle incoming SMS messages for this phone number.
origin STRING Indicates the origin of this phone number.
trunk_sid STRING The SID of the trunk associated with this phone number.
emergency_status STRING Emergency status of this phone number.
emergency_address_sid STRING The SID of the emergency address associated with this phone number.
emergency_address_status STRING Status of the emergency address associated with this phone number.
address_sid STRING The SID of the address associated with this phone number.
identity_sid STRING The SID of the identity associated with this phone number.
bundle_sid STRING The SID of the bundle associated with this phone number.
uri STRING The URI of this phone number.
status STRING Status of this phone number.
subresource_uris__assigned_add_ons STRING URI for accessing assigned add-ons for this phone number.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
keys (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date_created TIMESTAMP The date and time when the key was created.
date_updated TIMESTAMP The date and time when the key was last updated.
friendly_name STRING The user-friendly name associated with the key.
sid STRING The unique identifier for the key (System ID).
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
message_media (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier of the message media.
account_sid STRING The unique identifier of the account associated with this message media.
parent_sid STRING The unique identifier of the parent message associated with this media.
content_type STRING The MIME type of the media content.
date_created TIMESTAMP The date and time when the message media was created.
date_updated TIMESTAMP The date and time when the message media was last updated.
uri STRING The URI that can be used to access this message media resource.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
messages (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier for the account associated with this message.
api_version STRING The version of the Twilio API being used to send or receive this message.
body STRING The text body of the message.
date_created TIMESTAMP The date and time when the message was created.
date_sent TIMESTAMP The date and time when the message was sent.
date_updated TIMESTAMP The date and time when the message was last updated.
direction STRING The direction of the message, whether it’s incoming or outgoing.
error_code STRING The error code associated with the message, if any.
error_message STRING The error message description if the message failed to send.
from STRING The phone number or sender ID that the message originated from.
messaging_service_sid STRING The unique identifier for the messaging service associated with the message.
price_unit STRING The currency unit used for pricing of the message.
num_media INT64 The number of media files (e.g., images, videos) included in the message.
num_segments INT64 The number of message segments if the message exceeds 160 characters.
price FLOAT64 The cost of sending the message.
sid STRING The unique identifier for this message.
status STRING The status of the message (e.g., sent, delivered, failed).
subresource_uris__feedback STRING URI to access feedback related to the message.
subresource_uris__media STRING URI to access media files associated with the message.
to STRING The phone number or recipient ID that the message was sent to.
uri STRING The URI for accessing detailed information about this message.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
outgoing_caller_ids (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier for the Twilio account associated with this outgoing caller ID.
date_created TIMESTAMP The date and time when the outgoing caller ID was created.
date_updated TIMESTAMP The date and time when the outgoing caller ID was last updated.
friendly_name STRING A user-defined friendly name for the outgoing caller ID.
phone_number STRING The phone number associated with the outgoing caller ID.
sid STRING The unique identifier for the outgoing caller ID.
uri STRING The URI for accessing detailed information about the outgoing caller ID.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
queues (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier of the account that owns this queue.
average_wait_time INT64 The average time, in seconds, that callers have spent waiting in this queue.
current_size INT64 The current number of callers waiting in this queue.
date_created TIMESTAMP The date and time when this queue was created.
date_updated TIMESTAMP The date and time when this queue was last updated.
friendly_name STRING A user-defined human-readable name for this queue.
max_size INT64 The maximum number of callers allowed in this queue.
sid STRING A unique identifier for this queue.
uri STRING The URI for this queue resource.
subresource_uris__members STRING A URI to fetch the members (callers) of this queue.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
recordings (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier of the account that owns the recording.
api_version STRING The version of the Twilio API used when the recording was created.
call_sid STRING The unique identifier of the call associated with the recording.
conference_sid STRING The unique identifier of the conference, if the recording is part of a conference.
date_created TIMESTAMP The date and time when the recording was created.
date_updated TIMESTAMP The date and time when the recording was last updated.
start_time TIMESTAMP The date and time when the recording started.
duration INT64 The duration of the recording in seconds.
sid STRING The unique identifier of the recording.
price FLOAT64 The cost of storing the recording.
price_unit STRING The unit in which the cost is measured (e.g., USD).
status STRING The status of the recording (e.g., completed, in-progress).
channels INT64 The number of audio channels in the recording.
source STRING The source of the recording (e.g., twilio).
error_code INT64 The error code, if any, associated with the recording.
media_url STRING The URL where the recording audio file can be accessed.
uri STRING The URI of the recording resource.
encryption_details__type STRING The type of encryption used.
encryption_details__encryption_public_key_sid STRING The SID of the public key used for encryption.
encryption_details__encryption_cek STRING The Content Encryption Key used for encryption.
encryption_details__iv STRING The Initialization Vector used for encryption.
subresource_uris__transcriptions STRING The URI to fetch transcriptions of the recording.
subresource_uris__add_on_results STRING The URI to fetch add-on results related to the recording.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
roles (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier for the role.
account_sid STRING The unique identifier for the account associated with the role.
service_sid STRING The unique identifier for the service associated with the role.
friendly_name STRING A user-friendly name assigned to the role.
type STRING The type or category of the role.
date_created TIMESTAMP The date and time when the role was created.
date_updated TIMESTAMP The date and time when the role was last updated.
url STRING The URL for accessing the role data.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
services (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier of the account related to the service.
consumption_report_interval FLOAT64 The interval at which consumption reports are generated.
date_created TIMESTAMP The date and time when the service was created.
date_updated TIMESTAMP The date and time when the service was last updated.
default_channel_creator_role_sid STRING The default role assigned to the creator of a channel.
default_channel_role_sid STRING The default role assigned to all users in a channel.
default_service_role_sid STRING The default role assigned to users of the service.
friendly_name STRING A user-friendly name given to the service.
limits__channel_members FLOAT64 Maximum number of members allowed in a channel.
limits__user_channels FLOAT64 Maximum number of channels a user can belong to.
links__channels STRING Links related to channels.
links__users STRING Links related to users.
links__roles STRING Links related to roles.
links__bindings STRING Links related to bindings.
notifications__users STRING Users to receive notifications.
post_webhook_url STRING URL for the post webhook.
pre_webhook_url STRING URL for the pre webhook.
pre_webhook_retry_count FLOAT64 Number of retries for the pre webhook.
post_webhook_retry_count FLOAT64 Number of retries for the post webhook.
reachability_enabled BOOL Flag indicating if reachability is enabled.
read_status_enabled BOOL Flag indicating if read status is enabled.
sid STRING The unique identifier of the service.
typing_indicator_timeout FLOAT64 Timeout duration for typing indicators.
url STRING URL of the service.
webhook_method STRING HTTP method used for webhooks.
media__size_limit_mb FLOAT64 Maximum size limit for media in megabytes.
media__compatibility_message STRING Message to display for incompatible media.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
step (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
parent_step_sid STRING The SID of the parent step if this step is nested within another step.
name STRING The name or identifier of the step.
date_updated STRING The date and time when the step was last updated.
transitioned_to STRING The state to which the step transitioned.
account_sid STRING The SID of the account associated with the step data.
url STRING The URL for accessing detailed information about the step.
context STRING Additional context or metadata related to the step.
sid STRING The unique identifier (SID) of the step.
transitioned_from STRING The previous state from which the step transitioned.
date_created STRING The date and time when the step was created.
execution_sid STRING The SID of the execution this step belongs to.
flow_sid STRING The SID of the flow to which this step belongs.
links__step_context STRING Link to additional contextual information related to the step.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transcriptions (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_sid STRING The unique identifier for the account associated with the transcription data.
api_version STRING The version of the Twilio API used for the transcription.
date_created TIMESTAMP The date and time when the transcription was created.
date_updated TIMESTAMP The date and time when the transcription was last updated.
duration INT64 The duration of the audio recording for which the transcription was generated.
price FLOAT64 The cost of the transcription service.
price_unit STRING The currency unit used for pricing the transcription service.
recording_sid STRING The unique identifier for the recording associated with the transcription.
sid STRING The unique identifier for the transcription data.
status STRING The current status of the transcription (e.g., in-progress, completed).
transcription_text STRING The text content of the transcription generated from the audio recording.
type STRING The type of transcription (e.g., automatic, human-generated).
uri STRING The URI where the transcription data can be accessed.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
trunks (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sid STRING The unique identifier for the trunk.
account_sid STRING The unique identifier of the account associated with the trunk.
domain_name STRING The domain name associated with the trunk.
disaster_recovery_method STRING The method used for disaster recovery for this trunk.
disaster_recovery_url STRING The URL set up for disaster recovery in case of trunk failure.
friendly_name STRING A user-friendly name for the trunk.
secure BOOL Indicates whether the trunk connection is secure.
cnam_lookup_enabled BOOL Indicates whether Caller ID Name (CNAM) lookup is enabled for this trunk.
recording__mode STRING The mode used for recording calls on this trunk.
recording__trim STRING Indicates whether recorded calls should be trimmed.
transfer_mode STRING The mode used for call transfer on this trunk.
transfer_caller_id STRING The Caller ID used when transferring calls through this trunk.
auth_type STRING The authentication type used for this trunk.
date_created TIMESTAMP The date and time the trunk was created.
date_updated TIMESTAMP The date and time the trunk was last updated.
url STRING The URL of the trunk.
links__origination_urls STRING Endpoint for managing origination URLs associated with the trunk.
links__credential_lists STRING Endpoint for managing credential lists associated with the trunk.
links__ip_access_control_lists STRING Endpoint for managing IP Access Control Lists (ACLs) associated with the trunk.
links__phone_numbers STRING Endpoint for managing phone numbers associated with the trunk.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
usage_records (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
category STRING The category to which the usage data belongs, such as calls, SMS, or recordings.
count INT64 The number of units consumed in the usage record.
price_unit STRING The currency unit in which the price is denoted, such as USD or EUR.
subresource_uris__yesterday STRING The resource URI for fetching yesterday’s usage records.
subresource_uris__all_time STRING The resource URI for fetching usage records spanning all time periods.
subresource_uris__today STRING The resource URI for fetching today’s usage records.
subresource_uris__yearly STRING The resource URI for fetching yearly usage records.
subresource_uris__this_month STRING The resource URI for fetching usage records for the current month.
subresource_uris__monthly STRING The resource URI for fetching monthly usage records.
subresource_uris__daily STRING The resource URI for fetching daily usage records.
subresource_uris__last_month STRING The resource URI for fetching usage records for the last month.
description STRING A brief explanation or summary of the usage record data.
end_date DATE The end date of the usage record period.
usage_unit STRING The unit of measurement for the usage field, corresponding to the usage count unit.
price FLOAT64 The total price incurred for the consumed units in the usage record.
uri STRING The unique resource identifier for the usage record.
account_sid STRING The unique identifier for the account associated with the usage record.
usage FLOAT64 The total usage value, which could be a cumulative count or a sum of values depending on the category.
start_date TIMESTAMP The start date and time of the usage record period.
count_unit STRING The unit of measurement for the count field, such as minutes, messages, or bytes.
as_of STRING The timestamp indicating the date and time up to which the usage data is accurate.
api_version STRING The version of the Twilio API used in the interaction that generated the usage record.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
usage_triggers (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
usage_record_uri STRING The URI of the associated usage record.
date_updated TIMESTAMP The date and time when the trigger was last updated.
date_fired TIMESTAMP The date and time when the trigger was last fired.
friendly_name STRING A user-friendly name for the trigger.
uri STRING The URI of the usage trigger resource.
account_sid STRING The unique identifier for the account associated with the usage trigger.
callback_method STRING The HTTP method used for callback notifications.
trigger_by STRING The attribute by which the trigger condition is evaluated.
sid STRING The unique identifier for the trigger.
current_value FLOAT64 The current value for the trigger condition.
date_created TIMESTAMP The date and time when the trigger was created.
callback_url STRING The URL where callback notifications are sent.
recurring STRING Indicates if the trigger is set to recur periodically.
usage_category STRING The category under which the usage falls.
trigger_value FLOAT64 The value that triggers the condition.
api_version STRING The version of the Twilio API used for the trigger.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
user_conversations (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
notification_level STRING The level of notification settings for the conversation.
unique_name STRING A unique name assigned to the conversation.
user_sid STRING The unique identifier of the user associated with the conversation.
friendly_name STRING A user-friendly name or alias for the conversation.
conversation_sid STRING The unique identifier of the conversation.
unread_messages_count INT64 The count of unread messages in the conversation.
created_by STRING The user or entity that created the conversation.
account_sid STRING The unique identifier of the Twilio account the conversation belongs to.
last_read_message_index INT64 The index of the last message in the conversation that has been read by the user.
date_created STRING The date and time when the conversation was initially created.
timers__chat_service_sid STRING Additional timer related to the chat service.
url STRING The URL to access the conversation details.
date_updated STRING The date and time when the conversation was last updated.
attributes STRING Additional metadata or attributes associated with the conversation.
participant_sid STRING The unique identifier of the participant in the conversation.
conversation_state STRING The current state or status of the conversation.
chat_service_sid STRING The unique identifier of the chat service associated with the conversation.
links__conversation STRING Link to access detailed information about the conversation.
links__participant STRING Link to access participant information related to the conversation.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
is_notifiable STRING Indicates whether the user is set to receive notifications
date_updated STRING The date and time when the user was last updated
is_online STRING Indicates whether the user is currently online
friendly_name STRING A user-friendly name for the user
account_sid STRING The unique identifier for the user’s account
url STRING URL to access the user’s detailed information
date_created STRING The date and time when the user was created
role_sid STRING The unique identifier for the role assigned to the user
sid STRING The unique identifier for the user
attributes STRING Additional attributes or metadata associated with the user
identity STRING The identity or username of the user
chat_service_sid STRING The unique identifier for the chat service the user is associated with
links__user_conversations STRING URL to retrieve the conversations associated with the user
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
verify_services (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
default_template_sid STRING The unique identifier for the default template used for verification messages.
tts_name STRING The name used for text-to-speech (TTS) in verification calls.
psd2_enabled BOOL Indicates if PSD2 (Payment Services Directive 2) verification is enabled.
do_not_share_warning_enabled BOOL Indicates if the ‘do not share’ warning is enabled for verification codes.
mailer_sid STRING Unique identifier for the mailer service associated with the verify service.
friendly_name STRING A user-friendly name for the verify service.
url STRING The URL associated with the verify service.
account_sid STRING Unique identifier for the account associated with the verify service.
date_updated STRING The date and time when the verify service was last updated.
totp__time_step FLOAT64 The time step interval for generating TOTP codes.
totp__skew FLOAT64 The time skew allowed for TOTP code validation.
totp__code_length FLOAT64 The number of digits in the TOTP (Time-based One-Time Password) code.
totp__issuer STRING The issuer name included in TOTP messages.
code_length FLOAT64 The number of digits in the verification code sent to users.
custom_code_enabled BOOL Indicates whether custom verification codes are enabled.
sid STRING Unique identifier for the verify service.
push__apn_credential_sid STRING Unique identifier for the APN (Apple Push Notification) credential associated with the verify service.
push__include_date BOOL Indicates if the date should be included in push notifications.
push__fcm_credential_sid STRING Unique identifier for the FCM (Firebase Cloud Messaging) credential associated with the verify service.
date_created STRING The date and time when the verify service was created.
dtmf_input_required BOOL Indicates whether DTMF input is required during verification.
skip_sms_to_landlines BOOL Indicates whether SMS messages are skipped for landline numbers during verification.
lookup_enabled BOOL Indicates if phone number lookup is enabled for the verify service.
links__verification_checks STRING Links related to verification checks for the verify service.
links__rate_limits STRING Links related to rate limits for the verify service.
links__entities STRING Links related to entities associated with the verify service.
links__access_tokens STRING Links related to access tokens for the verify service.
links__verifications STRING Links related to verifications performed using the verify service.
links__webhooks STRING Links related to webhooks for the verify service.
links__messaging_configurations STRING Links related to messaging configurations for the verify service.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Twilio supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Twilio?

Section titled “How long does the initial sync take for Twilio?”

It depends on how much history is in your Twilio account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Twilio’s schema changes?

Section titled “What happens when Twilio’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Twilio, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Twilio instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Twilio connector in Kaivo and all of its synced data is deleted with it.

Track calls and messages over time to monitor volume and spend.

Analyse message and call records to monitor delivery and failures.

Report on conversations and conversation_messages to understand customer interactions.

Join Twilio data with your CRM in BigQuery to connect communications to customers.

Once Twilio data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Twilio data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Twilio connector pricing and plan details.

  • HubSpot: Sync HubSpot to BigQuery.
  • Adform: Sync Adform to BigQuery.
  • Amplitude: Sync Amplitude to BigQuery.
  • Auth0: Sync Auth0 to BigQuery.
  • Convex: Sync Convex to BigQuery.
  • Dixa: Sync Dixa to BigQuery.