This was a very interesting project that I worked on, the use case for the project was to make the maritime noon report data available in Google BigQuery, sounds simple enough. However there were a lot of requirements, from collecting application data from the Greenpeace fleet in different formats leveraging Cloud Functions and API calls, landing the data in Cloud Storage, normalizing the data for reporting and translating each different ships’ schemas into one common schema in BigQuery thanks to …
Tag: Google
Find everything Torbjorn has written about Google
In this how-to article, I’m going to show how you can secure your Google Cloud Platform (GCP) Functions HTTP trigger, it has not been that straight forward to secure HTTP trigger in Cloud Functions in the …
BigQuery has added a new feature, in which you can connect to a Cloud SQL instance and make federated queries. In this how-to, I will explain how I made an external connection from BigQuery, then using …
There are times when you write a cloud function that you need to protect an API key, account information user id and password, or other sensitive data. In the Google Cloud Platform (GCP) you can use …
In this article, I will explain how you can create a Google Cloud Platform (GCP) Cloud Function that you can use to cap the cost if the cost is higher than the budget the billing will …
You are getting into Data Science, you are looking for datasets that you could use for your own learning and to sharpen your skills, Google has you covered. In this article I will tell you about …
Google Sheet get currency exchange rate with GOOGLEFINANCE formula …
In this how-to, I will show you how to set up an IoT sensor connects it to the Google Cloud Platform IoT core send the data to Google Cloud Pub/Sub. Then code a cloud function, that …
It’s a great time to start planning your infrastructure project to move to the cloud or if you starting a business you could just avoid the hassle to setup and manage your internal infrastructure by adopting …
The other day at work, I was going to help a young fellow with a problem with a WordPress website, he had been referred by a colleague of mine, when this young fellow some – he …
You might not be aware of this or just don’t think about it, if you use your Gmail account, on the web, iOS or Android, Google collects a lot of data from you. …