v0.2.1 dbt_instagram_business_source

PR #9 includes the following updates.

Feature Updates

• Addition of the following fields and accompanying documentation to the stg_instagram_business__media_insights model:
  • reel_comments
  • reel_likes
  • reel_plays
  • reel_reach
  • reel_shares
  • reel_total_interactions

Documentation Updates

• Included documentation for the is_most_recent_record field for the stg_instagram_business__media_insights within the stg_instagram_business.yml docs file.

Contributors

• @Ibrafa (PR #9)

Full Changelog: v0.2.0...v0.2.1

dbt_instagram_business_source v0.2.0

🚨 Breaking Changes 🚨:

PR #5 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"].

Bug Fixes

• Fixed a typo in the custom database variable. Changed from instgram_business_database to instagram_business_database. (#7)

Contributors

• @dougpm (#7)

intagram_business_source 0.1.0

🎉 Initial Release 🎉

This is the initial release of the instagram_business_source dbt package! This package contains staging models, designed to work simultaneously with our Instagram Business modeling package and our Social Media Reporting package. The staging models name columns consistently across all packages:

• Boolean fields are prefixed with is_ or has_
• Timestamps are appended with _timestamp
• ID primary keys are prefixed with the name of the table. For example, the media insights table's ID column is renamed post_id