SFTP & Google Ads Connectors switching back to JSON

[rodrigo-montalegre]

Environment

• Airbyte version: 0.40.23
• OS Version / Instance: Amazon Linux / AWS EC2
• Deployment: Docker
• Source Connector and version: SFTP bulk 0.1.0 and Google Ads 0.2.5
• Destination Connector and version: Snowflake 0.4.40
• Step where error happened: Sync job

Current Behavior

Setting normalization to "Normalized tabular data" in the Transformation tab of a connection and then clicking on "saved changes" does not remain as "normalized tabular data". The transformation switches back to "Raw data (JSON)". This occurs even after switching to "Normalized tabular data", saving changes, switching to the Status tab and clicking on "Sync now". This does not lead to a syncing error

Expected Behavior

Once selecting "normalized tabular data", the connection should continue loading the data in that format and not as JSON

Logs

Operation itself is not failing

Steps to Reproduce

1. Select one of the sources and establish a connection
2. Set data transformation to normalized
3. Conduct sync
4. Click on transformation tab and see whether normalization has gone back to JSON

[midavadim]

The issue is definitely related to UI of 'Normalization' tab.

But I was not able to re-produce the problem.