Question

Google Search Console connector is failing with the Error:

Long term load quota exceeded

How can this be resolved?

Environment

Google Search Console

Answer

Long term quota error is transient in nature and the connector will succeed in subsequent syncs.

The connector has a retry mechanism built in when quota is exceeded. Fivetran pauses the sync temporarily and then tries again to see if the quota is below the limit. After 5 retries, the connector fails the sync. 

Cause

Load represents the internal resources consumed by a query. 

Long-term quota is measured in 1 day chunks. If you exceed quota when running only a single query inside a 10 minute period, you are exceeding your long-term quota.

Further reading from Google's documentation can be seen here.