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 data), Crashlytics, Cloud Messaging, and/or Performance Monitoring data to corresponding BigQuery datasets on a daily basis.

Note: Firebase Dynamic Links is 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
• Link BigQuery to Firebase
• Manage which apps send data to BigQuery
• Unlink BigQuery from Firebase

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, Cloud Messaging, Crashlytics, 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
• Detailed Cloud Messaging data
• Details from Crashlytics fatal and non-fatal crash events and stack traces
• Details of each captured Performance Monitoring event

Learn more about upgrading from the Sandbox and BigQuery pricing.

BigQuery charges for storing data, streaming inserts, and querying data. Loading and exporting data have no cost.

Link a Firebase project to BigQuery

Important: Make sure that you have the required level of access to view or manage settings for data export to BigQuery.

1. Open your project in the Firebase console.
2. Click , then select Project Settings.
3. Click the Integrations tab.
4. On the BigQuery card, click Link.

Note that when you set up export for a product, you select its dataset region. After the dataset is created, the location can't be changed, but you can copy the dataset to a different location or manually move (recreate) the dataset in a different location. To learn more, see Change dataset location in the Firebase documentation.

What happens when you enable export?

• 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 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.

Information specific to Google Analytics export

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:

1. Open your project in the Firebase console.
2. Click , then select Project Settings.
3. 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.

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:

1. Open your project in the Firebase console.
2. Click , then select Project Settings.
3. 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.