fivetran/dbt_shopify v0.8.1

v0.8.1 dbt_shopify

on GitHub

PR #58 applies the following changes:

Bug Fixes

• Adjusts the int_shopify__customer_email_rollup model to aggregate distinct customer_ids.
• Ensures that each order is tagged with the orderer's email before aggregating order metrics in int_shopify__emails__order_aggregates.

Under the Hood

• Ensures transaction kinds are being read correctly by applying a lower() function.
• Removes unused and potentially problematic fields from int_shopify__customer_email_rollup. The removed fields include orders_count and total_spent, which are actually calculated in int_shopify__emails__order_aggregates before being passed to shopify__customer_emails (which is unaffected by this change).
• Removes updated_timestamp and created_timestamp from shopify__customer_emails. Refer to the following fields instead:
  • first_account_created_at
  • last_account_created_at
  • last_updated_at
• Incorporates the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job (PR #57).
• Updates the pull request templates (PR #57).

Related-Package Releases:

• https://github.com/fivetran/dbt_shopify_holistic_reporting/releases/tag/v0.4.0

Full Changelog: v0.8.0...v0.8.1