History Tables Are Not Synced for Some Fields

Question

Why are history tables not synced to the destination for all fields in Jira?

Answer

This happens when a field in Jira has a non-array type, meaning only one value can be selected. As such, it will be synced as a column in the ISSUE table. For all field types, it will be synced to the separate ISSUE_[FIELD_NAME] table.

If the value of the field is an entity that has its own properties, (e.g. field_option):

1. The ID of that field will be synced to the table ISSUE or ISSUE_[FIELD_NAME]
2. The properties of that field will be synced to the related dimension table (e.g., the FILE_OPTION table)

If the field value is a string, the ISSUE table will have the field value synced into the field in the related column.