Table for getting history details of jira data with old value & new value
Connector name:All
Table name:New table
API documentation link: NA
Additional details:
Currently, in the Fivetran history tables (issue_field_history and issue_multiselect_history), data is populated with the newly updated value and the corresponding timestamp for a given Jira Issue ID and field combination.
However, the current schema does not store the previous (old) value when a field value is modified. While it is technically possible to derive the old value through SQL queries on the history tables, doing so introduces significant performance overhead, as these tables are quite large.
In the on-premise Jira database, we were able to retrieve both the old value and new value directly, which greatly simplified reporting and analysis.
Would it be possible to create a new table in the Fivetran database with the following structure?
|
Column Name |
Description |
|
Issue ID |
Jira Issue Identifier |
|
Custom Field ID |
Jira Custom Field Identifier |
|
Old Value |
Previous field value |
|
New Value |
Updated field value |
|
Modified On |
Date and time of modification |
Having such a table would significantly simplify BI reporting and historical analysis while avoiding complex and performance-intensive queries on the existing history tables.
Please sign in to leave a comment.
Comments
0 comments