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 require you to maintain a function, a container, a library, or SDK up to date, which means they need maintenance. …
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.
So, this weekend in early November, I had some free time as it was without any conference speaking opportunity which I usually do. The weekend turned out to be productive as I was able to release the extension after two days of small work. Also, I share a secret, this is my first project written in Typescript that got into “production”. It was a nice way to learn how Typescript works, compiles and runs. …
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.
We will cover 3 ways how to add Data Studio Annotations:
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 add the below…
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: