Catch up on everthing we announced at this year's Firebase Summit. Learn more

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:

Enable BigQuery export

  1. Go to the Integrations page in the Firebase console.

  2. In the BigQuery card, click Link.

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

When you link your project to BigQuery:

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

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

  • 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. By default, all web data from your App + Web properties in Google Analytics are exported as well.

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

Pricing and the BigQuery sandbox

If your Firebase project is on the free Spark plan, you can link Crashlytics, Cloud Messaging, Google Analytics, Predictions, and Performance Monitoring to the BigQuery sandbox, which provides free 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, Predictions, and Performance Monitoring to BigQuery. Your use of BigQuery is subject to normal BigQuery pricing, which includes limited free use.