Export project data to BigQuery

Firebase provides tools in the Firebase console to explore and analyze your project's historical data. These tools can help you answer many questions about how your apps are being used. Sometimes, though, you also want to set up your own queries to answer your own questions.

You can do this by exporting your project data from Firebase into BigQuery. With BigQuery, you can analyze your data with BigQuery SQL or export the data to use with your own tools.

You can configure Firebase to export data to BigQuery from the following Firebase products:

• Analytics
• Cloud Messaging
• Crashlytics
• Performance Monitoring
• A/B Testing
• Remote Config personalization

Required permissions and suggested roles

To view or manage settings for data export to BigQuery, you must have the required level of access.

If you don't have the necessary Firebase access, you can ask a Firebase project Owner to assign you the applicable role via the Firebase console IAM settings. If you have questions about accessing your Firebase project, including finding or assigning an Owner, review the Permissions and access to Firebase projects FAQs.

Project-level

The following table applies to the top-level linking of a Firebase project to BigQuery.

Action in Firebase console	Required IAM permission	IAM role(s) that include required permissions by default	Additional required roles
Link a Firebase project and BigQuery	firebase.links.create	Owner Firebase Admin	none
Unlink a Firebase project and BigQuery	firebase.links.delete	Owner Firebase Admin	none
View the existing links for BigQuery	firebase.links.list	Any basic role (Owner, Editor, or Viewer) Any Firebase-level role Any Firebase product-category role	none

Google Analytics

The following table applies specifically to the export of Google Analytics data to BigQuery.

Action in Firebase console	Required IAM permission	IAM role(s) that include required permissions by default	Additional required roles
Enable export of Google Analytics data to BigQuery	firebase.links.update AND serviceusage.services.enable	Owner Firebase Admin AND Service Usage Admin	Google Analytics: Equivalent of account Administrator or Editor for the linked Google Analytics property See note below.
Enable export for specific Firebase apps	firebase.links.update	Owner Firebase Admin	Google Analytics: Equivalent of account Administrator or Editor for the linked Google Analytics property See note below.
Disable export for specific Firebase apps	firebase.links.update	Owner Firebase Admin	Google Analytics: Equivalent of account Administrator or Editor for the linked Google Analytics property See note below.

Note: To enable or disable export in the Google Analytics UI, you need the explicit Administrator or Editor role for the linked Google Analytics property. However, Firebase access is not required.

Firebase products

The following table applies to any of the Firebase products for which you can export data to BigQuery, for example, Crashlytics or Performance Monitoring.

Action in Firebase console	Required IAM permission	IAM role(s) that include required permissions by default	Additional required roles
Enable export of a product's data to BigQuery	firebase.links.update	Owner Firebase Admin	none
Enable export for specific Firebase apps	firebase.links.update	Owner Firebase Admin	none
Disable export for specific Firebase apps	firebase.links.update	Owner Firebase Admin	none

Enable export to BigQuery

1. In the Firebase console, go to the Integrations page.

2. In the BigQuery card, click Link.

3. Follow the on-screen instructions to enable export to BigQuery.

Here's what happens when you enable export to BigQuery:

• You select the dataset location. 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.

  Note: The capability to select the location for a dataset is available for Google Analytics, Performance Monitoring, and Cloud Messaging.
  Crashlytics only supports exporting data to the United States.

• 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. You can manage which apps send data.

• Firebase exports a copy of your existing data to BigQuery.

• Firebase sets up daily syncs of your data from your Firebase project to BigQuery.

  Note: 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.

To deactivate exports to BigQuery, unlink your project in the Firebase console.

Change dataset location

After you enable a product for BigQuery export and create a dataset, you can't change the location of that dataset. However, you can copy your existing dataset to a new dataset that has a different location. To learn about BigQuery dataset locations, see Dataset locations.

Note: The capability to select and change the location for a dataset is only available for Google Analytics, Performance Monitoring, and Cloud Messaging.
Crashlytics only supports exporting data to the United States.

Make sure that you follow all of the instructions in these procedures; overlooking a step might result in data loss.

Select the product for which you want to change the location of your dataset.

Google Analytics Performance Monitoring Cloud Messaging

Pricing and the BigQuery sandbox

If your Firebase project is on the no-cost Spark plan, you can link Crashlytics, Cloud Messaging, Google Analytics, and Performance Monitoring to the BigQuery sandbox, which provides no-cost access to BigQuery. Refer to Using the BigQuery sandbox for information on the BigQuery sandbox's capabilities.

If your Firebase project is on a paid plan, you can link A/B Testing, Crashlytics, Cloud Messaging, Google Analytics, and Performance Monitoring to BigQuery. Your use of BigQuery is subject to normal BigQuery pricing, which includes limited no-cost use.