v0.2.1 dbt_recurly_source

Happy National Crunchy Taco Day! 🌮 Do you hear the sound of the bell? 🔔

Here are the latest dbt_recurly_source package updates!

🪲 Bug Fixes 🔧

• Added invoice_id to the unique_combination_of_columns test on stg_recurly__invoice_coupon_redemption_history to handle cases where coupon redemptions are applied to multiple invoices. Also modified relevant seed files to test these changes (PR #11).
• Added currency to the unique_combination_of_columns tests on stg_recurly__account_balance_history and stg_recurly__plan_currency_history to account for plans and account balances that hold multiple currencies. Also modified relevant seed files to test these changes (PR #11).

👷 Contributors

• @benigls (PR #11)

dbt_recurly_source v0.2.0

🚨 Breaking Changes 🚨:

PR #7 includes the following breaking changes:

• Dispatch update for dbt-utils to dbt-core cross-db macros migration. Specifically {{ dbt_utils.<macro> }} have been updated to {{ dbt.<macro> }} for the below macros:
  • any_value
  • bool_or
  • cast_bool_to_text
  • concat
  • date_trunc
  • dateadd
  • datediff
  • escape_single_quotes
  • except
  • hash
  • intersect
  • last_day
  • length
  • listagg
  • position
  • replace
  • right
  • safe_cast
  • split_part
  • string_literal
  • type_bigint
  • type_float
  • type_int
  • type_numeric
  • type_string
  • type_timestamp
  • array_append
  • array_concat
  • array_construct
• For current_timestamp and current_timestamp_in_utc macros, the dispatch AND the macro names have been updated to the below, respectively:
  • dbt.current_timestamp_backcompat
  • dbt.current_timestamp_in_utc_backcompat
• Dependencies on fivetran/fivetran_utils have been upgraded, previously [">=0.3.0", "<0.4.0"] now [">=0.4.0", "<0.5.0"].

dbt_recurly_source v0.1.0

🎉 New dbt Recurly Source Package! 🎉

Happy Halloween 👻 ! We're excited to introduce the not-so-spooky Recurly source package!

This package is designed to enrich your Fivetran Recurly data by doing the following:

• Cleans, tests, and prepares your Recurly data from Fivetran's connector for analysis.
• Add descriptions to tables and columns that are synced using Fivetran.
• Add freshness tests to source data.
• Add column-level testing where applicable. For example, all primary keys are tested for uniqueness and non-null values.
• Model staging tables which leverage data in the format described here, which can then be used simultaneously with our Recurly modeling transformation package.
• Currently the package supports Postgres, Redshift, BigQuery, Databricks, and Snowflake. Additionally, this package is designed to work with dbt versions [">=1.0.0", "<2.0.0"].

For more information, refer to the README.

Submit any feedback you have here, book a time during our office hours using Calendly or email us at solutions@fivetran.com if you have questions or need help!

Contributors

• Thanks to @dimoschi for submitting the initial source request and getting Recurly package development off the ground! (#1)