Search
Clear search
Close search
Google apps
Main menu

Link BigQuery with Firebase

Linking your Firebase app to BigQuery allows you to access your raw, unsampled event data along with all of your parameters and user properties. Once you link a Firebase app to a BigQuery project, Google Analytics for Firebase will export your event data to a corresponding BigQuery dataset on a daily basis. You can query, export or join your dataset with data from external sources to perform custom analysis.

In this article:

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.

With BigQuery export in Google Analytics for Firebase, you can:

  • Access all 25 event parameters and user properties
  • Generate custom metrics
  • Join your Google Analytics for Firebase dataset with data from external sources, including historical data such as Lifetime Value (LTV)
  • Export your BigQuery dataset to your own custom endpoint

Learn about BigQuery pricing.

To link your Firebase project to BigQuery:

  1. Sign in to Firebase.
  2. Click the Settings icon and select Project Settings.
  3. On the Project Settings page, click the Account Linking tab.
  4. On the BigQuery card, click Link to BigQuery.
    If billing has not already been enabled for your project, click Upgrade to link. You will then be guided through Google's standard billing setup.
  5. Choose whether or not to export Advertising Identifiers as part of your dataset.
  • BigQuery charges for data storage, streaming inserts, and for querying data, but loading and exporting data are free of charge.
  • By default, all apps in your project are linked to BigQuery and any apps that you add to the project will automatically be linked to BigQuery as well. You can manage which apps send data.
  • Once an app is linked to BigQuery, a corresponding dataset will be created in the associated BigQuery project upon the first daily export of events. Each day, raw event data for each linked app populates a new table in the associated dataset, and raw event data is streamed into an intraday BigQuery table in real-time.

Manage which apps send data to BigQuery

To manage which apps in a linked project send data to BigQuery:

  1. Sign in to Firebase.
  2. Click the Settings icon and select Project Settings.
  3. On the Project Settings page, click the Account Linking tab.
  4. On the BigQuery card, click Manage linking.
  5. To halt an app from sending data to BigQuery, unselect the Send data to BigQuery toggle.
  6. Confirm by clicking Suspend data.
Unlinking your app(s) will halt the corresponding dataset(s) in BigQuery from being populated. However, the dataset(s) will persist and storage and query charges may still apply.

To unlink your project from BigQuery:

  1. Sign in to Firebase.
  2. Click the Settings icon and select Project Settings.
  3. On the Project Settings page, click the Account Linking tab.
  4. On the BigQuery card, click Manage linking.
  5. Under Project details, click Unlink project.
  6. Confirm by clicking Suspend data.
Unlinking your app(s) will halt the corresponding dataset(s) in BigQuery from being populated. However, the dataset(s) will persist and storage and query charges may still apply.
Was this article helpful?
How can we improve it?