This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Category: Google
-
How to build a RESTful API data pipeline with a Firebase Cloud Function and BigQuery
In this article, I will show how I build a data pipeline with a Google Cloud Function. My use case, in this case, was to use a RESTful API to get the data from an external system and create new entries from the data and store it in BigQuery.
-
What Does 2019 Hold for Cloud Providers?
Cloud computing is a concept that’s been around since the 60s. It was only in this century, though, that it became a mainstream reality. What was a somewhat nebulous concept back then has become a multi-billion dollar industry in less than two decades.
-
Wine Regions of the world with Google Data Studio
What is better to do on a frisky spring day, than learning more about Google Data Studio and Colab Notebook. I set to find a dataset that would be interesting to do a report on and writeup a notebook with a word cloud.
-
How to save a Google Colab Notebook as HTML
I have been doing a lot of work with creating Jupyter notebooks and collaborating with the Google Colab service, Colaboratory or short-form Colab is a free Jupyter notebook environment that requires no setup and runs entirely in the cloud.
-
As a developer I love serverless
What to not love about serverless, I don’t see anything, there is no server to set up, no ongoing maintenance tasks required, lower costs as you pay as you go for your server. In the past few years, the servers moved from a server-room in a data center to a cloud service provider, which allows…
-
Creating a table in BigQuery with your Google Sheet data
Did you know that you can link your Google Sheet with a BigQuery table and that any chances that you make in your Google Sheet are automatically updated in the BigQuery table? If you read on, I will provide the instructions on how you can do this, first I will provide some of my views…
-
Connecting your Google Sheet to an external MySQL database
I have been working on a Data Studio project that uses various data sources such as Google Sheet, BigQuery and an external MySQL database. During the project, I came across a few issues with data missing or a date being 0000-00-00 00:00:00 in the dataset, it was Data Studio that flagged a problem and gave…
-
Google Sheet get currency exchange rate with GOOGLEFINANCE formula
Google Sheet get currency exchange rate with GOOGLEFINANCE formula
-
How to setup Google IoT core with BigQuery and an IoT sensor
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 will wait for a pub/sub trigger and store the data in BigQuery and Firebase. This how-to if you go…
-
Google Cloud Storage for your WordPress Media files
I wrote an article recently on how to set up your WordPress site on the Google App Engine. In this article, I like to give you more information on how to set up your image storage for your App Engine WordPress website using the Google Cloud Platform (GCP) Storage and how to configure the WordPress…