v0.4.0 dbt_twilio

Features

• Added the ability to disable the USAGE_RECORD source table via variable using_twilio_usage_record (default true). If disabled, downstream this will remove the total_account_spend field in twilio__account_overview. Refer to the README for more details.

Under the Hood

• Removes references to unused models in twilio__message_enhanced.

Full Changelog: v0.3.0...v0.4.0

v0.3.0 dbt_twilio

Note: This release is a 🚨 breaking change 🚨 due to breaking changes introduced in the upstream twilio_source package v0.3.0 release, where we explicitly cast the below fields as float types and remove any non-numerical characters.

• queue_time, num_media, num_segments in addition to the existing float-casted duration, price, count, usage fields

• Please be aware if you were expecting string values from these fields.

Full Changelog: v0.2.0...v0.3.0

v0.2.0 dbt_twilio

Note: This release is a 🚨 breaking change 🚨 due to breaking changes introduced in the upstream twilio_source package v0.2.0 release, in which we have updated the stg_*_tmp models to use the dbt_utils.star macro instead of a basic select * (PR #6).

Bug Fixes

• Fixed two testing-related typos in twilio.yml to conform to the dbt YAML file JSON schema (PR #5).
  • This was causing tests to not be run on the message_id column in twilio__message_enhanced nor the account_id field in twilio__account_overview.

Features

• Added the ability to disable models related to the CALL source table. Refer to the README for more details (twilio_source PR #5).
• Ensured Fivetran's Quickstart Data Models would be able to dynamically deploy the above CALL feature (PR #6).

Under the Hood

• Updated the pull request templates (PR #6).
• Included auto-releaser GitHub Actions workflow to automate future releases (PR #6).

Contributors

• @raphaelvarieras (PR #5 and twilio_source PR #5).

Full Changelog: v0.1.0...v0.2.0

v0.1.0 dbt_twilio

Initial Release 🎈

This is the first release of Fivetran Twilio dbt package!

📣 What does this dbt package do?

• Produces modeled tables that leverage Twilio data from Fivetran's connector in the format described by this ERD and builds off the output of our Twilio source package.

The following table provides a detailed list of all models materialized within this package by default.

TIP: See more details about these models in the package's dbt docs site.

Model	Description
twilio__message_enhanced	This model provides additional information of every message sent or received.
twilio__number_overview	This model has aggregate messaging information for each phone number level, such as total messages, total inbound messages, total messages by status, and total spend.
twilio__account_overview	This model provides aggregate information per each account regarding the Twilio Messages resource.

For more information, refer to the README

This version of our dbt package focuses on Twilio's Programmable Messaging product, specifically around the Message Resource.

Submit any feedback you have here in our survey, post in our Fivetran dbt community with questions you might have, or submit any issues you encounter with our package within Github if you need any additional help!