Your hosts Stephanie Wong and Alicia Williams talk about BigQuery Admin Reference Guides with guest Leigha Jarett. Leigha tells us a bit about the origins of the Admin Reference Guide, which was developed to address frequent customer questions. The series of guides and videos covers onboarding topics from resource hierarchy and APIs to BigQuery tables and storage in an effort to help new admins get started.

The team’s Reference Guide on tables helps admins understand the difference between federated and native tables, and Leigha tells our listeners some tips for using each type. Slots and reservations for workload management in BigQuery can be challenging to understand, but these Reference Guides and accompanying videos offer clear explanations. Optimizing projects for speed and monetary efficiency are important topics for any client, and Leigha and the optimization team have addressed these concerns as well. Tips for monitoring, data governance, and the secure sharing of data are also included in their video series, BigQuery Spotlight.

We wrap up with a discussion on BigQuery APIs and how easy it is to integrate BigQuery and other Google products.

Leigha Jarett

Leigha is a developer advocate on the Google Cloud Data & Analytics team. She focuses on making sure developers using tools like BigQuery and Looker are getting the most possible value from their data.

Cool things of the week


Analyze Cloud Spanner data in BigQuery with federated queries docs
Release notes dataset in BigQuery docs and XML feed


Google Cloud release notes docs and XML feed
Release notes in Cloud Console site
Top 25 Google Search terms, now in BigQuery blog



Interview


BigQuery site
BigQuery Admin Reference Guide blog posts site
BigQuery Spotlight Video Series videos
BigQuery Documentation docs
Cloud Spanner site
Data Catalog site
Apps Script site
Looker site


What’s something cool you’re working on?

Alicia is building new BigQuery architectures in order to understand the journey and identify potential pain areas that may need more support.