Link Firebase to BigQuery

Linking your Firebase project to BigQuery lets you access your raw, unsampled event data along with all of your parameters and user properties.

When you link your Firebase project to BigQuery, you can choose to export Google Analytics for Firebase (including some A/B Testing and Dynamic Links data), Crashlytics, Predictions, Cloud Messaging and/or Performance Monitoring data to corresponding BigQuery datasets on a daily basis.

You can query, export, or join your datasets with data from external sources to perform custom analysis.

In this article:

About BigQuery export

When you export data to BigQuery, you own that data, and you can use BigQuery ACLs to manage permissions on projects and datasets.

You can export Crashlytics, Predictions, Cloud Messaging, and Performance Monitoring data to the BigQuery sandbox free of charge. Data export for Google Analytics for Firebase is only available for projects on the Blaze plan.

With the BigQuery sandbox integration, you have access to:

  • Details from Crashlytics fatal and non-fatal crash events and stack traces
  • Raw Predictions data
  • Detailed Cloud Messaging data
  • Details of each captured Performance event

With the full BigQuery integration available on the Blaze plan, you also gain access to export data from Google Analytics for Firebase, including:

  • Access all 50 event parameters and 25 user properties
  • Generate custom metrics

Learn about BigQuery pricing.

To link your Firebase project and its apps to BigQuery:

  1. Sign in to Firebase.
  2. Click the Settings icon, then select Project Settings.
  3. On the Project Settings page, click the Integrations tab.
  4. On the BigQuery card, click Link.
  • BigQuery charges for storing data, streaming inserts, and querying data. Loading and exporting data are free of charge.
  • By default, all apps in your project are linked to BigQuery and any apps that you later add to the project are automatically linked to BigQuery, as well. You can manage which apps send data.
  • After you link a project to BigQuery, the first daily export of events creates a corresponding dataset in the associated BigQuery project. Then, each day, raw event data for each linked app populates a new table in the associated dataset, and raw event data is streamed into an intraday BigQuery table in real-time. Data prior to linking to BigQuery is not available for import (except for Performance Monitoring data).

Manage which apps send data to BigQuery

To manage which apps in a linked project send data to BigQuery:

  1. Sign in to Firebase.
  2. Click the Settings icon, then select Project Settings.
  3. On the Project Settings page, click the Integrations tab.
  4. On the BigQuery card, click Manage.
  5. In each product card, deactivate exports of an app's data using the toggle next to the app.
  6. Confirm by clicking Stop export.
Unlinking your app(s) stops the corresponding dataset(s) in BigQuery from being populated. However, the dataset(s) will persist and storage and query charges may still apply. You can delete your dataset to prevent further billing.

To unlink your project from BigQuery:

  1. Sign in to Firebase, and open your project.
  2. Click the Settings icon, then select Project Settings.
  3. On the Project Settings page, click the Integrations tab.
  4. On the BigQuery card, click Manage.
  5. In the BigQuery details pane, click Unlink from BigQuery.
  6. Confirm by clicking Unlink BigQuery.
Unlinking your project stops the corresponding dataset(s) in BigQuery from being populated. However, the dataset(s) will persist and storage and query charges may still apply. You can delete your dataset to prevent further billing.
Was this helpful?
How can we improve it?