BigQuery Export for App + Web properties

This help center article is part of the App + Web Property Beta.

App + Web properties are not currently supported in the Analytics app.

BigQuery is a cloud data warehouse that lets you run highly performant queries of large datasets.

You can export all of your raw events from App + Web properties to BigQuery, and then use a SQL-like syntax to query that data. In BigQuery, you can choose to export your data to an external storage or import external data for the purposes of combining it with your Analytics data.

When you export data to BigQuery, you own that data, and you can use BigQuery ACLs to manage permissions on projects and datasets.

A full export of data takes place once a day. Data is also exported continuously about every 15 minutes (see Streaming export below).

You can use the Firebase interface to select which apps export data to BigQuery.

There are no billing charges associated with exporting data from an App + Web property to BigQuery. You can export to a free instance of BigQuery (BigQuery sandbox), but exports that exceed the sandbox limits incur charges.

Streaming export

About streaming export

BigQuery streaming export makes fresher data for the current day available within a few minutes via BigQuery Export.

When you use this export option, BigQuery will have more recent information you can analyze about your users and their traffic on your property.

For each day, streaming export creates two new tables:

  • events_intraday_YYYYMMDD: All records of events for all activity that took place during the day. Data is exported continuously approximately every 15 minutes. Within this table are multiple records of an event when the event spans multiple export operations. This table is deleted when events_YYYYMMDD is complete.
  • events_YYYYMMDD: The full daily export of events.

You should query events_YYYYMMDD rather than events_intraday_YYYYMMDD.

Next steps

Link Firebase to BigQuery.

Related resources

Visit the BigQuery Developers Guide to learn more about:

Was this helpful?
How can we improve it?