Twilio

Creating the data source

Adding the connector

1) Log in to your Twilio account with a user that has administrator permissions

2) On the left-side menu, click Dashboard > Settings > General

3) Find the "API Credentials" > "LIVE Credentials" section and copy the "Account SID" and "Auth Token" values

4) Log in to Kondado, go to the add connectors page and select the Twilio connector

5) In the connector, under "Name" give your connector a name and, under "Account SID" and "Auth Token", paste the values obtained in step (3)

Now just click SAVE to start receiving Twilio data in your Data Warehouse or Data Lake

Pipelines

Summary

Relationship chart

Click to expand

Messages

Replication type: Incremental with update window

Parameters:

  • Read start date (Savepoint): Start date for the data replication
  • Update window (hours): How many hours previous to the message creation date can it still be updated?

Twilio messages with content, timestamps, status, and billing attributes.

Campo Tipo

sid

text

[en] Unique identifier for the message resource.

account_sid

text

[en] Account SID that originated the message.

body

text

[en] Message body text kept for up to 30 days (maximum 1,600 characters).

date_created

timestamp

[en] UTC timestamp when the message record was created.

date_sent

timestamp

[en] UTC timestamp when the message was sent (outbound) or received and forwarded to your system (inbound).

date_updated

timestamp

[en] Most recent UTC timestamp when any message attribute changed.

direction

text

[en] Direction indicator (e.g., inbound, outbound triggered by automation, outbound during a call, outbound reply).

error_code

text

[en] Numeric code returned when status is failed or undelivered (empty if successful).

error_message

text

[en] Description associated with error_code when delivery fails (empty if successful).

from_

text

[en] Originating E.164 number, alphanumeric sender ID, or SIM that initiated the message (retained for up to 120 days).

messaging_service_sid

text

[en] Messaging Service SID used for the message (null when not applied).

num_media

float

[en] Number of media files attached to the message (maximum of 10).

num_segments

float

[en] Number of SMS segments that compose the full message (0 when not applicable).

price

float

[en] Amount charged for the message in the currency defined by price_unit (populated after send).

price_unit

text

[en] ISO 4217 currency code used in price.

status

text

[en] Current message status (accepted, queued, sending, sent, failed, delivered, undelivered, receiving, received, read, etc.).

to_

text

[en] E.164 destination number held for up to 120 days; for inbound traffic it represents the sender.

Notes

  • Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add Twilio as a Data Source on Kondado

Connect your Twilio account to Kondado by extracting API credentials and configuring the source for pipeline creation.

1
Log in to Twilio with admin permissions

Access your Twilio account using a user that has administrator permissions to ensure you can view API credentials.

2
Navigate to API Credentials in Settings

On the left side menu, go to Dashboard > Settings > General and locate the "API Credentials" > "LIVE Credentials" section.

3
Copy Account SID and Auth Token

Copy the "Account SID" and "Auth Token" values from the LIVE Credentials section—these are required for authentication on Kondado.

4
Add Twilio source on Kondado platform

On the Kondado platform, go to the add new sources page and select the Twilio data source connector.

5
Configure and save the data source

Enter a name for your data source, paste the Account SID and Auth Token values, then click SAVE.

6
Create pipelines to your destination

Start building data pipelines to replicate Twilio data to your Data Warehouse, Data Lake, or other destinations.

Frequently asked questions

What Twilio permissions do I need to connect to Kondado?
You need to log in to Twilio with a user that has administrator permissions. This ensures you can access the API Credentials section under Dashboard > Settings > General.
Where do I find my Twilio Account SID and Auth Token?
In your Twilio account, navigate to Dashboard > Settings > General and look for the "API Credentials" > "LIVE Credentials" section. Copy both the "Account SID" and "Auth Token" values.
What Twilio data can I replicate through Kondado pipelines?
You can replicate Twilio Messages data, including fields such as sid, body, date_created, date_sent, direction, status, from, to, price, and more. Some fields like body are available for up to 30 days, while from/to are available for up to 120 days.
Can I send Twilio data to a BI tool or spreadsheet?
Yes. After saving the Twilio source, you can create pipelines to replicate data to your Data Warehouse or Data Lake, then connect to BI tools or spreadsheets for analysis.
Is there a pre-built dashboard for Twilio data?
Yes, you can explore Data Studio dashboards for Twilio or check other report templates available on Kondado to visualize your messaging data.

Written by·Published 2023-06-16·Updated 2026-06-01