Search code examples
firebasegoogle-bigquerygoogle-analytics

BigQuery stops importing data from Firebase Analytics


My second BigQuery project has stopped importing data from Firebase Analytics. The last import was succeeded 2 weeks ago. But intraday import continue works well. Crashlytics too.

The activity section doesn't contain any relevant information. All limits and quotas don't reach even half.

I use the sandbox version, and I don't have any notifications that could point to any trouble.

My first project on another (company account) stopped to do import a month ago. I've re-linked it, and now BigQuery shows only a 20% of actual data.

What could be the problem? What part of the rules/limits did I miss?


Solution

  • I finally realized that this problem occurs when "OAuth consent screen" is not configured.

    After configuring this through the link https://console.cloud.google.com/apis/credentials/consent everything worked again.

    It seems this was not a requirement in the past and for this reason my older projects were not getting data from firebase into bigQuery.

    The error message shown in BigQuery mentioning the quota limit is completely wrong.

    Ignore the error message and perform the screen configuration of "OAuth consent screen" via the above link.