search

fivetran / dbt_jira_source

Fivetran's Jira source dbt package
https://fivetran.github.io/dbt_jira_source/
Apache License 2.0
11 stars 11 forks source link

[Feature] Jira Source Package - Field History "Is Active" support #36

Open alastairbulloch opened 1 year ago

alastairbulloch commented 1 year ago

Is there an existing feature request for this?

Describe the Feature

Fivetran's Jira Connector added a new "IS_ACTIVE" column to the ISSUE_FIELD_HISTORY table which (I believe) shows which of the field's history values is the current one.

Can we add this to the Jira Source DBT package so that we can use this column downstream?

It's a much more efficient way of determining the current value for custom fields etc.

Thanks, Ali

Describe alternatives you've considered

I'm going to manually join the DBT source package issue field history model with a homebrewed model that patches in that field...

Are you interested in contributing this feature?

Anything else?

Keep up the good work :)

fivetran-joemarkiewicz commented 1 year ago

Hi @alastairbulloch thanks so much for opening this feature request!

I think this feature request is a very relevant addition to the package and will help with performance of the package to take advantage of this new field as opposed to recreating the field as we currently do in the package code. I will need to do some investigating in order to understand if adding this logic in the connector was rolled out widespread, or just to new connectors.

Nevertheless, we will explore this during the next major update to the Jira package to help with performance. Thank you again for the great suggestion!

elyalvarado commented 9 months ago

This should also be added for the ISSUE_MULTISELECT_HISTORY table, which suffers from the same problem