source-jira: unnesting of issue.fields in normalization fails

[caseywhoop]

Environment

• Airbyte version: 0.38.4-alpha
• OS Version / Instance: Default from Airbyte Dockerfile
• Deployment: Kubernetes
• Source Connector and version: Jira 0.2.20
• Destination Connector and version: Redshift 0.3.37 (also replicated with postgres 0.3.19)
• Step where error happened: Normalization

Current Behavior

When syncing the issues table, the issues.fields column contains a nested JSON that should be normalized out into a sub table, issues_fields. Issues_fields is being created, but it only contains the default airbyte columns, and none of the normalized data from issues.fields.

Expected Behavior

I would expect the issues_fields table to contain columns with data from the raw json in issues.fields. I would also expect some error message in the Normalization step of the logs, but it says everything succeeds.

Logs

logs-79.txt

Steps to Reproduce

1. Set up Kubernetes Airbyte deployment
2. Set up JIRA Source with Issues data
3. Set up Redshift or Postgres Destination
4. Sync Jira Issues to Destination with normalization turned on

Are you willing to submit a PR?

Not at the moment

[marcosmarxm]

Duplicated of #8473

[caseywhoop]

@alafanechere and @marcosmarxm I thinkissues.fields and issue.fields are two different source streams. My problem is with issues.fields. I have also tried every sync-mode, my issue is not limited to just the Incremental + Deduped mode.