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?

Having such a table would significantly simplify BI reporting and historical analysis while avoiding complex and performance-intensive queries on the existing history tables.