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 federated queries to query my cloud SQL WordPress database and made a Top Story report in Google Data Studio. Advertisements
Tag: Google Cloud Platform
Regardless of where you hosting your WordPress site, you can use Cloud SQL to be your backend database. In this How-to, I will explain the steps I took to migrate from the WordPress local MySQL to …
There are many CI/CO tools available in the market today like GitLab CI, CircleCI I’m not so much in favor of these CI/CO services even if they have some cool features. I have been a Google …
Tableau is an old product which I worked with from 2009 tills I discovered Data Studio and switched. I will give my view of why I think Data Studio is easier to work with.
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 …
I have recently been working on multiple Google Cloud Platform (GCP) domains, I’m not referring to GCP project I talking about different GCP Domains. I have been working with moln.co and socialclimate.tech. When working with different …
Someone asked me the other day what is Cloud Computing? I told the person that asked the question that clouds computing is the on-demand delivery of computing power, database storage, file storage, applications, and other IT …
This is to follow up on my previous article Detecting non newline delimited JSON file with Google Cloud Dataprep in this article I will show you how to create a Cloud Dataprep recipe that transforms the …
I was recently working on a data project that required us to request data from an internal application using a RESTful API and transform the data to be stored in the Google data warehouse solution BigQuery. …
BigQuery is the Google Cloud Platform data warehouse solution, and setting up datasets you have many options for importing data into a BigQuery table. There are times when you just want to empty a table, to …
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 …
