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.

Related Articles

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.

REPORTS

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 support@grow.com or chat in on the site.

Did this answer your question?