Question

Google Search Console connector is failing with the Error:

Long term load quota exceeded

How can this be resolved?

Environment

Connector: 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 the 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.