Connector name: 

Jira - Jira Cloud

Table name:

ISSUE (jira.issue)

Column to add:

is_archived - a proposed Boolean column indicating whether an individual issue is currently archived.

API documentation link: 

Jira Cloud REST API — Export archived issues

The documented export includes archival information such as ArchivedBy and ArchivedDate. The proposed is_archived column would require Fivetran to detect and maintain the issue’s archive state.

Additional details:

Requested behavior:

• Identify existing and newly archived issues.

• Update the flag when an issue is restored.

• Keep archive status separate from _fivetran_deleted.

Business impact:

Archived tickets remain in our synced data without a reliable archive indicator. For example, BCI-234 is archived in Jira but remains included in our reporting.

We have multiple affected tickets, making a manual exclusion list difficult to maintain. Automatic archive tracking would help us keep ticket counts and defect-density reporting accurate.