Firebase provides tools in the Firebase console you can use to explore and analyze your project's historical data. These tools can answer many questions you might have about how your apps are being used. However, sometimes you want to make your own queries to answer your own questions.
You can do so 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.
Firebase exports data from the following features:
- Cloud Messaging
Enabling BigQuery export
To get started, link your Firebase project to BigQuery from the Integrations section in the Firebase console.
When you link your projects, Firebase exports a copy of your data to BigQuery and, going forward, regularly synchronizes data from your Firebase project to BigQuery.
To deactivate BigQuery export, unlink your projects in the Firebase console. You will also need to delete the Firebase datasets from BigQuery. See Managing Datasets.
Pricing & the BigQuery sandbox
If your Firebase project is on the free Spark plan, you can link Crashlytics, Cloud Messaging, and Predictions to the BigQuery sandbox, which provides free access to BigQuery. See Using the BigQuery sandbox for information on the BigQuery sandbox's capabilities.
If your Firebase project is on a paid plan, you can link Analytics, Crashlytics, Cloud Messaging, and Predictions to BigQuery. Your use of BigQuery is subject to normal BigQuery pricing, which includes limited free use.