v0.7.1 dbt_klaviyo_source

PR #22 introduces the following updates:

🪲 Bug Fixes 🪛

• There were errors customers were encountering where numeric values were not being recognized in property_value, leading to database errors.
• To solve for that, we created the remove_string_from_numeric macro to be used in stg_klaviyo__event, which conducts the following operations:
  • We cast property_value as a string.
  • We then used a regex_replace function to retain only numerical values in these strings across all destinations (i.e. 0-9 values and .).
  • Finally we cast back to a numeric to ensure numeric_value is that particular data type.

🚘 Under the Hood 🚘

• Cast property_value in the integration_tests/dbt_project.yml to ensure the field was originally being cast as a string or varchar data type for testing purposes.
• Updated the event seed file to test for values that aren't numerics.
• Updated the pull request template.
• Included auto-releaser GitHub Actions workflow to automate future releases.

Contributors

• @vnguyen12 #21

Full Changelog: v0.7.0...v0.7.1