jon-openspace

Morning! No need for history mode - the Github Connector provides an `ISSUE_LABEL_HISTORY` table.  I built a dbt model that gives me what I need yesterday, and I'll schedule...

Here's how I do the staging model (I believe this would go into the [dbt_github_source](https://github.com/fivetran/dbt_github_source) package) ``` with source as ( select * from {{ source('github', 'issue_label_history') }} ), renamed...

Here's how I do the "Time in Label" Model. This gets joined to your existing github__pull_requests model. I believe this would only work with Snowflake, so you would need to...

Finally, I have an Intermediate Model to Pivot the above model. ``` with github_label_history as (select * from {{ ref("github_label_history") }}), pivoted_values as ( select issue_id, {{ dbt_utils.pivot( "this_label_change", dbt_utils.get_column_values(...