How to Export Project Data to BigQuery in Firebase

BigQuery is a Google Developers service that allows you to query enormous databases extremely quickly. You can export all of your raw, unsampled events from Google Analytics for Firebase to BigQuery, where you may query the data using a SQL-like syntax. You can opt to export your data to an external storage location or import external data into BigQuery for use with your Analytics data.

BigQuery in Firebase
You control the data you export to BigQuery, and you can manage rights on projects and datasets using BigQuery ACLs. The Firebase console includes tools for exploring and analysing your project's historical data. These tools can assist you in answering a variety of inquiries regarding how your apps are utilised. You may, however, choose to create your own queries to answer your own inquiries.

You may achieve this by importing your project data into BigQuery from Firebase. You may use BigQuery SQL to examine your data or export the data to use with your own tools.

The following Firebase products can be configured to export data to BigQuery via Firebase:
  • Analytics
  • Cloud Messaging
  • Crashlytics
  • Performance Monitoring
  • Predictions
  • A/B Testing

Enable BigQuery export

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

Step 2: Click Link in the BigQuery card.

Step 3: To enable BigQuery, follow the on-screen instructions.

When you connect your project to BigQuery, you'll see the following:

  • BigQuery exports a copy of your existing data from Firebase.
  • Firebase syncs your data from your Firebase project to BigQuery on a daily basis.
  • All applications in your project are linked to BigQuery by default, and any apps you add later are automatically linked to BigQuery. You have control over which apps send data. All web data from your App + Web properties in Google Analytics is automatically exported.

You can use the BigQuery sandbox integration to access:

  • Google Analytics 4 properties data.
  • For Firebase, data from Google Analytics.
  • Crashlytics fatal and non-fatal crash events, as well as stack traces.
  • Predictions data in its raw form.
  • Data on Cloud Messaging in great detail.
  • Details of each Performance Monitoring event that was recorded.

Link a Firebase Project to BigQuery

To connect your Firebase project and associated apps to BigQuery, follow these steps:

Step 1: Log in to your Firebase account.
Step 2: Select Project Settings from the Settings menu.
Step 3: Click the Integrations tab on the Project Settings page.
Step 4: Click Link on the BigQuery card.

BigQuery has fees for storing data, inserting data in real time, and searching it. Data loading and exporting are both free.

All applications in your project are linked to BigQuery by default, and any apps you add later are immediately linked to BigQuery as well. You have control over which apps send data.

The initial daily export of events once you link a project to BigQuery creates a corresponding dataset in the linked BigQuery project. The raw event data for each linked app is then streamed into a separate intraday BigQuery database in real-time each day, populating a new daily table in the associated dataset.

Manage which apps send data to BigQuery

To control which apps in a linked project submit data to BigQuery, follow these steps:

Step 1: Log in to your Firebase account.
Step 2: Select Project Settings from the Settings menu.
Step 3: Click the Integrations tab on the Project Settings page.
Step 4: Click Manage on the BigQuery card.
Step 5: Deactivate exports of an app's data using the toggle next to the app in each product card.
Step 6: Stop the export if you're sure.

Control the export of web streams from the related Firebase project and the corresponding Google Analytics 4 property with the Streams in this project option.

Unlinking your app(s) prevents BigQuery from populating the corresponding dataset(s). The dataset(s) will, however, survive, and storage and query fees may still apply. To avoid ongoing billing, you can delete your dataset.

Unlink a Firebase project from BigQuery

To unlink your project from BigQuery, follow these steps:

Step 1: Log in to Firebase and start working on your project.
Step 2: Select Project Settings from the Settings menu.
Step 3: Click the Integrations tab on the Project Settings page.
Step 4: Click Manage on the BigQuery card.
Step 5: Click Unlink from BigQuery in the BigQuery information box.
Step 6: Click Unlink BigQuery to confirm.

Pricing and the BigQuery sandbox

You may attach Crashlytics, Cloud Messaging, Google Analytics, Predictions, and Performance Monitoring to the BigQuery sandbox, which gives you free access to BigQuery, if your Firebase project is on the free Spark plan. For more information on the BigQuery sandbox's features, see Using the BigQuery Sandbox.

A/B Testing, Crashlytics, Cloud Messaging, Google Analytics, Predictions, and Performance Monitoring can all be linked to BigQuery if your Firebase project is on a premium plan. BigQuery usage is subject to standard BigQuery pricing, which includes a limited amount of free usage.

Post a Comment

Previous Post Next Post