v0.8.1 dbt_github

This release contains the following updates:

Bug Fixes

• Replaced the deprecated dbt_current_timestamp.backcompat() macro with the up-to-date dbt_current_timestamp. The deprecated macro occasionally returned the system timezone instead of the expected UTC timestamp, leading to incorrect downstream metrics like negative values for days_issue_open. (PR #58)
• Updated the join type in int_github__pull_request_times to ensure pull requests without explicitly requested reviewers are no longer dropped. (PR #57)

Under the Hood:

• Added consistency tests for github__issues and github__pull_requests to ensure new changes don't change the output of either model. (Some measures are omitted from the comparison tests, since they're measures based on the current_timestamp, which differs between validation test runs). (PR #58)

Contributors

• @samkessaram (PR #57)

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

v0.8.0 dbt_github

PR #53 contains the following updates:

🚨 Breaking Change 🚨

• For consistency with other Fivetran packages, added default target schemas in dbt_project.yml. This is a breaking change since the model outputs will now be stored in a schema called <your target schema>_github by default. You will need to update any of your downstream use cases to point to the new schema.
  • Refer to the Change the Build Schema section of the README for instructions on how to adjust the output schema.

Under the Hood:

• Updated the maintainer PR template to the current format.
• Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job. (PR #49)
• Updated the quickstart.yml file to allow for automated Quickstart data model deployments. (PR #51)

Contributors

• @rajan-lw (PR #48)

Full Changelog: v0.7.0...v0.8.0

v0.7.0 dbt_github

Hello, friends! This release of the dbt_github package includes the following updates:

🚨 Breaking Change 🚨

• Updated the following models to aggregate at the repository grain in addition to their time period grain. (#42, #43)
  • github__daily_metrics
  • github__weekly_metrics
  • github__monthly_metrics
  • github__quarterly_metrics

🎉 Features

• Added column requested_reviewers to provide a list of users that were requested to review on a pull request. This is to supplement the column reviewers, which provides a list of users that have submitted a reivew, whether or not they were requested to. (#44)
• PostgreSQL compatibility! (#44)

🔧 Bug Fix

• Updated model int_github__pull_request_reviewers so that the list of reviewers generated does not contain duplicate usernames. (#44)

🚘 Under the Hood

• For the metrics models that were updated, added unique-combination-of-column tests for the combination of the time period and repository. (#44)
• Removed uniqueness tests on time period in metrics models in favor of the combo test. (#44)
• Removed ordering in metrics models to improve efficiency. (#44)

📝 Contributors

• @onimsha (#42)

Full Changelog: v0.6.0...v0.7.0

dbt_github v0.6.0

PR #35 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
• 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. #35
• Added Databricks compatibility. #38

dbt_github 0.5.1

Happy Thursday!

This release of the dbt_github package includes the following updates:

Fixes

• The url_link logic within int_github__issue_joined was focused on only providing the correct url for pull requests. This update includes a case when statement to provide the accurate url logic for both Issues and Pull Requests. (#31)

Contributors

• @jackiexsun (#31)

dbt_github 0.5.0

Happy Thursday!

This release of the dbt_github package includes the following updates:

🚨 Breaking Changes 🚨

• The addition of the label source model results in the reference within int_github__issue_label to break. As a result, with the addition of upstream changes within dbt_github_source and the new int_github__issue_label_join model this issue has been resolved. (#26)
  • Please note: It is important you kick off a historical resync of your connector to account for the connector changes from April 2021.

Fixes

• The int_github__issue_comment model was referencing the stg_github__issue_label model to produce the total count of comments. This has been fixed to correctly reference the stg_github__issue_comment model instead. (#26)

dbt_github 0.4.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_github_source. Additionally, the latest dbt_github_source package has a dependency on the latest dbt_fivetran_utils. Further, 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 0.20.0 Compatibility

🎉 dbt 0.20.0 Compatibility 🎉

🚨 This is a breaking change! 🚨 dbt v0.20.0 or greater is required for this release. If you are not ready to upgrade, consider using a previous release of this package.

Additional considerations when upgrading to this package:

• This package utilizes the latest v0.7.x release of the dbt-labls/dbt_utils package. If your project also utilizes a version of the fishtown-analytics/dbt_utils package then you will receive a duplicate package error. If this is the case you will need to consider upgrading your other packages to be compatible with this update or use a previous release of this package.
• Similar to the above point, all previous Fivetran dbt packages utilize the fishtown-analytics/dbt_utils package and you will need to upgrade all Fivetran dbt packages to the latest dbt 0.20.0 compatibility releases in order for your packages to run without package conflicts.

Add Ability to Disable `repo_team` Table

Happy Friday! 🥳

This release addresses issue #17, in which the package failed if you do not have the repo_team source table synced.

If you would like to disable all tables and logic related to repo_team, set the github__using_repo_team variable to false in your dbt_project.yml file.

Source package dependency update

This release contains the following non-breaking changes:

• Update to the packages.yml file to reference any current non-breaking source package releases.