v0.5.2 dbt_mailchimp_source

PR #19 includes the following updates:

🐛 Bug Fixes 🔨

• Cast activity_timestamp in stg_mailchimp__campaign_activities and send_timestamp in stg_mailchimp__campaigns to dbt.type_timestamp(). This ensures the dbt.datediff() function in the mailchimp__campaign_activities model in the dbt_mailchimp package properly runs in Redshift.
• Corrected source freshness variables to properly reference mailchimp_using_automations.

🧪 Test Updates 🧪

• Updated the source freshness test enablement/disablement to leverage the dbt-core config: enabled: architecture.
• Added source freshness tests for models utilizing the mailchimp_using_segments variable.

🚘 Under the Hood 🚘

• Updated the pull request templates.
• Included auto-releaser GitHub Actions workflow to automate future releases.

Full Changelog: v0.5.1...v0.5.2

v0.5.1 dbt_mailchimp_source

PR #17 includes the following updates:

🎉 Feature Update

• Updates the unique test for stg_mailchimp__members to include both member_id and list_id, as these make up the unique key for the respective source table

Under the Hood:

• Updates the seed data used in integration testing to include a new record for an existing member_id with a new list_id.

Full Changelog: v0.5.0...v0.5.1

v0.5.0 dbt_mailchimp_source

This release of dbt_mailchimp_source includes the following updates:

🎉 Feature Update

• Databricks compatibility! (#15)

Under the Hood:

• Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job. (#14)
• Updated the pull request templates. (#14)

Full Changelog: v0.4.0...v0.5.0

dbt_mailchimp_source v0.4.0

PR #12 includes the following breaking changes:

🚨 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
• dbt_utils.surrogate_key has also been updated to dbt_utils.generate_surrogate_key. Since the method for creating surrogate keys differ, we suggest all users do a full-refresh for the most accurate data. For more information, please refer to dbt-utils release notes for this update.
• Dependencies on fivetran/fivetran_utils have been upgraded, previously [">=0.3.0", "<0.4.0"] now [">=0.4.0", "<0.5.0"].

🎉 Documentation and Feature Updates 🎉:

• Updated README documentation for easier navigation and dbt package setup.
• Included the mailchimp_[source_table_name]_identifier variables for easier flexibility of the package models to refer to differently named sources tables.

dbt_mailchimp_source 0.3.0

🎉 dbt v1.0.0 Compatibility 🎉

🚨 Breaking Changes 🚨

• Adjusts the require-dbt-version to now be within the range [">=1.0.0", "<2.0.0"]. Additionally, the package has been updated for dbt v1.0.0 compatibility. If you are using a dbt version <1.0.0, you will need to upgrade in order to leverage the latest version of the package.
  • For help upgrading your package, I recommend reviewing this GitHub repo's Release Notes on what changes have been implemented since your last upgrade.
  • For help upgrading your dbt project to dbt v1.0.0, I recommend reviewing dbt-labs upgrading to 1.0.0 docs for more details on what changes must be made.
• Upgrades the package dependency to refer to the latest dbt_fivetran_utils. The latest dbt_fivetran_utils package also has a dependency on dbt_utils [">=0.8.0", "<0.9.0"].
  • Please note, if you are installing a version of dbt_utils in your packages.yml that is not in the range above then you will encounter a package dependency error.

dbt_mailchimp_source 0.2.0

Happy Wednesday! We've got a breaking change below.

🚨 Breaking Change 🚨

• Updating src_mailchimp database variable to reflect README files. Update database to mailchimp_database.(#7).

Contributors

• @dfagnan (#7).

Initial Release

🎉 This is the initial release of this package. 🎉

Happy Friday!
This package is designed enrich your Fivetran data by doing the following:

• 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 will be used in our transform package
• Currently the package supports Redshift, BigQuery, Postgres, and Snowflake.

For more information refer to the CHANGELOG.