fivetran · kristin-bagnall · Oct 23, 2020 · Oct 23, 2020 · Oct 23, 2020
diff --git a/dbt_project.yml b/dbt_project.yml
@@ -13,5 +13,4 @@ models:
 
 vars:
     dbt_utils_dispatch_list:
-        - github    # likely the name of your root project
-        - dbt_utils 
+        - fivetran_utils
diff --git a/macros/_get_utils_namespaces.sql b/macros/_get_utils_namespaces.sql
diff --git a/macros/string_agg.sql b/macros/string_agg.sql
diff --git a/models/intermediate/github_issue_assignees.sql b/models/intermediate/github_issue_assignees.sql
@@ -12,7 +12,7 @@ with issue_assignee as (
 
 select
   issue_assignee.issue_id,
-  {{ string_agg( 'github_user.login_name', "', '" )}} as assignees
+  {{ fivetran_utils.string_agg( 'github_user.login_name', "', '" )}} as assignees
 from issue_assignee
 join github_user on issue_assignee.user_id = github_user.user_id
 group by 1
diff --git a/models/intermediate/github_issue_labels.sql b/models/intermediate/github_issue_labels.sql
@@ -7,6 +7,6 @@ with issue_label as (
 
 select
   issue_id,
-  {{ string_agg( 'label', "', '" )}} as labels
+  {{ fivetran_utils.string_agg( 'label', "', '" )}} as labels
 from issue_label
 group by issue_id
diff --git a/models/intermediate/github_pull_request_reviewers.sql b/models/intermediate/github_pull_request_reviewers.sql
@@ -12,7 +12,7 @@ with pull_request_review as (
 
 select
   pull_request_review.pull_request_id,
-  {{ string_agg( 'github_user.login_name', "', '" )}} as reviewers,
+  {{ fivetran_utils.string_agg( 'github_user.login_name', "', '" )}} as reviewers,
   count(*) as number_of_reviews
 from pull_request_review
 left join github_user on pull_request_review.user_id = github_user.user_id

diff --git a/models/intermediate/github_pull_request_times.sql b/models/intermediate/github_pull_request_times.sql
@@ -33,17 +33,17 @@ with pull_request_review as (
       pull_request.issue_id,
       pull_request.pull_request_id,
       -- Finds the first review that is by the requested reviewer and is not a dismissal
-      case when requested_reviewer_history.requested_id = pull_request_review.user_id then
+      min(case when requested_reviewer_history.requested_id = pull_request_review.user_id then
           case when lower(pull_request_review.state) in ('commented', 'approved', 'changes_requested') 
                 then pull_request_review.submitted_at end 
-      else null end as time_of_first_requested_reviewer_review,
+      else null end) as time_of_first_requested_reviewer_review,
       min(requested_reviewer_history.created_at) as time_of_first_request,
       min(pull_request_review.submitted_at) as time_of_first_review_post_request
     from pull_request
     join requested_reviewer_history on requested_reviewer_history.pull_request_id = pull_request.pull_request_id
     left join pull_request_review on pull_request_review.pull_request_id = pull_request.pull_request_id
       and pull_request_review.submitted_at > requested_reviewer_history.created_at
-    group by 1, 2, 3
+    group by 1, 2
 
 )
 

diff --git a/packages.yml b/packages.yml
@@ -1,3 +1,6 @@
 packages:
   - package: fivetran/github_source
-    version: 0.1.1
+    version: 0.1.1
+
+  - git: https://github.com/fivetran/dbt_fivetran_utils.git
+    warn-unpinned: false