Streaming Twilio data into Snowflake

Matillion ETL
1

Is anyone stream logging data from Twilio into Snowflake? If so, just curious what solution you're using. Looking for suggestions please.

2

Twilio and Snowflake integration

 

Using APIs to export Twilio data

 

Using the BulkExport API, you can export Twilio data and retrieve all your activity logs continuously from Twilio. You can download the daily message, call, conference, and participant records from BulkExport.

 

After seven days, BulkExport files are automatically deleted. The Twilio backend, however, stores historical data. Data can be generated over a specified period of time using the BulkExport API.

 

  1. A data warehouse to store messaging traffic for analysis.
  2. A compliance store to retain messaging for permanent records.
  3. Requirements to produce data.

 

The data exported using the BulkExport API is available under the following base URL. 

 

https://bulkexports.twilio.com/v1/Exports/<resource_type

 

Regards

Irfan

www.smsala.com