- Added explicit float casts to the following numerical fields:
queue_time, num_media, num_segments
in addition to the existingduration, price, count, usage
fields and removed any potential non-numerical characters. These fields are listed as strings by default in the Twilio API, but would only be valuable as numbers. Marked as a breaking change, in case you happen to expect string values from these fields.
- Created a
remove_non_numeric_chars
macro that uses theREGEXP_REPLACE
function to clean up any non-numerical characters from the above fields.
- Under the hood, we've updated the
_tmp
models to use thedbt_utils.star
macro instead of a basicselect *
(PR #6).- This means that you can no longer use
var(<table_name>)
to override the source tables we create staging models from. Instead, see the README for how to use our_identifier
variables.
- This means that you can no longer use
- Removed the deprecated
twilio_using_message
variable. This is a breaking change because you could previously use this variable to disable freshness tests on theMESSAGE
source table. To continue to do so, leverage dbt overrides to setmessage
's freshness tonull
(PR #6).
- Added the ability to disable models related to the
CALL
source table. Refer to the README for more details (PR #5).
- Adjusted the case of loader name from
fivetran
toFivetran
in thesrc_twilio.yml
file (PR #5). - Adjusted the way we dynamically disable source freshness tests for tables that may be missing to use dbt's native
config.enabled
flag (PR #6). - Updated the pull request templates (PR #6).
- Included auto-releaser GitHub Actions workflow to automate future releases (PR #6).
This is the first release of Fivetran Twilio dbt package! For more information, refer to the README