Question
Connector is failing on the following error and throwing a reconnect task on Fivetran dashboard
Error reading entity from input stream.
How can this be resolved?
Environment
Google Sheets connector
Answer
Authorize the connector using Service Account method.
Cause
Google has a limit of 50 refresh tokens per Google Account per OAuth 2.0 client ID.