Twilio connector

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

Written By Lauri Raivio

Last updated 15 days ago

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.

What is the Twilio connector

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

Category	Customer Service, Tech
Authentication	API key
Setup	Self-service

Getting started with the Twilio connector

Sign up for Kaivo and create a workspace.
Connect your Twilio account.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Twilio

Authenticate with your Twilio credentials. You provide:

Field	Description
Account ID	Twilio account SID.
Auth Token	Twilio auth token.

Configuring the Twilio connector

When you set up the connector, you provide:

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

Tables and columns synced from Twilio

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.

Subtable: conversation_messages__media

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.

Subtable: roles__permissions

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.

Subtable: services__webhook_filters

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.

Subtable: trunks__auth_type_set

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.

How the Twilio sync works

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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.

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.

Common use cases for Twilio data

Usage and cost

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

Delivery and quality

Analyse message and call records to monitor delivery and failures.

Conversation analysis

Report on conversations and conversation_messages to understand customer interactions.

Comms and CRM together

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

Use Twilio data in your AI and BI tools

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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.

Was this helpful?

Still need help? Share an idea