BigQuery is a cloud data warehouse that lets you run high performance queries on large datasets.
You can export all of your raw events from Google Analytics properties (including subproperties and roll-up properties ) to BigQuery, and then use an SQL-like syntax to query that data. In BigQuery, you can choose to export your data to external storage or import external data for the purposes of combining it with your Analytics data.
For more information, see BigQuery Export .
