Airbyte OSS - Google Sync

[avaradha]

Hi

I am trying out Airbyte OSS for Google Sync connectivity. I was able to setup Airbyte locally and setup the Google Connector. But when I try to sync a sheet, I see from the logs that it is able to read the metadata (it shows the sheet name, number of records) but the records synced is being shown as 0.

Can you help me to debug this issue?

[avaradha]

After debugging a bit further it seems that there is an issue with syncing google sheets directly to s3. But when we setup up two separate syncs:

1. Google Sheets -> Local File System CSV
2. Local File System CSV -> S3
   This approach works .. Not sure why direct sync doesn't work.

[avaradha]

Found what the issue was. I had setup the Connection but did not select the stream to sync. Once the selected the stream to sync, the records did sync.