Welcome to issue #203 August 17th, 2020

After exciting Data Analytics, Data Management and Databases is the topic for this week's OnAir.

News

What’s new and what’s next with data analytics — Next OnAir - See how Google’s cloud data analytics platform, including the BigQuery data warehouse, can help you save time and cost with these Next OnAir sessions.

BigQuery now offers industry-leading uptime SLA of 99.99% - Cloud data warehouse BigQuery now offers a service-level agreement (SLA) of 99.99% from its previous 99.9%. Four nines of availability helps ensure business continuity.

Better BigQuery pricing flexibility with 100 slots - Cloud data warehouse BigQuery offers flat-rate pricing, which you can now use with a minimum of 100 slots.

21 new ways we're improving observability with Cloud Ops - With 21 new features, the Cloud Operations suite helps ensure you have the observability you need into your workloads.

COVID-19 public datasets: our continued commitment to open, accessible data - COVID-19 public datasets from Google Cloud let you explore data for predictive analytics and more. See how news and scientific organizations are using COVID-19 data.

Articles, Tutorials

Infrastructure, Networking, Security, Kubernetes

Understanding IP address management in GKE - Learn techniques for how to prevent running out of IP addresses in GKE environments.

Google Cloud Platform: Resource Labeling Best Practices - The best practices for applying and using labels on your GCP resources.

Multi-Cloud VPN and Multi-Zone Subnetworks — Preparation for Multi-Cloud Database Deployments - A tutorial for setting up a multi-cloud VPN.

Using Custom Metrics to Horizontally Autoscale a Google Kubernetes Engine Deployment. - Setting up custom metrics and configuring a Horizontal Pod Autoscaler to scale your GKE deployment based on the custom metrics.

Creating a Low Cost Managed Kubernetes Cluster for Personal Development using Terraform - Creating a GKE cluster with preemtible nodes using Terraform.

App Development, Serverless, Databases, DevOps

Now it’s personal: Containerizing Java applications with Jib - Jib makes it easy to containerize Java applications, and is now better integrated with other ecosystem tools.

Manage your Remote Config templates from the Admin Node.js SDK - Firebase Remote Config allows developers to control the appearance and the behaviour of their apps without having to publish an app update, is now supported from Admin Node.js SDK.

Rclone Storage bucket sync using Cloud Scheduler and Cloud Run - Basic tutorial to synchronize contents of two Object Storage buckets using Rclone on Google Cloud.

Rsync on GCP Compute Engine: When You Can’t Run Your Code Locally (Network Issues) - Set up SSH and rsync on your Compute VM.

Create Automatic Firestore Backups with GitHub Actions - Using Github Actions to perform periodical Cloud Firestore backups.

Where to Scale Your Workloads - Going through serverless options of where to host a web application.

Deploy a Node API to Cloud Run - Run custom Docker images on Google’s Cloud Run infrastructure.

My 3 years experience in Google Cloud App Engine (Python 2 & Python 3) - Experience of using App Engine with a brief overview.

Using Google Cloud NLP API to analyze writings featured in the Hamilton Broadway Play - A Google Cloud Natural Language Processing project focused on the writings featured in the Hamilton Broadway Play.

How to deploy your Cloud Run service using GitHub Actions - Using GitHub Actions as a CI/CD pipeline in order to deploy automatically Cloud Run app.

Asynchronous downloads from Google Storage with Kotlin - Code sample to download files from Cloud Storage asynchronously.

Are all FHIR APIs the Same? - An in depth analysis of Microsoft Azure’s FHIR API versus Google Cloud’s Healthcare API for FHIR as of August 2020.

Big Data, Analytics, ML&AI

Anomaly detection using streaming analytics & AI - How to build a secure, real-time anomaly detection solution using Dataflow, BigQuery ML and Cloud DLP.

How fleet management gets easier with smart analytics on Google Cloud - Check out this data analytics demo on how to use sensor data to make real-time decisions for a fleet management environment using BigQuery and more.

6 tips for database pros to adapt to cloud data warehouses - Cloud data warehouses bring flexibility and scale, but affect people as well as technology. Here’s how DBAs can adapt and use modern data warehouses.

ETL with Apache Beam — Load Data from API to BigQuery - Reducing time to get data from API to BigQuery using Cloud Dataflow.

Big Data in Google Cloud — Cost Monitoring (part III) - Implementing cost monitoring system for BigQuery.

Slash Google BigQuery Costs with Actionable Recommendations - BigQuery FinOps Dashboard is your Swiss army knife for highlighting inefficiencies in your Google BigQuery usage.

Introducing BQconvert — BigQuery Schema Converter Tool - BQconvert is a Python opensource tool that helps you to convert any database’s schema into BigQuery compatible schema.

Data lake on GCP using Terraform - Using Terraform to set up infrastructure-as-code for a Data Lake on Google Cloud Platform.

I stopped using Firebase Dashboards. I’ve built my own instead. - Displaying Firebase Crashlytics and Performance data in Data Studio.

Accelerating Mayo Clinic’s data platform with BigQuery and Variant Transforms - See how Mayo Clinic uses Google Cloud to work with genomic variant data for research purposes. Cloud data warehouse BigQuery lets them save on costs and time.

A tale of two data warehouses — NewsUK’s data platform migration to Google Cloud (Part 1) - NewsUK’s data platform migration to BigQuery.

How Revionics brings advanced analytics to retailers with help from Google Cloud - See how Revionics migrated to Google Cloud’s BigQuery enterprise data warehouse (EDW) to build data lakes and warehouses to better serve retail customers.

MLB's fan data team hits it out of the park with data warehouse modernization - See how the fan data team at Major League Baseball (MLB) migrated its enterprise data warehouse (EDW) from Teradata to BigQuery.

Scalable Machine Learning with Dask on Google Cloud - A great addition to your arsenal of data science tools, Dask provides you advanced parallelism for computation at scale.

Part IV: Operationalize and Accelerate ML Process with Google Cloud AI Pipeline - Example of AI Platform Pipelines usage.

Training DeepSpeech using TorchElastic - Reduce cost and horizontally scale deepspeech.pytorch using TorchElastic with Kubernetes.

Part III: Building a Machine Learning Models for peptide vaccines with AutoML - AutoML can be used as a quick way to explore data and try to understand what models can be used to perform inference.

Develop, Train and Deploy TensorFlow Models using Google Cloud AI Platform - A practical workflow of TensorFlow model training and deploying.

Various

Helping retailers prepare for the 2020 holiday season - COVID-19’s impact on the retail industry means retailers everywhere are gearing up for an uncertain holiday season. We’re sharing our own research and guidance on how retailers can prepare in our latest ebook.

Dear Google Cloud: Your Deprecation Policy is Killing You - A deep and critical look at GCP deprecations.

5 best study resources for GCP ACE exam - Want to become Google Cloud Certified Associate Cloud Engineer? This post shows 5 best resources to study and pass the exam with ease!

How to Pass- Google Professional Cloud Architect Certification Exam - Be a GCP Jedi! All you need to pass the certification — Updated August 2020.

Slides, Videos, Audio

12 smart analytics sessions to check out at Next OnAir - Check out more than 40 digital sessions on data analytics solutions and topics to learn more about multi-cloud, natural language, and BigQuery, with Google Cloud Next ‘20: OnAir.

GCP Podcast - #231 SpringML and Iron Mountain with Prabhu Palanisamy and Jarrett Garcia.

Kubernetes Podcast - #116 Independent Open Source, with Alex Ellis.

If you have suggestion, feedback or link you want to share feel free to email me at zdenko@gcpweekly.com

Have a great week,

Zdenko