v0.3.0 dbt_linkedin_pages

PR #12 includes the following breaking changes:

🚨 Breaking Changes 🚨:

• This update is made breaking due to the following changes in the Linkedin Company Pages Fivetran Connector and the dbt_linkedin_pages_source package.
  • Deprecated source table ugc_post_share_content_media
  • Added source table post_content
  • See the May 2023 release notes and the dbt_linkedin_pages_source CHANGELOG for full details.
• In this package, removed the following deprecated columns from linkedin_pages__posts:
  • version_tag
  • specific_content_share_commentary_text
  • title_text
  • original_url

Features:

• Added the following new columns to linkedin_pages__posts:
  • commentary
  • post_title
  • post_type
• Updated documentation with the updated columns.

Under the Hood:

• Updated seeds to reflect the above changes.

PR #10 includes the following updates:

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

Full Changelog: v0.2.0...v0.3.0

dbt_linkedin_pages v0.2.0

🚨 Breaking Changes 🚨:

PR #8 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 has been upgraded, previously [">=0.3.0", "<0.4.0"] now [">=0.4.0", "<0.5.0"]

dbt_linkedin_pages 0.1.1

Happy Wednesday! 🐫

This release of the dbt_linkedin_pages package includes the following updates:

Bug Fixes

• Added an intermediate table that filters the most recent records for ugc_post_history to avoid duplicate rows.

linkedin_pages 0.1.0

🎉 Initial Release 🎉

This is the initial release of the linkedin_pages dbt package! The main focus of the package is to transform the core social media object tables into analytics-ready models that can be easily unioned in to other social media platform packages to get a single view. This is especially easy using our Social Media Reporting package.