SFTP & Google Ads Connectors switching back to JSON

## 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