In this session, we'll explain how your analytics data is stored in BigQuery and then show you some important tips on working with this data as we create queries to answer your burning mobile analytics questions.

In 2017, Tapjoy migrated Vertica and Hadoop from our on-premises data center into Google Cloud BigQuery and Google Compute Engine. We'd like to share our journey and lessons learned on migration to BigQuery and GCE.

Using examples from the finance and retail industries we will walk through the core products in GCP data platform. The session will cover BigData analytics services such as: BigQuery, Dataflow, Pub/Sub, Dataproc, Dataprep, Datalab, and Datastudio.

Are you ready to take your knowledge of SQL to its final frontiers? Join this session to learn how you can use BigQuery and its SQL 2011 compliant features to tap deep into insights locked away in your spreadsheets, JSON files, and other semi-structured data formats.

This talk, by one of the founders of the BigQuery team and a founder and current CTO of Looker, will make the case that BigQuery is not just another Enterprise Data Warehouse. It will show how BigQuery's unique properties follow from its technical architecture.