BigQuery is Google’s fully managed, petabyte scale, low-cost enterprise data warehouse for analytics. Here are some things you can expect from the BigQuery/Grow integration.
WHAT TO EXPECT
- Unix Epoch Dates: some datatable information fields include creation dates in unix epoch format. This will just look like a string of random numbers. Luckily, there’s a quick way to fix that, either through Grow’s table date format function in the edit metric screen, or with a relatively simple SQL query. For more information on how to set up that query, visit our article in the Grow Help Center.
Below is a list of the reports you can pull from BigQuery, along with a description of the fields available with each report.
- Datasets: All datasets associated with projects under the connected BigQuery account, including kind, dataset ID, dataset reference, and project ID.
- Tables: All tables for the selected dataset, including kind, table ID, project, dataset, table name, type, and unix epoch creation time.
- Table Data: All table data for the selected dataset and table. The fields returned here will vary based on the specifics of the datasets created with BigQuery.
- Custom SQL Query: Write custom SQL queries to hone in on specific fields when building a metric.
Questions about the BigQuery/Grow integration? Email us at email@example.com or chat in on the site.