Link BigQuery to Firebase

Linking Firebase to BigQuery lets you do the following:

  • Analyze your raw data with your own queries using BigQuery SQL.
  • Export the data to use with your own tools.

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

Note: Firebase Dynamic Links is currently deprecated. Learn more about these changes.

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 Google Analytics, CrashlyticsCloud Messaging, and Performance Monitoring data to the BigQuery sandbox at no cost (Sandbox limits apply).

With the BigQuery sandbox integration, you have access to:

  • Data from Google Analytics
  • Details from Crashlytics fatal and non-fatal crash events and stack traces
  • Detailed Cloud Messaging data
  • Details of each captured Performance Monitoring event

Learn more about upgrading from the Sandbox and BigQuery pricing.

Firebase supports BigQuery data export for app properties only. BigQuery data export for web and app properties can be set up in GA4.

 Note: Make sure that you have the required level of access to view or manage settings for data export 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 have no cost.
  • Exports of Google Analytics data into BigQuery are limited to 1 million events per day. You can use event filtering to limit the number of events that are exported. To learn more, see Data filtering. There is no limit for Google Analytics 360 users.
  • 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.
  • When you enable BigQuery export for Google Analytics, Performance Monitoring, and Cloud Messaging, you select the dataset region. After the dataset is created, the location cannot be changed, but you can copy the dataset to a different location, or manually move (recreate) the dataset in a different location.
  • 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 daily table in the associated dataset, and raw event data is streamed into a separate intraday BigQuery table in real-time. Data prior to linking to BigQuery is not available for import (except for Performance Monitoring data). By default, all web data from your Google Analytics 4 properties will be exported as well.

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.

Use the Streams in this project switch to control the export of web streams from the associated Firebase project and the associated Google Analytics 4 property.

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?
Search
Clear search
Close search
Google apps
Main menu
12079637133745790256
true
Search Help Center
true
true
true
true
true
5054967
false
false