Search
Clear search
Close search
Google apps
Main menu

Link BigQuery to Firebase

Linking BigQuery to your Firebase app lets you access your raw, unsampled event data along with all of your parameters and user properties. When you link a BigQuery project to your Firebase app, Google Analytics for Firebase exports 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 BigQuery to your Firebase project:

  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 are automatically linked to BigQuery as well. You can manage which apps send data.
  • Once an app is linked to BigQuery, a corresponding dataset is 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 stot an app from sending data to BigQuery, turn off the Send data to BigQuery switch.
  6. Confirm by clicking Suspend data.
Unlinking your app(s) stops 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) stops 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?
false