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 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, Crashlytics, Cloud 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.
Link a Firebase project to BigQuery
- Open your project in the Firebase console.
- Click , then select Project Settings.
- Click the Integrations tab.
- On the BigQuery card, click Link.
- BigQuery charges for storing data, streaming inserts, and querying data. Loading and exporting data have no cost.
- 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 set up export to BigQuery 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. For Crashlytics, datasets can only be in the United States.
- 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).
Note the following about export of Google Analytics data to BigQuery:
- Firebase supports BigQuery data export for app properties only. BigQuery data export for web and app properties can be set up in GA4.
- By default, all web data from your Google Analytics 4 properties will be exported in the daily export.
- 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.
Manage which apps send data to BigQuery
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 manage which apps in a linked project send data to BigQuery:
- Open your project in the Firebase console.
- Click , then select Project Settings.
- Click the Integrations tab.
- On the BigQuery card, click Manage.
- In each product card, deactivate exports of an app's data using the toggle next to the app.
- Confirm by clicking Stop export.
Note: For export of Google Analytics data, 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.
Unlink a Firebase project from 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.
To unlink your project from BigQuery:
- Open your project in the Firebase console.
- Click , then select Project Settings.
- Click the Integrations tab.
- On the BigQuery card, click Manage.
- In the BigQuery details pane, click Unlink from BigQuery.
- Confirm by clicking Unlink BigQuery.