Backup every night your Firestore collections to secure Cloud Storage the easy way with Cloud Workflows, you don’t need to be a developer to setup the steps.

Firestore Backups the easy way with Cloud Workflows
Firestore Backups the easy way with Cloud Workflows
Firestore Backups the easy way with Cloud Workflows

Database Backups! We know how important they are, a wrong click and someone could delete your collection or the entire database. In the case of a Disaster Recovery Plan is activated you need to have your backups to resume business operation.

Let’s make sure your Firestore/Datastore collections backup every night to secure storage.

Introduction

There are various ways to trigger Cloud Firestore backups, either by using Datastore Import/Export UI, the firebase CLI tool, or…


Automate the execution of shell commands in a fully serverless and secure way without managing private keys. What a joy for a Cloud Architect to work with.

Cloud Workflows — automate the execution of shell commands on VMs

Sometimes, as part of a workflow process, it is necessary to connect to a VM in order to perform different tasks. We are going to cover connecting to a Linux VM and performing different tasks like copying files, or a script to import/update a database by using Cloud Workflows.

This article covers how to define Cloud Workflow to start a VM machine, connect to the Compute Engine shell, execute shell commands securely with…


Loading Data Into BigQuery From Cloud Storage by using Cloud Workflows.
Loading Data Into BigQuery From Cloud Storage by using Cloud Workflows.
Loading Data Into BigQuery From Cloud Storage by using Cloud Workflows.

In this article, we will orchestrate and automate Google Cloud with serverless workflows.

We will create a Cloud Workflow to load data from Google Storage into BigQuery. This is a complete guide on how to work with workflows, connecting any Google Cloud APIs, working with subworkflows, arrays, extracting segments, and calling BigQuery load jobs.

There are various ways to process Cloud Storage files to BigQuery such as using a Cloud Function, by Eventarc triggers to Cloud Run services, a relatively new syntax is by using BigQuery create external table statement or the good old way via BQ CLI tool.

These…


Writing, debugging and deploying from Visual Studio Code for Google Cloud Platform is working out great as you have multiple options to interact with Google Cloud products:

All these work based on the project that your environment is setup.

However, the VS Code screen was missing key info: displaying the current project. There was no easy way to switch projects from the IDE. Until now!

Introducing the “GCP Project Switcher” extension for VS Code.

Introducing “GCP Project Switcher” extension for VS Code.
Introducing “GCP Project Switcher” extension for VS Code.
“GCP Project Switcher” extension for VS Code

A weekend project with Typescript

So, this weekend in early…


At the time of the writing Data Studio doesn’t offer out of the box Annotations on time series charts. You can however add your annotations as seen below in easy ways.

Timeseries chart with two annotations applied
Timeseries chart with two annotations applied
Time series chart with two annotations applied

We will cover 3 ways how to add Data Studio Annotations:

  • Adding by using a calculated field
  • Using a CSV file and data source blending
  • Using Google Sheets, some optional pivoting and data source blending

1. Add Annotation by using calculated field

To get going, Edit your data source (with the Pencil icon ), when you see your current fields, find and choose Add a field, name it after your event eg: Google Algorithm Update and…


Waze introduced in their mobile apps around 2018 routing options that enable to you set Vignettes to enable use of toll roads.

This was a mobile first feature, so the web version of their Livemap didn’t had this feature, and by default it routes without toll roads — omitting motorways, bridges and so on, which yields crappy routes.

To get Livemap to use the vignettes and return the toll roads, use the following link:

https://www.waze.com/livemap?rp_subscription=*

Márton Kodok

Speaker at conferences, a Google Developer Expert top user on Stackoverflow, software architect at REEA.net, co-founder IT Mures, life-long learner, mentor

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store