Date: Wed, 01 Sep 2021 00:00:00 +0000
<p>Your hosts <a href="https://twitter.com/stephr_wong">Stephanie Wong</a> and <a href="https://twitter.com/presactlyalicia">Alicia Williams</a> talk about BigQuery Admin Reference Guides with guest <a href="https://twitter.com/leighajarett">Leigha Jarett</a>. 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.</p> <p>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.</p> <p>We wrap up with a discussion on BigQuery APIs and how easy it is to integrate BigQuery and other Google products.</p> <h5 id="leigha-jarett">Leigha Jarett</h5> <p><a href="https://twitter.com/leighajarett">Leigha</a> 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.</p> <h5 id="cool-things-of-the-week">Cool things of the week</h5> <ul> <li>Analyze Cloud Spanner data in BigQuery with federated queries <a href="https://cloud.google.com/bigquery/docs/cloud-spanner-federated-queries"> docs</a></li> <li>Release notes dataset in BigQuery <a href="https://cloud.google.com/bigquery/docs/release-notes">docs</a> and <a href="https://cloud.google.com/feeds/bigquery-release-notes.xml">XML feed</a> <ul> <li>Google Cloud release notes <a href="https://cloud.google.com/release-notes">docs</a> and <a href="https://cloud.google.com/feeds/gcp-release-notes.xml">XML feed</a></li> <li>Release notes in Cloud Console <a href="https://console.cloud.google.com/release-notes?pli=1">site</a></li> <li>Top 25 Google Search terms, now in BigQuery <a href="https://cloud.google.com/blog/products/data-analytics/top-25-google-search-terms-now-in-bigquery"> blog</a></li> </ul> </li> </ul> <h5 id="interview">Interview</h5> <ul> <li>BigQuery Admin Reference Guide Blog Recap <a href="https://cloud.google.com/blog/topics/developers-practitioners/bigquery-admin-reference-guide-recap"> site</a></li> <li>BigQuery Admin Reference Guide blog posts <a href="https://cloud.google.com/blog/search;query=bigquery%20admin%20reference%20guide;paginate=25;order=newest"> site</a></li> <li>BigQuery Spotlight Video Series <a href="https://www.youtube.com/playlist?list=PLIivdWyY5sqLAbIdmcMwsxWg-w8Px34MS"> videos</a></li> <li>BigQuery <a href="https://cloud.google.com/bigquery">site</a></li> <li>BigQuery Documentation <a href="https://cloud.google.com/bigquery/docs">docs</a></li> <li>Cloud Spanner <a href="https://cloud.google.com/spanner">site</a></li> <li>Data Catalog <a href="https://cloud.google.com/data-catalog">site</a></li> <li>Apps Script <a href="https://www.google.com/script/start/">site</a></li> <li>Looker <a href="https://cloud.google.com/looker">site</a></li> </ul> <h5 id="what-s-something-cool-you-re-working-on">What’s something cool you’re working on?</h5> <p>Alicia is building new BigQuery architectures in order to understand the journey and identify potential pain areas that may need more support.</p>
